Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
im trying to instead of just showing "system busy. pls wait" to show "system
busy" "time left **sec's" this i got from a posting he Private Sub UserForm_Activate() Application.OnTime Now + TimeValue("00:00:05"), "KillTheForm" End Sub im trying to use this: Private Sub UserForm_Activate() Application.OnTime Now + TimeValue("00:00:30"), Label3.Caption.(30sec) Application.OnTime Now + TimeValue("00:00:20"), Label3.Caption = "20sec" Application.OnTime Now + TimeValue("00:00:10"), Label3.Caption = "10sec" Application.OnTime Now + TimeValue("00:00:05"), Label3.Caption = "05sec" Application.OnTime Now + TimeValue("00:00:05"), "KillTheForm" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Show real time in Userform caption | Excel Programming | |||
Change label caption on userForm while code runs | Excel Programming | |||
Changing label caption in a Userform to an opterator value | Excel Programming | |||
Userform - Label Caption - How to update from a variable | Excel Programming | |||
Label Caption Just Wont Work on UserForm | Excel Programming |