Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 504
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 504
Default 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




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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






  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,979
Default 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



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 504
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Load image from directory for custom toolbar of Excel 2000 Padam Excel Worksheet Functions 0 August 5th 06 06:33 PM
can we attach an image file to a excel cell ,like note pad comment PR New Users to Excel 1 January 20th 06 05:08 PM
How to Past an Image from Excel 2000 into MS Outlook 2000 ExcelG.I.T[_2_] Excel Programming 3 November 29th 05 06:49 PM
how do I insert image in a comment? t23augusto Excel Discussion (Misc queries) 1 July 31st 05 12:30 AM
How do I place a .jpg image in an Excel comment? kjohnson1000 Excel Discussion (Misc queries) 6 July 19th 05 11:22 AM


All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"