Loading Images on Sheet Based On ComboBox

Ok so I have an image on Sheet1. I want to change the picture as needed when someone changes the combobox1 on a Userform that is loaded.

So if the combobox1.value = Grapes, then the image on Sheet1 loads a picture of Grapes from a specific file location.

I'm not sure how this can or if it can be done.

Any suggestions?

The way I would write it would be as follows.

Please Login or Register  to view this content.