[RESOLVED] Showing timers in VBA

[Shmokin]

I have got a ten second timer working in my program using the code,

Application.Wait Now + TimeValue("00:00:10")

I now want to show the seconds on screen as they are going down. I came up with the following idea to do this,

Application.Wait Now + TimeValue("00:00:10") 
        
        ClockTimer = 0
        Do
            ClockTimer = ClockTimer + 1
            TimeValue ("00:00:ClockTimer")
            lblTimer.Caption = ClockTimer
        Loop Until ClockTimer = 10

i now realise how stupid this is since it waits till the ten seconds are up to run the loop, and the code doesn't work anyways, but can anyone think of a way to adapt my code slightly to make it work?