+ Reply to Thread
Results 1 to 2 of 2

Comment Text Promt

  1. #1
    Rob Hargreaves
    Guest

    Comment Text Promt

    Hi I dont know if this is possible but I am using a form to enter
    information to a sheet and would like to add comments to the destination
    cell if the value entered fits criteria specified.

    I have named ranges to use as set points to highlight abnormal values with
    conditional formatting. I would like to use the same ranges as criteria to
    add a comment.

    If the form entry between nr1(100) and nr(200) then prompt for text to
    insert into a comment following an entry to a form within the range of the
    named ranges.

    Thanks for your help
    Rob




  2. #2
    STEVE BELL
    Guest

    Re: Comment Text Promt

    You can add this to your code.
    Just record a macro to see code for adding a comment to a cell. Than edit
    the code to fit your needs.

    --
    steveB

    Remove "AYN" from email to respond
    "Rob Hargreaves" <nrgsav@REM_Thistiscali.co.uk> wrote in message
    news:42ab41f9$1_3@mk-nntp-2.news.uk.tiscali.com...
    > Hi I dont know if this is possible but I am using a form to enter
    > information to a sheet and would like to add comments to the destination
    > cell if the value entered fits criteria specified.
    >
    > I have named ranges to use as set points to highlight abnormal values with
    > conditional formatting. I would like to use the same ranges as criteria
    > to add a comment.
    >
    > If the form entry between nr1(100) and nr(200) then prompt for text to
    > insert into a comment following an entry to a form within the range of the
    > named ranges.
    >
    > Thanks for your help
    > Rob
    >
    >




+ 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