I'm running a Macro in PowerPoint (A countdown), that I want to update every second while the presentation is being run.
Where do I have to put the code to initiate the macro and what syntax do I have to use to get the loop to happen every second (Application.Wait doesn't seem to be avaiable in PPt).
Here's the code so far...
Any help appreciated, this my first Macro outside of Excel...
Private Sub UPdateCLock()
Dim DaysY As Double, DaysZ As Double
Dim HoursX As Double, HoursY As Double, HoursZ As Double
Dim MinsX As Double, MinsY As Double, MinsZ As Double
Dim SecsX As Double, SecsY As Double, SecsZ As Double
DaysY = (34969875 / 900) - Now
DaysZ = Round(DaysY - 0.5, 0)
HoursX = DaysY - DaysZ
HoursY = HoursX * 24
HoursZ = Round(HoursY - 0.5, 0)
MinsX = HoursY - HoursZ
MinsY = MinsX * 60
MinsZ = Round(MinsY - 0.5, 0)
SecsX = MinsY - MinsZ
SecsY = SecsX * 60
SecsZ = Round(SecsY, 0)
Shapes("TextBox1").OLEFormat.Object.Text = DaysZ & " Dys " & HoursZ & " Hrs " _
& MinsZ & " Mins " & SecsZ & " Secs until the Spring Conference"