Excel VB query

JEB

JEB

JEB

Associate
Joined
19 Oct 2002
Posts
1,469
Location
Caithness, Scotland
I wonder if someone can help with a bit of Excel VB please.

In this file

File

I have two drop-down lists. One in cell A2, the other A14. On changing these cells I want a picture to be displayed that corresponds to the cell entry.

I have this working fine with Cell A2, but I don't know how to add another section into the VB code to also get it to work on cell A14. When working I need a picture displayed for each drop-down option?

Can anyone help me out here please?
 
Excellent, thank you for that, works a treat.

When you import pictures from a file it automatically names then 'Picture 1', 'Picture 2' etc. Do you know how to rename them once they have been imported?

Thanks again.
 
Thanks for the reply s-p. I tried the rename in the name box, but it wasn't working, and then voilla - the trick was once you renamed it you have to hit 'enter' for it to accept it. Previously I was renaming and just clicking off it again.

Thanks for your help, you are a super-star.
 
You must log in or register to reply here.
Back
Top Bottom