Picture changes dependant on combobox entry

[Raanan]

Good afternoon,

I've looked around for this but I cant seem to get a definitive answer that seems to work.

I have a user form with a combo for different images.
the images are stored across different folders in a shared drive and are updated at different times (same file name etc).

what im wanting is for the picture control in my Userform to display the picture relating to the combo box.

so for example

combo list =
Image 1
Image 2
Image 3

Photo path

S:\photos\image1.jpg
S:\images\image2.jpg
T:\clientlist\smithhurst\logo.jpg

What's the simplest way to do this?

[xlbiznes]

Hi.

What you could do, is to add another combobox2 to save the file path for the corresponding item in the combobox1 displaying the picture name.

Please Login or Register  to view this content.

Hope this helps.