help with comboboxes

[Kmsanton]

I'm looking to attach a macro to one of my comboboxes. I created a combobox using the "forms" toolbar. I've entered two options into the combobox, No and Yes. When the user picks "yes", which is the first option in the combox I want a textbox to appear and a cell to change colours. I've created the textbox using the "control toolbox" toolbar.

So basically what I need to happen is when you click the "Yes" option I want my textbox to appear and cell C5 to turn white.

Any ideas?

 

[erik.van.geit]

Hi,

this question will probably be resolved, but first some questions
a yes+no combobox can be replaced by a checkbox: for you too?
what happens when you click no (or uncheck the checkbox): is textbox hidden again ? what happens to C5

kind regards,
Erik

 

[Kmsanton]

I actuall figured it out. I wanted the combobox to make my textbox appear when I picked the "yes" option so i entered this code.

Sub combobox1_change()
If ComboBox1.Value = "Yes" Then
TextBox_1.Visible = True

Else
TextBox_1.Visible = False
End If
End Sub

 

[erik.van.geit]

fine you got it sorted

compact code would be

TextBox_1.Visible = ComboBox1.Value = "Yes"

and think about the checkbox - if possible - which is easier to use

best regards,
Erik