Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Still stuck
Hello world
Still can't find the solution to this problem. I have a userform that shows for 10 seconds as a splash screen on the workbook_open event. What I would like to do is have a countdown timer from 10 to 1 to show the user that something is happening. I can get the textbox to show the intial value but I am having real problems in getting it to count down so the user can see the changes! 10 to 1 in under a second! I have looked at the ontime method, wait, pause method etc but don't seem to be able to get the correct syntax... Office 97 and XP home Mark (InWales) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Still stuck
Mark,
Try this. Put a label on your userform and the following code in the form activate event. Private Sub UserForm_Activate() Dim i Dim newhour Dim newminute Dim newsecond Dim waittime For i = 10 To 0 Step -1 newhour = Hour(Now()) newminute = Minute(Now()) newsecond = Second(Now()) + 1 waittime = TimeSerial(newhour, newminute, newsecond) Application.Wait waittime DoEvents Me.Label1 = i Next Unload UserForm1 End Sub Neil "Mark (InWales)" wrote in message ... Hello world Still can't find the solution to this problem. I have a userform that shows for 10 seconds as a splash screen on the workbook_open event. What I would like to do is have a countdown timer from 10 to 1 to show the user that something is happening. I can get the textbox to show the intial value but I am having real problems in getting it to count down so the user can see the changes! 10 to 1 in under a second! I have looked at the ontime method, wait, pause method etc but don't seem to be able to get the correct syntax... Office 97 and XP home Mark (InWales) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Still stuck
Take a look at the OnTime method in help, or here at
www.cpearson.com/excel/ontime.htm -- HTH RP "Mark (InWales)" wrote in message ... Hello world Still can't find the solution to this problem. I have a userform that shows for 10 seconds as a splash screen on the workbook_open event. What I would like to do is have a countdown timer from 10 to 1 to show the user that something is happening. I can get the textbox to show the intial value but I am having real problems in getting it to count down so the user can see the changes! 10 to 1 in under a second! I have looked at the ontime method, wait, pause method etc but don't seem to be able to get the correct syntax... Office 97 and XP home Mark (InWales) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Still stuck
S T U N N I N G
Thank you very much Neil for your help - excellent! Mark (InWales) "Mark (InWales)" wrote in message ... Hello world Still can't find the solution to this problem. I have a userform that shows for 10 seconds as a splash screen on the workbook_open event. What I would like to do is have a countdown timer from 10 to 1 to show the user that something is happening. I can get the textbox to show the intial value but I am having real problems in getting it to count down so the user can see the changes! 10 to 1 in under a second! I have looked at the ontime method, wait, pause method etc but don't seem to be able to get the correct syntax... Office 97 and XP home Mark (InWales) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorry but i am stuck again | New Users to Excel | |||
Im stuck again... | Excel Discussion (Misc queries) | |||
HELP!! It's STuck | Excel Discussion (Misc queries) | |||
stuck | Excel Worksheet Functions | |||
Ok now im stuck | Excel Programming |