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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pause a macro to display a form for x seconds then end
Check out XL VBA help for the Application object's Wait method.
-- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article , says... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pause a macro to display a form for x seconds then end
I use this:
Create a form i.e frmKvitto (In the macro:) Application.OnTime Now + TimeValue("00:00:03"), "CloseForm" (Sheets("Meny").Select) frmKvitto.Show Public Sub CloseForm() On Error Resume Next frmKvitto.Hide End Sub "MyKool" skrev: 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 |
Reply |
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 |