Latest update on June 5, 2020 at 03:15 AM by Aoife McCambridge .

In the VBA, a simple second timer is easy to write and include in the source code. The VBA comes with a full-featured timer which can be used whenever required. However, it is not compulsory to use this timer already provided. Timer control in the VBA can be done through a manual timer too.With the VBA, a simple second timer can be created to enhance and customise the Office software especially for Excel worksheets. One needs to write the code to create a timer in a public module.

Create a Timer in VBA

In VBA there is Timer feature available, but you can also create one very easily. Follow these steps to do so:

In a module sheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

'For example: Start / Stop the timer every time the cell.

'but may also be placed on a button or another ...

TimeOnOFF = Not TimeOnOFF

If TimeOnOFF Then Timer

End Sub

In a public module:

Public TimeOnOFF As Boolean

Sub Timer()

Dim S As Integer

While TimeOnOFF = True

If Second(Now) > S Or Second(Now) = 0 Then

' Run code

'....

'for example

Sheets("shee1").Range("A1").Value = Time

S = Second(Now)

End If

DoEvents

Wend

End Sub

Image © Alexey Malkin - 123rom

Tags:
Tomasz David
Tomasz David

Leave a Comment