Counting Down

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

I have a timer that is 10:00 minutes:seconds. When I click on a button that
I created, I want to decrease the timer by like :30 seconds or so.

Should I do this by LOOKUP or does Excel have a function for this already?

Thanks,
Daniel
 
Is the "timer" a value in a cell?

You can attach this macro to your button:

Public Sub Drop30()
With Range("A1")
.Value = Application.Max(0, .Value - 30 / 86400)
End With
End Sub

I have no idea how you'd do it using Lookup.
 
Back
Top