Enable Combo Box from Check Box - In EXCEL

[NJUser]

Hello all:
I'm trying to enable a Combo box, if a check box is selected (is TRUE). I saw a message on how to accomplish this in Access, but I'm struggling with Excel. Any assistance would be appreciated.

THANKS MUCH!!!

 

[AlphaFrog]

Try something like this...

ComboBox1.Enabled = CheckBox1.Value

 

[NJUser]

I'm sorry....I misrepresented what I needed to do. I need to make the ComboBox visible if Check box is selected (is True). If the check box is not selected (is False), then I don't want to show the Combo Box.

I tried this code for the Check Box, but think I'm missing some more code. (forgive me, I'm a newbie to code).
If CheckBox5.Value = False Then
ComboxBox3.Visible = False
End If

 

[AlphaFrog]

This worked for me...

Private Sub UserForm_Initialize()
    ComboBox3.Visible = False
End Sub

Private Sub CheckBox5_Click()
    ComboBox3.Visible = CheckBox5.Value
End Sub

 

[NJUser]

THAT's AWESOME!!!! Thank you so much!!!

 

[NJUser]

One last question....promise. So the combo box that now appears/disappears has a selection of yes or no. If yes is selected, I want combobox 4 to display, if yes is not selected, I don't want ComboBox 4 to show up.

THANKS TREMENDOUSLY for all your help AlphaFrog!!!

 

[NJUser]

NEVER MIND....I figured it out!!!! Yahoooo

 

[AlphaFrog]

CheckBox5 toggles ComboBox3 visible\hidden
ComboBox3 is the Yes\No combobox and toggles ComboBox4 visible\hidden

Private Sub UserForm_Initialize()

    With ComboBox3
        .Visible = False
        .AddItem "Yes"
        .AddItem "No"
    End With
    
    ComboBox4.Visible = False
    
End Sub

Private Sub CheckBox5_Click()
    ComboBox3.Visible = CheckBox5.Value
End Sub

Private Sub ComboBox3_Change()
    If ComboBox3.Value = "Yes" Then
        ComboBox4.Visible = True
    ElseIf ComboBox3.Value = "No" Then
        ComboBox4.Visible = False
    End If
End Sub