Image in Comment in Excel 2000
 

Greetings! A while back I saw a posting describing how to get an image into a
comment in Excel 2000. I printed it out, but have since lost it.

Does someone know how to do this. If I remember correctly, it somehow
involved pasting and could only be done through VBA since pasting an image as
a comment in the UI is not an option.

Thanks in advance!
--
Kevin

Image in Comment in Excel 2000
 

Hi Kevin,

Edit Comment rt-click border Format Comment
Colors & Lines Fill color drop down
Fill Effects Picture Select Picture

Regards,
Peter T

"Kevin" wrote in message
...
Greetings! A while back I saw a posting describing how to get an image
into a
comment in Excel 2000. I printed it out, but have since lost it.

Does someone know how to do this. If I remember correctly, it somehow
involved pasting and could only be done through VBA since pasting an image
as
a comment in the UI is not an option.

Thanks in advance!
--
Kevin

Image in Comment in Excel 2000
 

You can insert the picture manually, but only by inserting a file into
the comment fill colour.

There are manual instructions he

http://www.contextures.com/xlcomments02.html

And sample code here to insert a selected picture into the active cell's
comment:

http://www.contextures.com/xlcomments03.html#Picture

Kevin wrote:
Greetings! A while back I saw a posting describing how to get an image into a
comment in Excel 2000. I printed it out, but have since lost it.

Does someone know how to do this. If I remember correctly, it somehow
involved pasting and could only be done through VBA since pasting an image as
a comment in the UI is not an option.

Thanks in advance!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Image in Comment in Excel 2000
 

Just what I needed! Thanks for your help!
--
Kevin


"Peter T" wrote:

Hi Kevin,

Edit Comment rt-click border Format Comment
Colors & Lines Fill color drop down
Fill Effects Picture Select Picture

Regards,
Peter T

"Kevin" wrote in message
...
Greetings! A while back I saw a posting describing how to get an image
into a
comment in Excel 2000. I printed it out, but have since lost it.

Does someone know how to do this. If I remember correctly, it somehow
involved pasting and could only be done through VBA since pasting an image
as
a comment in the UI is not an option.

Thanks in advance!
--
Kevin

Image in Comment in Excel 2000
 

Just what I needed! Thanks for your help!
--
Kevin


"Debra Dalgleish" wrote:

You can insert the picture manually, but only by inserting a file into
the comment fill colour.

There are manual instructions he

http://www.contextures.com/xlcomments02.html

And sample code here to insert a selected picture into the active cell's
comment:

http://www.contextures.com/xlcomments03.html#Picture

Kevin wrote:
Greetings! A while back I saw a posting describing how to get an image into a
comment in Excel 2000. I printed it out, but have since lost it.

Does someone know how to do this. If I remember correctly, it somehow
involved pasting and could only be done through VBA since pasting an image as
a comment in the UI is not an option.

Thanks in advance!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Image in Comment in Excel 2000
 

Kevin, Peter,

It's a greate tip!

Thanks you two.

Shinya

"Kevin" wrote in message
...
Just what I needed! Thanks for your help!
--
Kevin


"Peter T" wrote:

Hi Kevin,

Edit Comment rt-click border Format Comment
Colors & Lines Fill color drop down
Fill Effects Picture Select Picture

Regards,
Peter T

"Kevin" wrote in message
...
Greetings! A while back I saw a posting describing how to get an image
into a
comment in Excel 2000. I printed it out, but have since lost it.

Does someone know how to do this. If I remember correctly, it somehow
involved pasting and could only be done through VBA since pasting an
image
as
a comment in the UI is not an option.

Thanks in advance!
--
Kevin