Hi everyone
I'm creating a file to keep track of transactions so that it can be seen what items have been sold, and to whom.
I'm now wanting to use a userform to input the data into the form instead of doing it directly.
I have a table with all of the items for sale, and on the userform i've connected this to a combo box so that the user can choose the item if it is sold.
Is there any way that, once an item has been chosen on the userform, it will automatically create a new combo box on the next line to choose item number 2, then item number 3... et cetera... Is there also a way to make it AUTOMATICALLY create these combo boxes with IDs such as "Item1", "Item2", so that i can use another macro to copy the data from the userform onto the transactions worksheet?
Hopefully somebody can help
Thanks
Ben
Bookmarks