Case Select

[sunshine076]

Is there a way to use a case select to hide images for different words such as apple, banana and pear. This would be in a list box and if one is selected it will show a picture of the item?

 

[noboffinme]

Hi sunshine076

To answer the question - Yes.

You should be able to write a Select Case statement (or series of If Then Elses) that change the change the Visible property to True when the focus is on a certain cell containing the word.