Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
record update VBA form | Excel Discussion (Misc queries) | |||
copy check boxes (made from form toolbar) | Excel Discussion (Misc queries) | |||
Formula that will record the time and date when an entry is made on a sheet | Excel Worksheet Functions | |||
Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
Using an Excel VB-made form in cell-specific conditions. | Excel Worksheet Functions |