Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pause a macro to display a form for x seconds then end
Hi, I have a macro which basically you click on and it brings uo a form
(Userform2) which you input a password and it unprotects a sheet. what I wish to do it once the button is clicked display a additional userform (Userform1) for say 3 seconds saying well done then hide the userform and carry on as normal. I have tried the following but does not work : (put in the userform2 button code) Private Sub CommandButton1_Click() UserForm2.Hide UserForm1.Show timeDelay = 1 UserForm1.Hide End Sub Please help me Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pause a macro | Excel Discussion (Misc queries) | |||
Pause Macro 2 | Excel Discussion (Misc queries) | |||
Converting Julian Seconds with a macro to replace old seconds data | Excel Discussion (Misc queries) | |||
Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming | |||
Pause during a Macro | Excel Programming |