View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Automatically entering time and date to an entry

You could use a worksheet_change event in the sheet module

target.offset(,1)=date
target.offset(,2)=time

--
Don Guillett
SalesAid Software

"Ashlee" wrote in message
...
How would I go about getting Excel to automatically attach the current
date
and time to every entry i make? I am trying to form a phone log, and
instead
of manually typing in the time and date of every phone call I record, I
wanted to see if there was any way it could be filled in automatically.