Timer causing glitches every second

[B-Man]

I have setup a timer in excel using the below and its fine everything works.
my only issue is the screen glitches ever so slightly every time the macro runs(every second) not a big issue viisually but sometimes if im typing or trying to edit a formula or macro it can cause it to cancel what im doing.
is there a better way to have a timer running?

Option Explicit

Dim NextTick As Date, t As Date, PreviousTimerValue As Date
Sub setKey()
    Application.OnKey "+^:", "EnterTime"
    End Sub
Sub resetKey()
    Application.OnKey "+^:"
    End Sub
Sub EnterTime()
    With ActiveCell
    .Value = Time()
    .NumberFormat = "hh:mm:ss"
        End With
    End Sub

Private Sub ExcelStopWatch()
ElectronicForm.Range("StopWatch").Value = Format(Time - t + PreviousTimerValue, "hh:mm:ss")
NextTick = Now + TimeValue("00:00:01")
Application.OnTime NextTick, "ExcelStopWatch"
End Sub

 

[GTO]

I would suggest against have the code altering a range (cell) while you are typing. If wanting to watch the seconds roll by, a modeless userform might be satisfactory.

 

[B-Man]

Thanks. I will look into that.
Can I have that open while I have another userform open?
And can I grab the current time on the timer from the user form for another macro?

 

[B-Man]

thanks @GTO finally got around to creating and testing a modeless userform and works a treat solved my issue.