Filling in Current time in Excel

Microsoft Excel 2000
March 6, 2009 at 04:50:32
Specs: Windows XP
I know how to fill in the current time or the date. I also know how to attach a macro to a button. But how can i create a macro so that when a command button is pressed it fills in the current time or/and date?

See More: Filling in Current time in Excel

Report •

March 6, 2009 at 12:36:52
Sub MyTime()
  [A1] = Now
End Sub

Report •

March 8, 2009 at 16:16:51
Thanks very much but how do i get it to show me only the time or the date?
And how do i get it o move everytime i press it and ltes say A1 is already filled in,so that it fill out A2, etc?

Report •

Related Solutions

Ask Question