![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: May 2002
Posts: 1
|
Can I insert a .jpg into a comment box?
Thanks Kindly! |
|
|
|
|
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Millbank, London, UK
Posts: 1,790
|
yes....
let me pull up an earlier elevant thread... brb (relevant) [ This Message was edited by: Chris Davison on 2002-05-19 11:54 ] |
|
|
|
|
|
#3 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Millbank, London, UK
Posts: 1,790
|
couldn't find it, so here goes
right click the cell with the comment edit comment right click the margin format comment colours and lines fill colour fill effects picture (at last) select picture browse till you find something suitable Hope this helps Chris marker comment picture |
|
|
|
|
|
#4 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Millbank, London, UK
Posts: 1,790
|
if you want something really groovy : a picture that changes depending upon what's actually in the cell
(ie "dog" shows a pic of a dog, "cat" shows a pic of a cat and "horse" shows a picture, yup, of a horse) try this thread where Ivan excels himself with some VBA code that does this : http://www.mrexcel.com/board/viewtop...orum=2&start=0
__________________
:: Pharma Z - Family drugstore :: |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|