+ Reply to Thread
Results 1 to 1 of 1

Audit log for data inserted-edited via VBA Forms

  1. #1
    Registered User
    Join Date
    12-03-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    36

    Audit log for data inserted-edited via VBA Forms

    Hi Team,

    I have a tracker which records the incoming invoices via excel forms and also let the users update the status of these invoices as and when there is a change in the status of the invoices.

    I am trying to record each modification which has been done on the "Data" sheet by way of creating an audit log.

    Have updated the "Data" sheet with a macro which captures the user name and the "To" value which is changed, however I am unable to get the "From" value.

    Any assistance in this regard would be of great help to me.

    Regards,
    Raghu
    Attached Files Attached Files

+ 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] How to make audit trail to log which persons ever edited an excel file?
    By ohlalayeah in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-22-2014, 07:46 PM
  2. Trying to pull 10 percent of data for audit
    By noobexceldude in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2014, 11:40 PM
  3. 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
  4. [SOLVED] VBA to clean and audit data
    By Yg74 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-23-2012, 01:47 PM
  5. Should Merging workbooks pick up new data or only edited data?
    By Peggy L. in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-13-2005, 02: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