+ Reply to Thread
Results 1 to 14 of 14

Add date/time stamp to comment when cell is marked "X"

  1. #1
    Registered User
    Join Date
    10-18-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    19

    Add date/time stamp to comment when cell is marked "X"

    Hello excelforum.

    Hopefully my request for help is relatively simple for your expertise, but it is beyond my scope.

    I have a range of cells...say A1 to D10 all with column headings

    What I would like to do within that entire range is this;

    Say I place an "X" in A1...I would like to automatically generate a comment in that cell with my Name and a Date/Time stamp. This would indicate that a particular task has been completed.

    Then the same to occur when I place an "X" in...lets say B3..and so on within the entire field.

    Nothing fancy...standard comment box...but with Tahoma 12 font bold and with auto resize to suit.

    Many thanks in advance.
    From desperately needed.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Add date/time stamp to comment when cell is marked "X"

    Hi, and what when you remove the X from that cell?
    Let's say you placed the X my mistake? remove the comment?
    And what is more important, which version of Excel are you using?
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    10-18-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Add date/time stamp to comment when cell is marked "X"

    Hi Keebellah

    If a mistake is made the comment can be deleted manually...not that critical.

    Unfortunately it has to be able to run across several versions from 2003.

    Thank you for your assistance.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Add date/time stamp to comment when cell is marked "X"

    Try this.
    The font size and name you'll have to solve.
    I've included something but it doesn't do the job.
    At least you've got the comment add.
    If x is removed, the commend it removed too
    Attached Files Attached Files

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Add date/time stamp to comment when cell is marked "X"

    Save the file as 2003 version and it will work too, I think

  6. #6
    Registered User
    Join Date
    10-18-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Add date/time stamp to comment when cell is marked "X"

    Hi Keebellah

    That's brilliant...works great.

    I'm no expert in these things...so please forgive my ignorance.

    I assume I just paste that code into my worksheet and change the range to suit?

    Absolutely amazing...did you just write that?...uncanny

    Thank you so much...

  7. #7
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Add date/time stamp to comment when cell is marked "X"

    Yes, it's just a quick an dirty.
    You can paste this code in worksheet's VBA and the range that it applies to must be set in the part hat says Intersect

    Please Login or Register  to view this content.
    Just set the range it applies to, do not forget the $ in the range

  8. #8
    Registered User
    Join Date
    10-18-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Add date/time stamp to comment when cell is marked "X"

    Hi Keebellah

    Just a little insight if possible.

    Worked great on your demo sheet...when i pasted code into my sheet and changed the range to suit my data...date stamp worked great.

    But when "X" was removed the comment remained...no big deal...as I said it can be done manually if an error is made.

    Only wondering why it would do that? As I said...I am completely bamboozeled by code.

    Again...thank you so much...

  9. #9
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Add date/time stamp to comment when cell is marked "X"

    If the cell is empty it removes it , if you place anothe value then it won't the code checks if there is an upper or lowercase x in the cell then the existing comment if present is deleted and the comment with the timestamp is added.
    If the cell is changed and the result is blank the comment is removed.

    Please Login or Register  to view this content.

  10. #10
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Add date/time stamp to comment when cell is marked "X"

    If the cell is empty it removes it , if you place anothe value then it won't the code checks if there is an upper or lowercase x in the cell then the existing comment if present is deleted and the comment with the timestamp is added.
    If the cell is changed and the result is blank the comment is removed.

    Please Login or Register  to view this content.
    You can change the code like this:

    Please Login or Register  to view this content.

  11. #11
    Registered User
    Join Date
    10-18-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Add date/time stamp to comment when cell is marked "X"

    Keebelah...thank you...all good.

    As with all things of this nature...which is completely out of my league...

    A larger font size would be nice...i find Tahoma 9 way to small for my weary eyes...Tahoma 12 would be nice...what and where would I be able to insert that.
    I tried..in my rock cracking style...but failed miserably I'm afraid.

    Any suggestions...better still answers.

    Code worked great when I put in the $ signs in the range...

    Again...thank you.

  12. #12
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Add date/time stamp to comment when cell is marked "X"

    That's the part where I cannot seem to get it to work
    Please Login or Register  to view this content.
    I modief to use the code shown above but to no avail.
    I guess you'll have to Google for it, sorry

  13. #13
    Registered User
    Join Date
    10-18-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Add date/time stamp to comment when cell is marked "X"

    Thank you so much...you have been most kind and most patient.

    Adding to your reputation...

  14. #14
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Add date/time stamp to comment when cell is marked "X"

    This one works:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Staic Date Stamp for adjacent cell being equal to "Dormant"
    By singerbatfink in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-09-2014, 09:36 AM
  2. [SOLVED] Generate Name Roster From Date Cells Marked "X"
    By rockytop80 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-10-2013, 02:54 PM
  3. User to input character "A", but cell will show time stamp, and lock the cell.
    By matrix1108 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2012, 01:02 PM
  4. Options marked with an "X" listed in a single cell separated by commas
    By jpecor2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-13-2011, 02:06 PM
  5. If date found in cell above, put "This Text" in comment
    By Tyman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2009, 04:41 PM
  6. create links to check boxes marked "good" fair"and "bad"
    By pjb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2006, 09:25 PM
  7. [SOLVED] How do I put a "date & time saved" stamp inside an Excel Wksht?
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-12-2005, 12: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1