m_in_spain
Board Regular
- Joined
- Sep 28, 2018
- Messages
- 72
- Office Version
- 365
- Platform
- Windows
Hi, (again!) I am trying to start a countdown of numbers from X to zero and meanwhile carry on down the Sub continuing to do the process while my counter returns the count down mumber to my user form.
I can get the code to start the countdown, and return the number to my user form, but cannot seem to get the original code to carry on at the same time.
Here is a snippet of what works ok, and where it stops... is this even possible to do?
So the procedure "Start Countdown" works fine, but i want to simulaneously continue on to the If nochg... bit
the countdown is a number that decreases by 1 until it hits zero, basically a clock countdown but using numbers instead of time firmat
Any guidance is much appreciated
I can get the code to start the countdown, and return the number to my user form, but cannot seem to get the original code to carry on at the same time.
Here is a snippet of what works ok, and where it stops... is this even possible to do?
VBA Code:
nextScheduledTime = Now
Application.OnTime EarliestTime:=nextScheduledTime, Procedure:="Start_Countdown", Schedule:=True
If nochg = Range("numCHG") Then GoTo line990
UserForm1.Label32.Caption = ("CHARGE ") & (Zn - Zn + 2)
If n < t * 0.75 And f > 0 Then
the countdown is a number that decreases by 1 until it hits zero, basically a clock countdown but using numbers instead of time firmat
Any guidance is much appreciated