InputBox

M

magix

Hi,

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

Regards,
Magix
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
D

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
 
Top