paste a picture on selecting a name

[arif]

Sir

I have a big data having names and photos

is that possible to get a photo of a concerned person if i select a name

i have all photos stored in my p c also

like i type cat and photo of cat should appear from my photo data

how

 

[Somendra Misra]

Hi Arif,

Do all the pictures are in the Excel file also?

Regards,

 

[Deepak]

Check this...

http://forum.chandoo.org/threads/searching-multiple-images.18423/#post-123147

You can fire the macro on worksheet_change event.