Record changes made from a vb form

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi,
Can anyone give me some ideas on how to go about the following:
I want want to record the changes a user makes to a spreadsheet and save
them to a txt file or csv file with the following info:
Date and time edited
cell info changed from.
cell info changed to
User who made changes
(all changes will be text based)

Thanks for your help


Dave
 
Hi Dave,

Via the Worksheet_SelectionChange event, you can trace any
changs in the spreedsheet. Save the following example
under you spreedsheet code and try.

Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
With ActiveWindow
.ScrollRow = Target.Row
.ScrollColumn = Target.Column
End Sub

Best Regards

Bill
 
Back
Top