+ Reply to Thread
Results 1 to 1 of 1

Detect when a cell value has changed

  1. #1
    Registered User
    Join Date
    01-25-2018
    Location
    Mexico
    MS-Off Ver
    2016
    Posts
    3

    Detect when a cell value has changed

    Hello guys! Nice to be here, I'm posting about a problem that idk how to figure it out...you see I got this code "writing" with the actual date in column S X-cell when something in the column P X-cell (everything happening in the same row) is modified.
    Everything is just fine with that, the thing is... even when I don't modify anything in the selected cell it's puts the date only by double-clicking on it (obvs it work if I modify something).

    So... the thing I want to achieve it's that this thing only "writes" the date on X-Cell column S only when really the X-cell Column P it's modified and not when I double click on it.

    Here's the code that I'm using...


    Please Login or Register  to view this content.
    Moderator Note: Your post does not comply with our Forum RULES. Use code tags around code.

    Posting code between
    Please Login or Register  to view this content.
    tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window.

    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Last edited by alansidman; 01-30-2018 at 09:16 PM.

+ 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. Replies: 1
    Last Post: 01-17-2017, 02:23 PM
  2. Replies: 7
    Last Post: 05-07-2014, 02:01 AM
  3. [SOLVED] Using a cell-linked text box to detect a calculated cell change and set value of scrollbar
    By darwin003 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2013, 08:29 PM
  4. [SOLVED] Worksheet_change, how to detect a range is changed instead only 1 cell?
    By vin1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2012, 06:16 AM
  5. How to detect row changed date and time? Is it need to write a macro?
    By cheeloont in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-12-2010, 11:29 PM
  6. Detect when cell data has changed?
    By excelbobabc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2009, 11:50 AM
  7. Detect when a Cell value has changed. Working too well :-(
    By CRayF in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2005, 03:05 AM

Tags for this Thread

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