Lookup Images with VBA

[Michael Marshall]

This issue is linked to a previos thread "Lookup Images with VBA", but I suspect the issue is related to the 2007 version of Excel I'm using now.

Basically, we have a couple of Image controls (=EMBED("Forms.Image.1","")), that are supposed to get updated when the pull down menu above it makes a selection. In the attachement, tab "Controls" has the sample controls. This sheet also has code written to it.

The only other code I have is stored in Module11 and it is called Paste Picture.

I was getting Run-Time error 1004 but there is code written to handle the 1004 error....so it now reads "The Picture '" & DoorPic & "' was Not Found."

Also, I needed to save this in a macro-enabled format.

[Andy Pope]

The images are not on the same sheet as the list of names, which is what you code implied.

try

Please Login or Register  to view this content.

[Michael Marshall]

BINGO!!!

Case Closed.