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

Please Login or Register  to view this content.