View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Auto insertion of date and time

Hi
See: http://www.mcgimpsey.com/excel/timestamp.html

-----Original Message-----
I'm trying to build a spreadsheet to log support calls,

all i need is a way
of inserting the time & date in a column as soon as data

is entered in
another column. I have done this using the Now()

function but the date &
time keep updating, I want them to remain the same as

when the first
appeared.

I have a bit of VB knowledge so am happy to do it this

way if required.

Any ideas?


TIA,

MC


.