VBA: Add a simple timer

August 14th, 2004 | Categories: VBA | Tags: timer, VBA

-->

There are many instances when a timer could be useful in Excel, here is one method to try:

Put this in a module:

Sub MyTimer()
Application.Wait Now + TimeValue("00:00:05")
MsgBox ("5 seconds")
End Sub

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!