Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time Stamp
I need to have a cell stamped with the currant time. If I
use now() the time changes every time the cell is recalculated. How can this be done? |
#2
|
|||
|
|||
Richard
When is the cell stamped? On opening/closing, printing, any change, etc? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Richard" wrote in message ... I need to have a cell stamped with the currant time. If I use now() the time changes every time the cell is recalculated. How can this be done? |
#3
|
|||
|
|||
Richard use Control+Colon. HTH
Greg "Richard" wrote in message ... I need to have a cell stamped with the currant time. If I use now() the time changes every time the cell is recalculated. How can this be done? |
#4
|
|||
|
|||
I want to stamp cell A1 when I change the value in cell
B1. Thanks. -----Original Message----- Richard When is the cell stamped? On opening/closing, printing, any change, etc? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England "Richard" wrote in message ... I need to have a cell stamped with the currant time. If I use now() the time changes every time the cell is recalculated. How can this be done? . |
#5
|
|||
|
|||
You could use the worksheet_change() event. The code below will place the
current date and time in A1 when any change is made in B1 Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("B1")) Is Nothing Then Application.EnableEvents = False Target.Offset(0, -1).Value = Now() End If Application.EnableEvents = True End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS wrote in message ... I want to stamp cell A1 when I change the value in cell B1. Thanks. -----Original Message----- Richard When is the cell stamped? On opening/closing, printing, any change, etc? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England "Richard" wrote in message ... I need to have a cell stamped with the currant time. If I use now() the time changes every time the cell is recalculated. How can this be done? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
Time Stamp without change | Excel Discussion (Misc queries) | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |