Clock and lightweight buttons in Excel VBA


Dim blnClockRunning As Boolean

Sub startclock() 'assign start button
 blnClockRunning = True
 clock
End Sub

Sub clock()
 If blnClockRunning = False Then Exit Sub
 ActiveWorkbook.Worksheets(1).Cells(1, 1).Value = Format(Now, "hh:mm:ss")
 Application.OnTime (Now + TimeSerial(0, 0, 1)), "Sheet1.clock"
End Sub

Sub stopclock() 'assign stop button
 blnClockRunning = False
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Address(True, True, xlA1) = "$B$1" Then
        Range("B1") = "Start"
        Range("B1").Select
        Selection.Font.FontStyle = "Bold"
        Selection.Font.ColorIndex = 2 ' White
        Selection.Interior.ColorIndex = 1 ' Black
        Call startclock
    End If
    If Target.Address(True, True, xlA1) = "$C$1" Then
        Range("C1") = "Stop"
        Range("C1").Select
        Selection.Font.FontStyle = "Bold"
        Selection.Font.ColorIndex = 2 ' White
        Selection.Interior.ColorIndex = 1 ' Black
        Call stopclock
    End If
End Sub


Analogue Excel Clock