VBA - Timer Function


Advertisements

The Timer Function returns the number of seconds and milliseconds since 12:00 AM.

Syntax

Timer() 

Example

Add a button and add the following function.

Private Sub Constant_demo_Click()
   msgbox("Time is : " & Now())
   msgbox("Timer is: " & Timer())
End Sub

When you execute the above function, it produces the following output.

Time is : 19/07/2013 3:45:53 PM
Timer is: 56753.4 
vba_date_time.htm
Advertisements