Click here to Skip to main content
16,020,305 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have an Excel spreadsheet that I would want an image from sheet 2 to appear in an ActiveX Imagebox1 on sheet 1 when I click on the cell that is located in sheet1.

I am new to VBA, any help would be appreciated.

Thank you
Posted
Comments
Maciej Los 7-Sep-15 15:40pm    
What have you done till now? Where are you stuck?

1 solution

I do not recommend to use ActiveX component on Sheet. Rather than it, insert picture directly: Shapes.AddPicture Method (Excel)[^]

Pass Cell.Top[^], Cell.Left[^] to define left and top coordinates for image.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900