MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Input boxes in VBA

Posted by Greg F. on September 04, 2001 2:19 PM

Is there any way of combing input boxes into one large input box? I have 3 pieces of data that I need to request and have filled out. Instead of having three input boxes pop up, is it possible to have all the data displayed and then entered from one input box?

Posted by Ben O. on September 04, 2001 2:37 PM

You'll have to create a user form with three text boxes. They're not too hard to learn, and they come in very handy for creating user interfaces. If you email me I'll send you a sample.