Hi,
Normally Inputbox has one editbox, how can have more editbox in one inputbox
?
Please help by giving example.
Regards,
Magix
Earl Kiosterud - 11 Dec 2005 16:30 GMT
Magix,
For this you would create your own UserForm (in the VBE) and write the code
to show it, look at the user input, etc.
Earl Kiosterud
www.smokeylake.com
> Hi,
>
[quoted text clipped - 5 lines]
> Regards,
> Magix
Bob Phillips - 11 Dec 2005 16:31 GMT
You would need to build a custom userform to handle it.

Signature
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
> Hi,
>
[quoted text clipped - 4 lines]
> Regards,
> Magix
David McRitchie - 11 Dec 2005 16:41 GMT
You can't change InputBox to have more than one text input area.
You can use separators and parse the argument into several parts.
You alternatives include
Using an area in the worksheet, or any other worksheet.
Using Forms
A quick search turned up this one, might be of interest
J-Walk Enhanced Data Form v2 (addin)
http://www.j-walk.com/ss/dataform/
http://www.j-walk.com/ss/dataform/features.htm
Excel -- Create an Order Form [ http://www.contextures.com/tiptech.html ]
http://www.contextures.com/xlOrderForm01.html
Flash presentations look for "Building Excel Applications"
http://www.datapigtechnologies.com/ExcelMain.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> Hi,
>
[quoted text clipped - 4 lines]
> Regards,
> Magix