Text in Comments

[Simon]

I apologise if this is a commonly asked question but work
pressures are such that I can't spend ages looking through
the forums for the answer.

Is there a way to get the text from an inserted comment
and put the text into a cell?, other than opening the
comment and copying and pasting the information into a
cell.

Thanks.

 

[Frank Kabel]

Hi
this would require VBA (a user defined function). e.g. try
the following:

Public Function get_comment(rng As Range)
Application.Volatile
get_comment = rng.Comment.Text
End Function

Try
=GET_COMMENT(A1)
in your worksheet. Note: returns an error if no comment
exists

 

[Debra Dalgleish]

You can use programming to extract the text. There's some sample code here:

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

 

[Guest]

thanks a alot, very helpful indeed.

-----Original Message-----
Hi
this would require VBA (a user defined function). e.g. try
the following:

Public Function get_comment(rng As Range)
Application.Volatile
get_comment = rng.Comment.Text
End Function

Try
=GET_COMMENT(A1)
in your worksheet. Note: returns an error if no comment
exists


.