View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones[_2_] Norman Jones[_2_] is offline
external usenet poster
 
Posts: 421
Default StopWatch Macros

Hi ExcelMS,

See the suggestions of Bob Phillips
and KeepITcool at:


http://tinyurl.com/69b6nd




---
Regards.
Norman


"ExcelMS" wrote in message
...
I am trying to create two Macros linked with two Excel buttons from the
forms
toolbar. I want the first button to be in cell B2 on Sheet 1 and say
start.
I want the second button to be in cell J2 on Sheet 1 and say End.

I want the first button which is the start button, when it is clicked to
give me the exact time in cell D2 on Sheet 2. I want the second button
which
is the end button, when it is clicked to give me the exact time in cell E2
on
Sheet 2. Do you have any ideas about how I might pull that off?