Hide Combobox based on Cell Value

Hi savio21,

See the attached. It all comes down to making the visible property on the combobox false or not, depending on the value in a cell.

I've put code behind the UserForm Activate that will check the value in A1 (you can change it to any cell) and it will hide or unhide the ComboBox based on that value.