ActiveX ComboBox to Hide Columns

Hello,

I am currently having trouble making my ComboBox ActiveX hide and unhide columns based on range of text in a row. What I would like this code to do is the following:

When a text is selected from the combo box, hide all the columns that DO NOT contain the text in rows C5:M5 and show only the columns with the text. If the combo box is empty, it should show all columns.


This is the code I am working on:

Please Login or Register  to view this content.

I keep getting an object error. Any help would be greatly appreciated. Thank you so much for your time.

Sincerely,
JRB

This is for an exact text match.

Please Login or Register  to view this content.

This would be a partial match (the cell contains the combbobox text).

Please Login or Register  to view this content.