Can I show a UserForm\Msgbox while code continues?


Posted by Peter on June 27, 2000 4:27 PM

Does anyone know if I can Show a UserForm or a messagebox while code is still executing? Currently I use the StatusBar to alert users to what is going on while the macro has the screenupdating off, but it would be great to use a userform of some type instead... any suggestions??
Peter

Posted by Peter on June 28, 0100 1:10 AM

Ahh - unfortunately I'll have to wait until the IT department get around to purchasing XL2000. Thanks for your help though, I'll keep it in mind.
Regards,
Peter

Posted by ken on June 28, 0100 1:32 AM

sounds like a good excuse to upgrade if the bigwigs want it that way

Posted by Ivan Moala on June 28, 0100 1:56 AM

There are other ways around getting what you want?
If I understand your Q, you are after a userform
to display while running your code ?? similar to
having a splash screen with some msg on it.
If so then there are a number of ways to do this
1) If you do want a userform then your code should
be in the userform.initialise routine.
2) You can create on the fly a textbox with a msg
3) Create your image or textbox msg and just use
its visible property to display when required.
4) you can via userforms creat progressbars to
display
have a look @ this site formore info
http://edc.bizhosting.com/english/index.htm

If you require examples I would be happy to show
you


Ivan



Posted by Ryan on June 27, 0100 10:42 PM

Peter,
If you have XL97, there is no hope, but in XL2000, you can show a UserForm "Modeless", instead of Modal. Here is the proper syntax:

UserForm1.Show Modeless

Hope this helps, let me know.
Ryan