Combo box selection hides columns that do not match

is the combobox on a userform or on a sheet?

Sub test()

Dim l As Long
Dim ll As Long
Dim bCheck As Boolean

For l = 1 To Cells(1, Columns.Count).End(xlToLeft).Column
    bCeck = False
    For ll = 1 To Cells(Rows.Count, 1).End(xlUp).Row
        If InStr(1, Me.ComboBox1.Value, Cells(ll, l).Value) > 0 Then
            bCeck = True
        End If
    Next ll
    If bCheck = False Then Cells(1, l).EntireColumn.Hidden = True
Next l
        
End Sub

You can try this. Assuming your combobox is named ComboBox1.

where did you copy the code to? what are you using to trigger the code?

where did you copy the code to? what are you using to trigger the code?

Price%20List%20Example.xlsm Sorry about the duplicate post.

Basically you're trying to hide all columns where the header doesnt match combobox3 correct?

try the attachment.

Glad to help.