Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form
Hello all
how could i do something like this without stop the macro run? i have a form that when i click ok buttom(on userform)....begins to run a macro...and i want to show a wating form so what i do is this: unload userform waiting_form.show 'here i put all the code 'but only get here when i close the waiting_form unload waiting_form msgbox("Finish.") the problem is when i do waiting_form.show stops the macro and donĀ“t run the code bellow until i close it thanks in advance Miguel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form
Roedd <<Liedson31 wedi ysgrifennu:
Hello all how could i do something like this without stop the macro run? waiting_form.show waiting_form.show vbModeless 'doesn't work in Excel97 - post back if you are using Office97 -- Rob http://www.asta51.dsl.pipex.com/webcam/ This message is copyright Robert Bruce and intended for distribution only via NNTP. Dissemination via third party Web forums with the exception of Google Groups and Microsoft Communities is strictly prohibited and may result in legal action. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
how can I make a form number change everytime the form is opened | Excel Worksheet Functions | |||
Help! Animated gif-image in form does not show animation when form loaded | Excel Programming | |||
Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form? | Excel Programming |