+ Reply to Thread
Results 1 to 5 of 5

vba, date&time update when data is deleted or edited

  1. #1
    Registered User
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    84

    vba, date&time update when data is deleted or edited

    Hi

    I used this code so that each time a new data is added the date and time would be added automatically.
    Can someone please help me improve the code, so that if the data is deleted the date&time would be deleted as well. and When the data is edited the date&time would also change to when it was edited?

    Please Login or Register  to view this content.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,853

    Re: vba, date&time update when data is deleted or edited

    Try:

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,909

    Re: vba, date&time update when data is deleted or edited

    I was able to achieve the first of your request. Not sure the 2nd request is possible.

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    84

    Re: vba, date&time update when data is deleted or edited

    Quote Originally Posted by TMS View Post
    Try:

    Please Login or Register  to view this content.
    Thank you

  5. #5
    Registered User
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    84

    Re: vba, date&time update when data is deleted or edited

    Quote Originally Posted by maniacb View Post
    I was able to achieve the first of your request. Not sure the 2nd request is possible.

    Please Login or Register  to view this content.
    Thank you
    yeah maybe the code should be in the userform so that if the row is updated the date&time would be updated as well?

+ 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. How to update cells with edited data from user form
    By nynative in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-09-2014, 03:28 PM
  2. VBA Code For Once We Entered Data In Sheet then Data Should Not Be Edited or Deleted
    By sgolwalkar4ever in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-25-2012, 04:00 AM
  3. Date/Time stamp of last edited in worksheet.
    By excelkeechak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-24-2009, 01:07 PM
  4. auto update the date edited on column
    By SelinaT in forum Excel General
    Replies: 1
    Last Post: 02-17-2009, 01:56 AM
  5. Show date/time in a pre-determined column when data in row is edited...
    By Bwangster12 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-11-2008, 03:17 PM
  6. [SOLVED] update a date cell only when worksheet is edited
    By Joe Black in forum Excel General
    Replies: 1
    Last Post: 09-23-2005, 01:05 AM
  7. [SOLVED] text is deleted when cell is edited
    By GRIFFO in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-23-2005, 11:05 PM

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