• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cascading Dynamic Active X Combo Box with VBA

A

Awesome Wally

Member
I have another Cascading Dynamic Active X Combo Box with VBA question the I have sourced from: http://forum.chandoo.org/threads/add-all-option-for-each-drop-down-list-of-combo-box.14167/. I know there are quite a few alternatives to Active X and some involve VBA, which are all good alternatives, however for me this options seems to fit best for end goal. One issue is I don't have a clue what is going on with the code (can't understand it) and I would like to add a second cascading table group. Table 1 has 3 columns with 3 corresponding dynamic cascading active x combo boxes. Table 2 has 2 columns with 2 corresponding dynamic cascading active x combo boxes.
The issue is the second cascade only picks up the results from the selection made in table 1's cascading selections not table 2. I have tried to naively copy the code and change the Combo Box names to correct the issue with no luck. I have attached a sample file for better clarification.
The 2 tables shouldn't have any interaction. Excel 2013

Thank you for all the help in advance!
 

Attachments

NARAYANK991 said:
Hi ,

See if this is OK.

Narayan
Click to expand...
Narayan,
The second set of combo boxes work great. I get a type mismatch error when I try and make combo box #2 selection. The debug highlights the second line in the first function of module1:
Code: 
For j = 1 To UBound(inputarray)
Is it possible to separate the data range and the combo boxes on two different sheets? This way the end user only sees the relevant combo boxes and not all the data that drives them.
Thanks for the quick response.
 
Last edited:
That looks like it is working perfect. Is it possible to split the combo boxes and data ranges on two different sheets? I tried to move the code from from Sheet 1 to 2 but I guess it isn't quite that simple. Thanks again for all the help!
 
Hi ,

Should the tables be one sheet , and the comboboxes on another sheet , or should the tables and the associated comboboxes be together on one sheet , so that comboboxes 1 , 2 and 3 , and Table1 will be on one sheet , while comboboxes 4 and 5 , and Table2 will be on another sheet ?

Narayan
 
You must log in or register to reply here.
Back
Top