voldval

  1. S

    problems with audit trail

    Hi all I have the code below which should record changes to cells in a worksheet - recording cell, old value, new value, time, date and domain name of person that made changes. It works well, except: 1. the old value is never recorded and just shows a blank. how do I record the old value...
  2. O

    Macro for tracking changes on multiple worksheets

    This is my first question on this website but I've been using this site for a while now teaching myself basic VBA skills...thank you all so much! Now to my question... I'm looking to have a macro that will track any change on any worksheet. I've found code that does this but it only...
  3. N

    Issue with code for tracking work

    Hi, I am using this code to track work changes on a sheet. Everything works perfectly apart from the tracking of the old value. I see what the value has changed too, but It will not show what the value has changed from (old value). Option Explicit Dim vOldVal 'Must be at top of module...
  4. N

    Also capture username within this VBA action

    Hi, I am using VBA code to track changes to an excel spreadsheet, currently recording Cell changed ref Old Value New Value Time of change Date of Change I need to add Who changed it (Windows username). The code I need to add to is below, would be great if someone could assist with this...
  5. N

    track changes to worksheet with VBA

    Has anyone ever tried to track changes with VBA. I am currently tring this solution: http://sourcedaddy.com/ms-excel/track-changes-particular-worksheet.html The code it states to use is this: I am getting red lines for some reason as in the code, I also get an error when i try it out...
  6. B

    Trace any change on sheet using Excel Comments

    Hi All, At the moment I am working on how to track any change on cells by using comments. I got this code for track the change on a sheet 'Track/Report User Changes on 1 Particular Worksheet. _ The code below must be placed in the Private Module of the Worksheet you would like changes tracked...
  7. Y

    Track changes by adding comment

    Good morning Mr Excel Forum, Thanks in advance everybody for reading, helping, advicing. i am looking to track changes in an excel sheet in a non-shared workbook. The old value should be written to the cell's comment on top of the previous tracking comment. It is supposed to not be modified by...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top