I have a combo box that has 3 items. It defaults to the primary value (B2). In conjunction to the primary value, I have an image in my spreadsheet that blocks out other cells.
I want to setup a macro with this combobox_change that if either of the other two in the list are selected the picture is then deleted (thus exposing the other things in the cells it currently hides.)
I'm not sure if a Case Select or an If/Then statement would be more beneficial. Obviously if the drop down is changed from the default to something else, but then changed back, the image needs to reappear.
The combobox's values are identified in cells B2:B4 (List Input Range)
Any help would be greatly appreciated.
I want to setup a macro with this combobox_change that if either of the other two in the list are selected the picture is then deleted (thus exposing the other things in the cells it currently hides.)
I'm not sure if a Case Select or an If/Then statement would be more beneficial. Obviously if the drop down is changed from the default to something else, but then changed back, the image needs to reappear.
The combobox's values are identified in cells B2:B4 (List Input Range)
Any help would be greatly appreciated.