View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
 
Posts: 644
Default code need for time stamp

ActiveCell = Time 'Time only
ActiveCell = Date & " " & Time 'Date And Time

HTH

Die_Another_Day

wildauk wrote:
Hi, I need a code for a button so when I press it the time is shown in say
cell A1 and it will not change untill I press the button agian.

Thank's inadvance, Barry.