title: Stopwatch in excel vba?
body: <p>I'm trying to set up a basic stopwatch for tracking elapsed time. Button1 should start the clock at 0, Button2 stops the watch, and records how many minutes and seconds have elapsed since the timer started.  I have the buttons lodged on a worksheet, and just need a way to calculate elapsed time.  What would be the best approach? 
  Here is the code i have been working with</p>
  
  <pre><code>Private Sub CommandButton1_Click()
      startTime = Timer
  End Sub
  
  Private Sub CommandButton2_Click()
      Dim finalTime As Single
      finalTime = Timer - startTime
      MsgBox Format(finalTime, "0.00")
  End Sub
  </code></pre>
  
  <p>The problem with this code is that it display the time elapsed only after i click button2. I need a running timer on my excel sheet. </p>