Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I guess it wasn't clear to me that the OP wanted these cells
automatically updated every time somebody entered something in ANY cell, so I left it this way to provide more flexibility. If it needs to be called anytime any cell is changed on this same worksheet (or any other worksheet, for that matter), then put this code in the Worksheet_Change event handler for this (or any other) worksheet (it simply calls the StampTime routine): '---------------------------------------------------------------------- Private Sub Worksheet_Change(ByVal Target As Range) StampTime End Sub As a matter of programming flexibility, this is a better way to do event routines anyway. I can print out the standard code module, and have virtually all of the code, without having to go check each worksheet and chart code module. -- Regards, Bill Renaud |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
is it possible to time stamp cell comments? | Excel Discussion (Misc queries) | |||
is it possible to time stamp cell comments? | Excel Discussion (Misc queries) | |||
time stamp a cell that doesn,t change when time stamping another | Excel Programming | |||
Inserting time stamp onchange of any cell | Excel Programming | |||
Setting up a date and time stamp in a cell | Excel Programming |