1
Thanks

A few words of thanks would be greatly appreciated.

Create A Simple Second Timer With VBA For Excel

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 - 123rf.com
1
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Related

This document, titled « Create A Simple Second Timer With VBA For Excel », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

2 Comments