Hello everyone,
First of all - thank you all. I've learned so much reading your forum!
Now my bummer - I'm trying to get a dependent drop down list in ActiveX combobox.
A.k.a I have a 14 items list in ComboBox.1 and choices that have to vary in ComboBox.2. After quite a search I found this: /excel-programming-vba-macros/782864-indirect-with-activex-combobox.html and seeing the problem is solved was a bright light... but not quite in my case. (I knew it was too easy to be good :D )
Just pasting the
...gets me an error: "Method 'Range' of object'_Worksheet' failed". The Debug sends me onPlease Login or Register to view this content.
row.Please Login or Register to view this content.
Although this is not everything in this sub:
...and I also have 6 other simple subs in the worksheet that work just fine without the above. My working file is attached.Please Login or Register to view this content.
To aim higher I even need a 3d dependent list in ComboBox.3 which I haven't even created yet. Do you think the above solution could work on the 3d list as well?
Thank you in advance.
Kind regards.
Bookmarks