In a Userform, I need to have two combo-boxes dependent on each other. The first will contain Range "Material", the second will contain a range depending on the selection of the first box. The ranges available for the second box will be "Stainless_4", "Stainless_2B", "Mild", "AL_3003", "Lexan", "Delrin", "UHMW", and "Special". I've tried getting this to work out using the code below, but it just doesn't happen.
Can anyone help?!
Please Login or Register to view this content.
Last edited by bwestfall; 09-26-2012 at 11:13 AM. Reason: Forgot to mention this is in a userform
If the comboboxes on you worksheet are ActiveX comboboxes then the following should be all you need
Please Login or Register to view this content.
*****
sorry just realized this was on a userform, the following should work for you:
Replace Sheet1 with the name of the worksheet that contains the named rangesPlease Login or Register to view this content.
Last edited by rvasquez; 09-26-2012 at 11:18 AM.
rvasquez:
I apologize, I forgot to mention this is in a Userform. So the first combo box is referencing a named range ("Material"), and the second is going to be depending on the selection from the first combo box.
No, sorry I forgot to read your actual thread title. My last post has been updated for you.
Wow, thank you so much. I looked everywhere for this.
No problem! Thanks for the star tap!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks