How to insert photo

[HVK1986]

In A1 i have names "car,house,bike,mountain,chair" i have data validated and inserted a dropdown for all these names. I have photos of car,house,mountain,bike chair on my desktop.


Now if i select car in A1, in B1 photo of car should be displayed

Now if i select house in A1, in B1 photo of house should be displayed.


Please guide

Thanks regards

 

[Hui]

Harry


Have a look at: http://chandoo.org/wp/2009/07/13/product-catalogs/

 

[SirJB7]

Hi, HARRY!


Give a look at this topic:

http://chandoo.org/forums/topic/insert-photos-in-excel-upon-name-change-in-a-cell


Please advise if link isn't working since 2shared became erratically available.


Regards!

 

[HVK1986]

Thank u sir hui & sir JB7