Multiple Input Box

  • Thread starter Thread starter Marco Estrella
  • Start date Start date
M

Marco Estrella

I want to create a "multiple input box", that is in one
same box to be able to put the values of Cell A1, B1, C1
& D1

______________________
|Input Data in A1|_____|
|Input Data in B1|_____|
|Input Data in C1|_____|
|Input Data in D1|_____|
______________________
 
You could create a UserForm to collect the data, or use Excel's built-in
data form (select a cell in the table, choose Data>Form)

Also, you could try John Walkenbach's Enhanced Data Form, a free add-in.

http://j-walk.com/ss/dataform/index.htm

There are some instructions on creating UserForms in the following:

Introduction to UserForms: Part I

http://msdn.microsoft.com/library/d...ffpro01/html/IntroductiontoUserFormsPartI.asp

Creating a Custom Form
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm

XL2000: How to Use a UserForm for Entering Data
http://support.microsoft.com/default.aspx?scid=kb;en-ca;213749

ActiveX Controls and Dialog Boxes
http://www.microsoft.com/officedev/articles/Opg/012/012.htm
 
Back
Top