I have a userform for customers to select the items that they want to buy. However, I have only put out 5 comboboxes for them to select the product and 5 textboxes that shows the price of the product. If they are purchasing more items, I would like to have a command button named "Add more items" and it will load 5 more comboboxes and textboxes at the same time, is it possible? And if they are buying even more, the button will help to generate more comboboxes and textboxes again.
Please help!
Why not stick with the existing controls add and a listbox?
Then insted of using the command button to add new controls it could be used to add the data from them to the listbox and them clear them ready for the user to select the next product.
If posting code please use code tags, see here.
Hi,
Sorry but i dont quite get what you meant :/
Actually after re-reading your post I think you could get away with only one textbox, one combobox, one command button and a listbox.
See the attached file.
This is good enough! Thank you for the help
Here you go!
I've updated the workbook and attach it.
Works beautifully, thank you once again
HI Norie,
I am really interested with your attachment. can you send the complete version for my learning purpose.
Faridwahidi
Not quite sure what you mean by 'complete' version.
The first file I attached was a simple example, the file I attached in post #7 is an update of the file the OP attached in post #6, there are no other files involved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks