Excel VBA - stopwatch

[stevieh]

hi people,

is there a way to setup a macro that records a time (like a stopwatc
and the record this in a cell???

cheers

stev

 

[DNF Karran]

Is it a specific time you want or a counter that rises as time passes
To just get a specific time and record it in a cell you can use th
NOW() function.

Dunca

 

[stevieh]

Hi there,

Just like a stopwatch, so i click a button to start and one to stop

Hope that helps

thanks

stev

 

[DNF Karran]

If you want something that counts visually on screen you will need t
get into programming the API- something that scares me everytime I loo
at it!!!

An alternative is:

Set up a user form with 2 buttons- start & stop.

When the first button is clicked it uses the Now() function the stor
the current time (in a hidden text box for example).

When you click stop it uses the subtacts the stored time from th
current time using Now() again and stores the value in a cell.

Dunca