Macro function Get Comment Text function with format

**guynextdoor** · 02-27-2010, 08:02 PM

Hi,
I have stumbled upon this macro, which works perfect for me: I use index and match to pull the comment text from the specific cell. However, all the text formatting is lost: paragraphs, txt color, bold etc. Is there any way to modify this code to pull all the text with existing formatting??? Thanks a lot.

Please Login or Register  to view this content.

**Leith Ross** · 02-27-2010, 08:14 PM

Hello guynextdoor,
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

**guynextdoor** · 02-27-2010, 08:26 PM

Originally Posted by Leith Ross

Hello guynextdoor,
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Sorry about that. Is it good now?

**Leith Ross** · 02-27-2010, 08:41 PM

Hello guynextdoor,

Thanks, that's perfect.

**Leith Ross** · 02-27-2010, 09:21 PM

Hello guynextdoor,

The Comment text is formatted by the TextFrame object of the Shape object (Comment rectangle). So, you can extract the text but it will only be text. Formatting requires a container object to display it in a modified form: bold, red, etc. Where is the text going to?

**guynextdoor** · 02-27-2010, 09:38 PM

Originally Posted by Leith Ross

Hello guynextdoor,

The Comment text is formatted by the TextFrame object of the Shape object (Comment rectangle). So, you can extract the text but it will only be text. Formatting requires a container object to display it in a modified form: bold, red, etc. Where is the text going to?

Leith,
Thanks for your reply.
The text from the comment will be going to a merged cell C24 (Report spreadsheet). Ive attached a sample. How do I format this cell to appear in specific format? Thanks again.