View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Li Bill Li is offline
external usenet poster
 
Posts: 46
Default 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


.