+ Reply to Thread
Results 1 to 2 of 2

Check cell for comment

  1. #1
    ExcelMonkey
    Guest

    Check cell for comment

    How do I evaluate a cell to see if it has a comment in it. I am not looking
    to loop throught a comment collection here. I want to select a cell and
    return a property value if possible to see if the cell has a comment. Sounds
    sillly as you can see whether it has one or not. But I am using it an error
    handler.

    Thanks

  2. #2
    ExcelMonkey
    Guest

    RE: Check cell for comment

    Got it. Thanks anyways.

    If ActiveCell.Comment Is Nothing Then
    MsgBox ("There isn't a comment in this cell to copy!")
    Exit Sub
    End If

    "ExcelMonkey" wrote:

    > How do I evaluate a cell to see if it has a comment in it. I am not looking
    > to loop throught a comment collection here. I want to select a cell and
    > return a property value if possible to see if the cell has a comment. Sounds
    > sillly as you can see whether it has one or not. But I am using it an error
    > handler.
    >
    > Thanks


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1