Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 28th 04, 06:44 PM
Ralph Heidecke
 
Posts: n/a
Default extracting comments

is there a way to extract the comments associated with a cell and display
them in another cell via a formula?



  #2   Report Post  
Old October 28th 04, 06:49 PM
Frank Kabel
 
Posts: n/a
Default

Hi
this would require VBA. Not possible with formulas alone

--
Regards
Frank Kabel
Frankfurt, Germany

"Ralph Heidecke" schrieb im Newsbeitrag
...
is there a way to extract the comments associated with a cell and

display
them in another cell via a formula?



  #3   Report Post  
Old October 28th 04, 11:32 PM
Dave Peterson
 
Posts: n/a
Default

You can retrieve the text from a comment with a userdefined function like:

Option Explicit
Function GetComment(FCell As Range) As Variant
Application.Volatile

Set FCell = FCell(1)

If FCell.Comment Is Nothing Then
GetComment = ""
Else
GetComment = FCell.Comment.Text
End If

End Function

Then you can use it like any other function:

=getcomment(a1)

But be aware that the function won't evaluate when you just change the comment.
It'll be correct when excel recalculates. (Hit F9 to force a recalc.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ralph Heidecke wrote:

is there a way to extract the comments associated with a cell and display
them in another cell via a formula?


--

Dave Peterson



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
Can Comments be automatically converted to text cell values? tomdog61 Excel Discussion (Misc queries) 1 January 23rd 05 10:38 PM
comments eagles73 Excel Discussion (Misc queries) 1 January 14th 05 12:33 AM
How to change the default font and size of "comments"? ClayMcQ Excel Discussion (Misc queries) 1 January 8th 05 12:43 AM
Extracting Values on one list and not another B Schwarz Excel Discussion (Misc queries) 4 January 7th 05 02:48 PM
Changing default font in comments? philk Excel Discussion (Misc queries) 1 December 15th 04 12:03 AM


All times are GMT +1. The time now is 09:29 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017