Enable next activex comboboxwhen current combobox is populated

[kosherboy]

Hello,
Not even sure where to start with this; i have 50 activex comboboxes (all named ComboBox1-50), all comboboxes are disabled except for the first one, i want that when the first combobox is populated from the drop down then the next combobox should get enabled, and when the 2nd combobox is populated the 3rd one should get enabled and so on and so forth.
Here is what i started with but i'm at a loss as to how to further proceed:

Please Login or Register  to view this content.

Any help on this is much appreciated.

[Leith Ross]

Hello kosherboy,

Where is the information stored that the ComboBoxes will be loaded with?

[gmr4evr1]

Not sure about this, but something like

Please Login or Register  to view this content.

I sometimes think in simple terms so I might be way off base with this.

[kosherboy]

Hello kosherboy,

Where is the information stored that the ComboBoxes will be loaded with?

I apologize if i wasn't clear in my original post, the comboboxes are already filled, i just want that when the user selects the first combobox and selects an item from the dropdown, as soon as the user clicks out of the combobox i want the combobox below to get enabled.

[Leith Ross]

Hello kosherboy,

Okay, the comb boxes have data. Starting in ComboBox1, after the user makes a selection then you want the focus to shift to ComboBox2, etc. Is that correct so far?

[kosherboy]

Not so much the focus to be set but that the whole combobox (which is currently set to disabled) should be enabled.
I will post example soon....

[kosherboy]

Here is an example EnableComboBoxes.xlsx
Please note that since i have about 100 comboboxes i would rather avoid placing a code into each combobox, i would rather the task be triggered through an event procedure, like selecting objects etc
Thanks

[Leith Ross]

Hello kosherboy,

Here you go. This uses a principle known as Sub-Classing. This allows objects that are already defined to be extended by adding new properties and events to an existing Class.

When the workbook firsts opens, the ComboBoxes on Sheet1 are Sub-Classed. The Click event of the new Class, ComboEx, will enable the next ComboBox on the worksheet. When the last ComboBox is reached, the refernce is set back to the first ComboBox. If the ComboBoxes stop working, run the macro SubClassControls.

Class Module - ComboBoxEx Code

Please Login or Register  to view this content.

Module1 Code

Please Login or Register  to view this content.

Workbook Open Event Code

Please Login or Register  to view this content.

[kosherboy]

Hi Leith Ross,
It's responses such as yours that remind me of how much i don't know!
I can't thank you enough!
Best regards,
Kosherboy

[Leith Ross]

Hello kosherboy,

I don't know it all after all these years. Everyday I learn something new.

Glad I could help. If you have any questions about how the code works, just ask.