How to popup image on click in a cell

[mani_bbc05]

From cell A1:A4 i have names of different fruits. Such as in cell A1 Apple, A2 Grapes. etc
I want a VBA code to popup the images of the respective fruits when clicked to their respective cells. The images of the fruits are stored in other shhets of the same workbook. The popup image should be in a userform. I dont want to use hyperlink or comment option.

Also if possible can i put a button to save the activesheet in pdf or ppt format in the currently saved location by suing command button?

[gaikwad.mm@gmail.com]

Create User Form with the image and then access it from your particular cell

[gaikwad.mm@gmail.com]

Here is the sample file I' have created

[mani_bbc05]

Thanks Gaikwad, this is what i was exactly wanting. but friend what is the password for the VBA? I am not able to see the code, i have to use it somewhere else.

Please give me the password.

And thanks a lot for your help.

[gaikwad.mm@gmail.com]

Sorry!!!
It's "milindgaikwad"

[mani_bbc05]

Thanks Milind