+ Reply to Thread
Results 1 to 3 of 3

Insert comment based on Cell Value

  1. 08-06-2013, 05:59 PM #1
    Will03
    Will03 is offline
    Forum Contributor
    Join Date
    12-11-2012
    Location
    Guadalajara, Mexico
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    101

    Insert comment based on Cell Value

    I need to insert a comment on cells based on values. Is there a macro I can Make to do this for me? If so can anyone help please...

    Like if the values in the cell are:

    1 and 2 - Insert comment: You are in good shape

    3 - Insert comment: In OK Status can Improve

    4 and 5 - Insert comment: In danger of failing
    Last edited by Leith Ross; 10-23-2019 at 09:02 PM.
    Reply With QuoteRegister To Reply
  2. 08-06-2013, 09:20 PM #2
    tuongtu3
    tuongtu3 is offline
    Forum Contributor
    Join Date
    08-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007, MS 365 (Windows 10 Pro 64-bit)
    Posts
    818

    Re: Insert comment based on Cell Value

    Hi Will03,
    Try this sample for now. You will see more better code than this from expert:

    Regards,
    tt3
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 08-07-2013, 09:10 AM #3
    Will03
    Will03 is offline
    Forum Contributor
    Join Date
    12-11-2012
    Location
    Guadalajara, Mexico
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    101

    Re: Insert comment based on Cell Value

    Works great thank you I really appreciate it.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto insert comment box based on value
    By Ryanv in forum Excel General
    Replies: 1
    Last Post: 03-28-2012, 10:28 AM
  2. Force user to insert a comment based on a RAG satus
    By Tattooine in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-03-2010, 12:35 PM
  3. Insert a comment based on the value of a cell
    By vamedic11 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-20-2010, 01:54 PM
  4. Auto insert comment based on value entered
    By Fidd$ in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 12-18-2009, 10:18 AM
  5. How do I insert a comment when the Insert:Comment menu is greyed?
    By none in forum Excel General
    Replies: 0
    Last Post: 05-18-2005, 08:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1