Showing comments and printing

Joe Was

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
This is a custom function:

Function CommentText(rCellWithComment As Range)
CommentText = WorksheetFunction.Clean(rCellWithComment.Comment.Text)
End Function

It gos in a module.

To use it you must:

use a syntax of, " =CommentText(A1)"

Subsitute the cell address you want the comment of returned for like the "A1" in the above syntax.
If the cell has no comment none will be returned!

In the source comment cell you must have a comment. That cell will have a red upper right corner which triggers the comment for that cell. In the calling cell put the function call and it will display the comment of the source cell as a text line in or extending to the right of the calling cell. Hope this helps. JSW
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Hi,
I have a table with data which I have to regulary check and add coments in some cells.
Is there any way to automaticaly copy this comments in some empty cell in the same row.
Thanks in advance.
Sax
 
Upvote 0
On 2002-04-11 01:54, sax wrote:
Hi,
I have a table with data which I have to regulary check and add coments in some cells.
Is there any way to automaticaly copy this comments in some empty cell in the same row.
Thanks in advance.
Sax

Automatically....not without code...
 
Upvote 0
Mr Moala,
whatever ... code, formula.
One more thing. I have two columns where I put comments. I would like this comments to be copied to cells accordingly in the same order like columns are staying (Column B is first , Column D is second so copied cells will be one next to another accordingly).
Hopefully you understand me.
Thanks a lot i advance.
Cheers.
Sax
 
Upvote 0
it's not *automatic* but if you highlight the range, select "copy" then go to your spare column(s) and select "paste special" then "comments" it will replicate them as is

it's quick, albeit manual
 
Upvote 0
Hi

you can drag em, copy em paste em, paste special em ,VBA em, export them in VBA to text file report, paste the contence to cell.

cant kill em only delete em.. good additions to have

..
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,916
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top