I need a VBA code to auto-start and show countdown moment form opens and closes when countdown completes. I would like other form contents unfreezed (clickable and working) while countdown is counting. I have tried the following but ain't working:
VBA Code:
Private Sub UserForm_Activate()
Application.OnTime (Now + TimeValue("00:00:01")), "UserForm_Activate"
Question1.Label1.Caption = "3"
Question1.Repaint
Application.OnTime (Now + TimeValue("00:00:01")), "UserForm_Activate"
Question1.Label1.Caption = "2"
Question1.Repaint
Application.OnTime (Now + TimeValue("00:00:01")), "UserForm_Activate"
Question1.Label1.Caption = "1"
Question1.Repaint
Unload Me
End Sub