ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I pop up a picture when a cell is clicked on Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/200729-how-can-i-pop-up-picture-when-cell-clicked-excel.html)

Hamlet

How can I pop up a picture when a cell is clicked on Excel?
 
I am working on a schematic of an engineering drawing and I would like to be
able to have a picture of the piece of machinery pop up when I click a cell
that referrences it on the schematic from a picture library on the Excel book
I am in.

Can this be done? If so, how?

Bob I

How can I pop up a picture when a cell is clicked on Excel?
 
Insert a Hyperlink, or Object as link

Hamlet wrote:
I am working on a schematic of an engineering drawing and I would like to be
able to have a picture of the piece of machinery pop up when I click a cell
that referrences it on the schematic from a picture library on the Excel book
I am in.

Can this be done? If so, how?



Tom Hutchins

How can I pop up a picture when a cell is clicked on Excel?
 
You can put a picture in a cell comment.
- Select the cell
- Select Insert Comment
- There should be a border of diagonal lines around the cell comment.
Left-click on that border. It should turn into a border made of black dots.
Right-click on that border and select Format Comment
- Select Colors and LInes Color Fill Effects Picture (tab)
Select Picture
- Navigate to the picture you want, click OK, etc.
- Resize the comment as desired

Hope this helps,

Hutch

"Hamlet" wrote:

I am working on a schematic of an engineering drawing and I would like to be
able to have a picture of the piece of machinery pop up when I click a cell
that referrences it on the schematic from a picture library on the Excel book
I am in.

Can this be done? If so, how?



All times are GMT +1. The time now is 06:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com