Hi everyone,
I have been trying to create or find the codes for creating additional inputs on userform, but I am unable to grasp the coding concept.
Kindly refer to the attached sample order form.xlsm.
In the userform:
- Textbox1: Order Number
- Textbox2: Number of Items - adjustable figures by Spinbutton1
- Frame1:An area for Item IDs
- Textbox3~xx: Item IDs (Textbox count based on value from Textbox2)
- Commandbutton1: Submit Button
- Commandbutton2: Cancel Button
My intentions are to create the additional inputs based on the number of items ordered and storable at Data table on Submit Button Click.
Thanking you in advance for helping me.
Regards,
Bookmarks