Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: cell comment

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    can i use any formula retrieving comments of specified cell?

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

    Default

    Hi --

    Bit late this

    No formula i know of will do this, VBA can list comments to a txt file or doc or cell i guess

    Does this help, once did some work on that..


    Free Excel based Web Toolbar available here.

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

  3. #3
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This recent thread might help, though the solutions are VBA based, not formula based as you are asking for.

    http://www.mrexcel.com/board/viewtop...c=2569&forum=2

  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi firuz

    Here is a Custom function that should do it. To use it Open the VBE (ALt+F11) go to insert>module and paste in this:

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

    Then just use it like:

    =CommentText(A1)

    Where A1 has a comment


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

    Default

    Dave

    Anyway to braek as lines in cell comment might, instead of one long line??

    Very cool i add!

    Free Excel based Web Toolbar available here.

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

  6. #6
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Jack

    There is no doubt some code I could include that would do so but it would be at the sacrafice of re-calulation speed. I think UDF's are slow enough already and like array formulas can cause more problems than they solve. Unfortunately most users discover this after the fact.

    Best way would be to simply Wrap text to suit the cell size.



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

    Default

    Hi Dave

    Your right again of cause, i just loved this and feel its a top bit of every ones tool kit as it was. A muct have!

    Yep wrap is the way to go....

    Cheers again Dave .... speak soon.

    Your friend in London
    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
  •