Thread
:
Automatically entering time and date to an entry
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett