View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_541_] Simon Lloyd[_541_] is offline
external usenet poster
 
Posts: 1
Default Date/Time Stamp Macro Button Problem

You could put the time stamp button on the toolbar at the top of you
worksheet using a macro button then assign a macro something like

Sub timeanddate()

ActiveCell.Offset(0, 1) = Now

End Sub

When the button is clicked it will select the cell next to the activ
one and enter the date and time.

HTH

Simo

--
Message posted from http://www.ExcelForum.com