Load Picture based on a combobox value

[El Interino]

Hi,

I'm having a hard time figuring out how I can load a picture on an image control box based on the value of the combo box.

I want to show a picture of a person according to what's shown on the combo box. The combo box is currently used for another function but I want to use it as well to show the image. Another thing, I have the rowsource on another sheet.

Anything I can do? Your help matters. Thanks!

 

[RoryA]

You seem to have two End Sub lines there?

Also, the code would be a lot simpler if you could load the file name into the combobox. Is there really a double dot before the jpg extension?

 

[El Interino]

The double is not a problem since the first one is part of the filename. I'm thinking if I can just use a relative combo box that once entered from the first one it will automatically populate on the other. Is this possible?