How to vlookup picture with vba code

Dear Seniors,

Im looking for vba code that can get a picture from another sheet without name define manager.

Looking forward, need help..

Welcome to the forum!

Please explain what "get a picture" means.

You can use this to display a shape's name for say Sheet2.

Please Login or Register  to view this content.

tx for replay..

i mean just like vlookup but the data that i want to get is the picture that i inserted, if theres 2 column ; first column is the data like name and the second one is their picture.
can i lookup by the name to get their picture ?

kindly need ur assistance..

I still am not sure what get means. Do you mean copy the shape to the right of the one you lookup with name to left?

There are 2 approaches:
1. Rename your shapes to be what you would lookup.
2. The lookup cell would be a dropdown's named range list of the Column 1 values.

In both approaches, the shape could be copied when dropdown value changes.

Since you did not post an example file, here is an old one.

thanks sir..

but it shown another little problem, when the macro run, it goes blinking.
the strange is, when the mouse is moving, the flicker is stop..
can we remove the flicker when the macro ran..

or can we move the pointer continuously by vba code (never heard that) ?

need ur assistance..

Your sample here is very interesting. How do I go about adding new pictures or changing the pictures in your sample?

Originally Posted by Kenneth Hobson

I still am not sure what get means. Do you mean copy the shape to the right of the one you lookup with name to left?

There are 2 approaches:
1. Rename your shapes to be what you would lookup.
2. The lookup cell would be a dropdown's named range list of the Column 1 values.

In both approaches, the shape could be copied when dropdown value changes.

Since you did not post an example file, here is an old one.

Addeimy, that is due to the picture moving? I had problems running your file. There were syntax errors. Maybe you left out some API commands. If this is a separate issue, you might start another thread.

You may find this of use:

Please Login or Register  to view this content.

Normally, I use my Speed routines to disable some things.

Please Login or Register  to view this content.

Aghlab, to show all pictures on sheet1, in the immediate window of the VBE, paste this code and press enter key at end to execute or play it in a sub.

Please Login or Register  to view this content.

Once you change the pictures or add more, run the code again but set it to False.

Don't forget to update Sheet2 with names and the picture/shape names to the right. Lastly, be sure that the named range, PicTable, includes all that you added in sheet2.

Ure the Man !!
Big thanks Sir..