Combobox info change

[Jphill]

I need to have certain boxes disappear when certain info is chosen on others. Example: In a list of Hood, Base, and Plate. if the last one is chosen I need combobox 2, 3 and 4 to not be an option to choose from.

Thanks

 

[al_b_cnu]

Hi,

Have you tried the '.Visible' property, e.g.

ComboBox1.Visible = False

however you may prefer the '.Enabled' property.

HTH

Alan

 

[Jphill]

Yes but it doesn't work after you choose the one in the list. I need it to hide the boxes as soon as someone clicks on the option from the first box.

 

[TryingToLearn]

If this is in a userform, try using the Combobox1_Change event to set the visible parameters you want.

If it is with an activeX control from the controls toolbar, use the ComboBox1_Change event.

If it's from the forms toolbar, I don't have an answer.