Record changes made from a vb form

[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

 

[Bill Li]

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