time

A

ash

i want to record a static time so i found this way 2 do
it ctrl+shift+;, this worked but i want to put tis in2 a
macro so i can click a button and the static time will
appear in a cell! how do i do this?
 
P

Peo Sjoblom

Put this in a module, drag a button from the forms toolbar to your sheet and
assign the macro to it

Sub EnterDate_Time()
ActiveCell.Value = Now
ActiveCell.NumberFormat = "mm/dd/yy hh:mm:ss"
End Sub

if you only want the time change the number format to time only

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top