Record changes made from a vb form
 

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



--
Please remove "no.thanks."
and add "blue" in front of yonder to email me.
Sorry for inconvenience but feed up of spam mail

Record changes made from a vb form
 

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

-----Original Message-----

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



--
Please remove "no.thanks."
and add "blue" in front of yonder to email me.
Sorry for inconvenience but feed up of spam mail


.