Results 1 to 5 of 5

Update timestamp only first time

Threaded View

  1. #1
    Registered User
    Join Date
    10-28-2015
    Location
    Paris
    MS-Off Ver
    Office 2013
    Posts
    5

    Update timestamp only first time

    Hello, I need to update timestamp value only first time when insert value into another cell and not in next updates.

    This is the code that I'm using now:

    
    Sub Worksheet_Change(ByVal Target As Range)
       
       If Target.Column = 3 Then
       
            Application.EnableEvents = False
            Dim strTime As String
            
            strTime = Format(Now, "HH:nn:ss") & "." & Right(Format(Timer, "#0.000"), 3)
            
            Cells(Target.Row, 20).Value = Date & " " & strTime
            
            Application.EnableEvents = True
            
       End If
         
    End Sub
    Last edited by asterixo500; 11-19-2015 at 10:07 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Timestamp each time a cell value changes
    By nenadmail in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-12-2016, 02:52 PM
  2. Replies: 1
    Last Post: 03-28-2014, 12:45 PM
  3. update timestamp if change_event for all column in row
    By dainova in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-07-2012, 01:29 AM
  4. If cell A1 already contains a value don't update timestamp in B1
    By BEERCAN in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-25-2011, 01:26 PM
  5. Last time modified timestamp
    By Mikus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-23-2005, 03:05 AM
  6. [SOLVED] Is there a Timestamp function that does not update in Excel?
    By Guard 823 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2005, 11:06 AM
  7. Timestamp function that does not update in Excel?
    By Guard823 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2005, 10:06 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