+ Reply to Thread
Results 1 to 3 of 3

If statement for selected cells containing comment

  1. #1
    Registered User
    Join Date
    02-11-2008
    Posts
    68

    If statement for selected cells containing comment

    hi,

    I was after a vba IF statement :

    IF selected cell already contains a comment:

    DO THIS

    ELSE

    IF selected cell does not have a comment:

    DO THAT

    I would be grateful if someone could help.

    thanks
    andy

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello tapapad,

    To test if a cell has a comment already, you can do the following...
    Please Login or Register  to view this content.
    Change "A1" to the cell you want to check.

    Sincerely,
    Leith Ross

  3. #3
    Registered User
    Join Date
    02-11-2008
    Posts
    68
    thank you :-)

+ 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