LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating button as cell jpizzle Excel Discussion (Misc queries) 1 June 1st 05 01:22 PM
Command Button anomalies RWN Excel Discussion (Misc queries) 5 May 4th 05 05:09 AM
Command Button VBA code Dave Peterson Excel Discussion (Misc queries) 2 January 25th 05 11:28 PM
command button moves Stuart Excel Discussion (Misc queries) 2 December 15th 04 05:56 PM
How do I setup a spin button in excel Andy K Excel Discussion (Misc queries) 1 November 26th 04 09:08 PM


All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"