#1   Report Post  
Richard
 
Posts: n/a
Default 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   Report Post  
Nick Hodge
 
Posts: n/a
Default

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   Report Post  
GregR
 
Posts: n/a
Default

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   Report Post  
 
Posts: n/a
Default

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   Report Post  
Nick Hodge
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating tvl time in Excel 2000 Rev.9.2720 Brandi Excel Worksheet Functions 5 January 27th 05 10:15 PM
entering numbers to display a time format Ian Williams/Eazygig Excel Discussion (Misc queries) 1 January 10th 05 12:57 PM
Help - Information with time and date PM Excel Discussion (Misc queries) 4 January 6th 05 09:25 AM
Time Stamp without change AntonyY Excel Discussion (Misc queries) 3 November 26th 04 10:13 AM
time formatting and time categorizing (vlookup or data validation) MarianneR Excel Worksheet Functions 4 November 18th 04 04:24 PM


All times are GMT +1. The time now is 05:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"