Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default VBA and comments in Excel2002

Hello,

I want to combine comments from two cells and put the combined comment back
into one of the cells.

Writing the comment text back is easy enough with "[range].comment.text",
but how do you read the text from a comment associated with a particular
cell? It appears that the only way to do it is via
"[range].comment.shape.anternativetext". Does anyone have any ideas, sneaky
routines, etc for excel2002?

Thanks in advance,

Neil


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
excel2002 JWD Setting up and Configuration of Excel 0 November 9th 09 03:55 PM
Text book Excel2002 VBA octet Excel Discussion (Misc queries) 1 May 22nd 09 12:02 PM
hyperlinks in excel2002 won't save correctly Alastair Links and Linking in Excel 4 September 25th 07 12:32 PM
Page Breaks - Excel2002 Deborah New Users to Excel 2 July 4th 07 03:36 PM
Old button code not working in Excel2002 shanej Excel Programming 0 July 16th 03 02:10 AM


All times are GMT +1. The time now is 01:39 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"