Change Picture based on cell value

[Jim]

Sorry for the double post, but I put my question as a reply to an old post
and I'm concerned it will not be answered. Below is my question from a post
from last May.

I'm trying to change a picture based on the selection of a cell in a drop
down list.

Gord,

I've the John McGimpsey method. I've downloaded his sample sheet, played
with it, added more photos and names in the range and everything works.

However when I copy the exact source code (changed the range to the cell
where I want the photo) over to the sheet I need this function to work, it
does not. Instead of displaying the named picture, it displays the picture
name 'Picture 1' in the destination cell.

VBA is over my head, any help?

Thanks much in advance.

JIM

 

[Simon Lloyd]

Jim, can you supply the code as you have it now? (i.e the code tha
doesn't work

Sorry for the double post, but I put my question as a reply to an ol
pos
and I'm concerned it will not be answered. Below is my question from
pos
from last May

I'm trying to change a picture based on the selection of a cell in
dro
down list

Gord

I've the John McGimpsey method. I've downloaded his sample sheet
playe
with it, added more photos and names in the range and everything works

However when I copy the exact source code (changed the range to th
cel
where I want the photo) over to the sheet I need this function to work
i
does not. Instead of displaying the named picture, it displays th
pictur
name 'Picture 1' in the destination cell

VBA is over my head, any help

Thanks much in advance

JI


like =A


value' (http://www.mcgimpsey.com/excel/lookuppics.html

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[Jim]

Simon,

I actually just figured out my own security settings were preventing the
code from running. Feel kind of silly now, but lesson learned.

Thank you for the reply regardless.

Have a great day!

JIM

 

[Simon Lloyd]

Hey, we're all still learning, glad you're sorted

Simon

I actually just figured out my own security settings were preventin
th
code from running. Feel kind of silly now, but lesson learned

Thank you for the reply regardless

Have a great day

JI





Office Discussion' (http://www.thecodecage.com)

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com