Thread: Hide combo box based on cell value

Hey Guys,

I am trying to hide a combo box (DropDown25) if cell C161 = anything but "8".

Or to put it another way, I only want the combo box visible when C161 = 8.

I assume I will be assigning a macro to the combo box but am unsure of the code.

Please help!

Hi chrisodonnell86
Welcome to the forum.
Assuming the ComboBox is an ActiveX control placed on Sheet1.
Put the following in the Sheet1 Change Event

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Range("C161")) Is Nothing Then
        If Range("C161") = 8 Then
            DropDown25.Visible = True
        Else
            DropDown25.Visible = False
        End If
    End If

End Sub