View Single Post
  #1   Report Post  
Eckleburg
 
Posts: n/a
Default Timestamp Button


Hello All,

I am creating a form in excel for some other users to use to help
collect data about how long each step in a process takes to do. What
Iwould like to do is have a timestamp button that would put the current
date+time in a cell each time a milestone in the project is completed --
that way we will end up with a big list of timestamps compare and see
how long it really takes to do each part of our process.

I have tried to use a volital command like "=(now), but each time i use
it, it changes ALL the timestamps. I need something that can put a
timestamp in a form without affecting other timestamps on the page.

I am willing to try anything, including VBA, but I'll warn you I really
haven't used it ever before so instructions would have to be pretty low
level.

Any ideas anybody might have will be very gratefully appreciated.

Thanks!


--
Eckleburg
------------------------------------------------------------------------
Eckleburg's Profile: http://www.excelforum.com/member.php...o&userid=23933
View this thread: http://www.excelforum.com/showthread...hreadid=375643