Form

[Guest]

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

 

[Robert Bruce]

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.