InputBox

[magix]

Hi,

Normally Inputbox has one editbox, how can have more editbox in one inputbox
?
Please help by giving example.

Regards,
Magix

 

[Earl Kiosterud]

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

 

[Bob Phillips]

You would need to build a custom userform to handle it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[David McRitchie]

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