Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Showing comments and printing

  1. #1
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Belgrade, Yugoslavia
    Posts
    156
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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...

    Kind Regards,
    Ivan F Moala From the City of Sails

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Belgrade, Yugoslavia
    Posts
    156
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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
    :: Pharma Z - Family drugstore ::

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

    ..
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •