Link cell to picture

[phillyd023]

I would like to create a list of part numbers in sheet 1 of my spreadsheet and link it to a picture tat i inserted into sheet 2. I will ahve a bunch of pictures that i randomly insert into sheet 2 but i will name them the same as the part number i put in the sheet 1 list. i hust want to be able to click on a specific part number and it take me to that picture in sheet 2.

see attached

[Bo_Ry]

Rename Picture to 123
Then put this code in Sheet1

Please Login or Register  to view this content.

Double Click A2 in Sheet1

[phillyd023]

so i am not sure what i am missing. i downloaded your attachment and it works fine.

on my version of the same spreadsheet i renamed the picture, right clicked on sheet1, went to view code, and pasted in your formula from the post. when i click on A2 i get an error that says "runtime error '424' object required.

I also copied the formula from your code in your attachment (because it has "option Explicit" at the top and i get a different error that says "compile error variable not defined"