Copy a comment in a cell into another Cell

[LangAdel]

I have a cell, where a user has entered text in a comment, and I want to copy the comment itself into another cell. I have tried different approaches, but none of them work. Any help appriciated.

Brian

 

[nberryman]

Click on the cell and copy, go to the cell you want th ecomment in and click Edit, Paste special and select Comment from the menu



Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[LangAdel]

Hi Neil

By duing that you copy the comment into another cell, which then has the comment as a comment. What I'm interested in is to copy the comment into another cell.

regards
Brian

 

[GlennUK]

Do you need to do this once or do you want to have an automated method to do this?

If you just want to do this once then right click the cell and choose Edit Comment from the shortcut menu, which will activate the comment. You can then select the text of the comment, press Ctrl-c and then activate the cell where you want the text to appear and press F2 and then Ctrl-v to paste the copied text into the cell.

Any other method will require VBA macro programming.


Glenn.

 

[LangAdel]

Hi Glenn

Thanks for your reply. But yes I need to do this for many cells, so I am looking for a VBA solution. Any Suggestions?
Brian

 

[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