ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell function (https://www.excelbanter.com/excel-discussion-misc-queries/89466-cell-function.html)

Lee

Cell function
 
Can you make a picture pop up when a particular cell is selected like a
"comment" box does when you have the cell programed with a comment?
--
Lee Davenport

Max

Cell function
 
"Lee" wrote:
Can you make a picture pop up when a particular cell is selected like a
"comment" box does when you have the cell programed with a comment?


How about inserting the pic into the comment ?
Try Debra Dalgleish's page at:
http://www.contextures.com/xlcomments02.html#Picture
Scroll down a bit to: Add a Picture to a Comment
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Ken Johnson

Cell function
 
Hi Lee,

I think the easiest way is to insert a comment then format the
comment's fill to be the picture.

After inserting the comment, click on its border to select it then go
FormatFormat Commentselect the "Colors and Lines" tabselect "Fill
Effects" from the Fill Color drop down list select the "Picture" tab
click on the "Select Picture..." button select the picture file
click "Insert" click "OK"


Ken Johnson



All times are GMT +1. The time now is 11:14 AM.

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