title: How to make a timer like digital watch?
body: <p>I was trying to make digital watch in excel. So, when I will open a workbook then in a cell, lets say in <code>E3</code> cell will show time and it will continue in every second so that it looks like a digital watch. I can do it in <code>Access</code> as access <code>Form</code> has <code>On Timer</code> event where I can write code to show time in a <code>Textbox</code>. Is there any alternative way in excel. I have tried below codes. But the codes need to click manually on <code>Button1</code>. Can I make it automatic to run the <code>Button1_Click()</code> sub in every second?</p>
  
  <pre><code>Sub Button1_Click()
      Application.OnTime Now(), "RunningTime"
  End Sub
  
  Sub RunningTime()
      Range("E3") = Format(Now(), "hh:mm:ss")
  End Sub
  </code></pre>
  
  <p><strong>I have also tried <code>Workbook_Open()</code> method but it runs once when I open the file.</strong></p>
  
  <pre><code>Private Sub Workbook_Open()
      Application.OnTime Now(), "RunningTime"
  End Sub
  </code></pre>