Enable or Disable a combo box

What the code to enable or disable a combo box used in Excel
Frank FreeseAsked:
Who is Participating?
N-WConnect With a Mentor Commented:
Here's an example for you:
Private Sub TextBox1_Change()
    If TextBox1.Value = "Yes" Then
        ComboBox1.Enabled = False
        ComboBox1.Enabled = True
    End If
End Sub

Open in new window

Frank FreeseAuthor Commented:
Michael FowlerSolutions ConsultantCommented:
The option you probably want is enabled eg

ComboBox1.Enabled = False

Have a look at this link for some general information on ComboBoxes


if you are still having issues please give more details as to the type of control eg ActiveX or Form Control and what you are trying to do. A sample workbook would also greatly assist

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.