Dependent Combo Boxes
I have 2 combo boxes namely Category & Item Name.
There are multiple categories and multiple item names in it.
If i select category, only the items in that category should be displayed in item name combo box.
The data is maintained in the "Primary" sheet.
How can this be done? I can see same category multiple times in the category combo box too. I just want one entry of that.
Also I am going to add a separate sheet to add items. The code should also be helpful then.
Please help.
This is a good starting point: http://www.contextures.com/xlDataVal02.html
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I am trying to do it in userform. Not in excel.
Apologies, but you did not state that in your opening post. You may wish to add it to your thread title for clarity.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks