+ Reply to Thread
Results 1 to 1 of 1

VBA to timestamp and check previous value

  1. #1
    Registered User
    Join Date
    11-07-2019
    Location
    Lithuania
    MS-Off Ver
    Office 2013
    Posts
    52

    VBA to timestamp and check previous value

    Hello everyone,

    I have received help from one of the forum members on a new Registry, by using templates
    (Previous topic)
    https://www.excelforum.com/excel-pro...ate-table.html
    and adapted it to my own made registry. The thing is that some of the features are no longer available to my registry, because the method of creating new tables has changed. Previously i would copy table from adjacent cells, now it copies a table from another sheet. The features that don't work anymore are :
    1. After copying the table, check if the value r.Offset(0, -14) is the same as before r.Offset(-6, -14). Code:
    Please Login or Register  to view this content.
    2. A timestamp of the entry:
    Please Login or Register  to view this content.
    Thank you for any kind of help or tips.
    P.S. Full codes are in the previous topic.
    Last edited by baxius; 01-21-2020 at 12:26 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. [SOLVED] VBA to replace previous table and check if one cells value is equal to the previous one
    By baxius in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2019, 12:13 PM
  2. Check spelling in Excel, remember previous check
    By Un-Do Re-Do in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-18-2018, 11:37 PM
  3. Lookup previous date from timestamp
    By robonuk in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-30-2018, 05:03 PM
  4. Static timestamp using check box
    By dddavedg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-12-2016, 05:45 AM
  5. Check box Timestamp
    By blewbot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2010, 08:53 AM
  6. Macro to check for blank cell entry, copy previous value, and check for duplicates
    By xPunxNotDeadx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2009, 06:33 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