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?
Bookmarks