title: create a countdown timer in excel 2010 using VBA (excel)
body: <p>I'm using Excel 2010, and want to create a countdown timer in excel. The code will be started and stopped by using buttons with macros attached to them. The problem occurs when the "start" button is pushed. The code above is utilizing Cell "B1" as the input spot, because I was just trying to get it to work, but every time I tried, it would always say: 
      "Cannot run the macro . The macro may not be available in this workbook or all macros may be disabled". </p>
  
  <p>Yes I enabled all macros before putting this here. I want to be able to take user input, and to make that the time that the timer starts at instead of just using cell "B1". </p>
  
  <pre><code>'Macro for Starting the timer (attached to the start button)
  Sub startTimer()
  Application.OnTime Now + TimeValue("00:00:01"), "nextTick"
  End Sub
  
  'Macro for next second
  Sub nextTick()
  Sheet1.Range("B1").Value = Sheet1.Range("B1").Value - TimeValue("00:00:01")
  startTimer
  End Sub
  
  'Macro for stopping the timer (attached to the end button)
  Sub stopTimer()
  Application.OnTime Now - TimeValue("00:00:01"), "nextTick", , False
  End Sub
  </code></pre>