VBA code to add hyperlink to Picture

[iantowell]

Hello,
I am using MS Excel 2007 and have inserted by vba code a picture to a cell location (for this forum I will use cell location J8).

I am trying now to add a hyperlink to this picture by using vba code also.

All attempts I have tried so far, puts the link in the cell, not on the picture!

I am wanting to hyperlink to the same workbook but a different sheet.

Can anyone assist?

Thanks

Ian

 

[Tom Urtis]

Are you saying that you have maybe a list of file paths in one column, and a corresponding list of file names in another column, and you want to loop through that 2-column list of (what would be) a concatenation of file path and name, and place those pictures on the spreadsheet somewhere? If you can provide some additional details about what you are working with regarding that range of cells you referred to, and where you want the (presumably) pictures placed, that will help determine how to go about this solution.

 

[richardsky]

Thank you for your reply, it has prompted me to realise that i should just list the hyperlink and the picture side by side, rather than trying to be too clever.

Thanks Mr Urtis.

 

[Tom Urtis]

And thank you, for your followup message here that it's a done deal.