Excel 97 - Display comment in next column 1

[SKIGAL]

I have a spreadsheet where I need the comments to be displayed in the next column. I know you can print and/or display the comments, but I need the comment in an actual column. Have any ideas?

Thanks in advance!

 

[mbarron]

you can create a function to do this.
Paste the following into module for your sheet.

Function comment(thisone) As String
comment = thisone.comment.Text
End Function

It displays the carriage returns as boxes - at least with Times News Roman.

Mike

 

[SKIGAL]

Thanks mbarron, it worked!