Insert Comment macro with picture

[jamshoot]

Hi

Anyone can help me with this one.
I have quite a lot of Inventory List that I need to show the photo when the cursor is on the selected cell.
What i do now is manually using the insert comment >format comment>colors and lines>color>fill effects>picture. Next, I will go to my D:\ drive & search for the folder & then the photo. Next, click insert picture & enable the "Lock picture aspect ratio" & done. As u can see, it is quite a number of steps.

I try the Record macro method ... but is not working.(My VBA is limited)
Hope someone can help me with a macro where it can prompt me which directory & folder & allow me to select the photo & done.

Cheers

 

[VoG]

This code may help you http://www.contextures.com/xlcomments03.html#Picture

 

[jamshoot]

This code may help you http://www.contextures.com/xlcomments03.html#Picture

Hi VoG

thanks ... will try it & see how it goes.

cheers