Cascading ComboBoxes

[Godfreyyy]

Hi there,

I am trying to create a User Form using ComboBoxes and am struggling with a couple of things:

1) I have populated my ComboBoxes successfully (these cascade down 5 levels) but, if I select an option in ComboBox1, for example, the relating options in ComboBox2 do not appear until I save, close and reopen the spreadsheet. I would like for this to update and show the next level of options automatically.

2) I would like for Level 2 to be disabled until Level 1 has been selected, and so on. I can disable and enable no problem, but no matter what code I have tried so far I cannot get them to disable/enable dependant upon the previous selection.

Any help would be appreciated - very new to this.

Thank you!

 

[Tinbendr]

And are you filling each successive combobox in the Change event of the selected control?

In other words, if you select a element in Combobox1, do you then fill Combobox2 based on the value of Combobox1 in Combobox1's change event?