Making an Advanced Input Box

**excel199** · 07-12-2010, 11:31 PM

I have a file with columns A to H
A – Order Number
B- Order Number
C- Item
D – Material
E – Quantity
F – Date Ordered
G- Order Status
H – Priority Level
What I need
1. I want to have an input form that can be used to enter data into the "input" worksheet. In this input form there should be a add subset button which can be clicked to add more fields for Item No., Material and Qty. By this I mean that If a single order has 3 items then I can click this button 2 times to add more fields in my input box. ( now I can enter 3 different item numbers, material name and qty). After this is done there should be a submit button which can add these to the input worksheet. For orders with multiple items the form should create a new row. Example if there are 2 items then I will enter the order number once and distributor name once but I would use the add subset button to enter 2 items numbers and quantity. All this information should paste in 2 rows.

I was hoping this is a possible macro.

Thanks

**royUK** · 07-13-2010, 01:28 AM

You could create a UserForm, but I wouldn't try adding "fields" to the form. Just add item by item

**excel199** · 07-13-2010, 01:43 AM

Originally Posted by royUK

You could create a UserForm, but I wouldn't try adding "fields" to the form. Just add item by item

Ok so if i make new entries each time, could you give me the code for that,

1. What should be the code in the button when i click "add new entry"

2. What should be the background code for the all the above fields in the input box

and is it possible though to have a button which could give me option to add multiple fields in the same input form

Thanks

**royUK** · 07-13-2010, 01:47 AM

You can adapt the DataBase form example here

http://excel-it.com/vba_examples.htm

**foxguy** · 07-13-2010, 05:14 PM

Originally Posted by excel199

and is it possible though to have a button which could give me option to add multiple fields in the same input form

If you go the form route, I would put all the fields for 3 rows into the form, but disable then, maybe even make them hidden. Then your button could unhide and enable them.

But if you have never worked with forms before, I might suggest designing a "Data Input" sheet instead and put a button on it to save the data into your "Data" sheet.