PDA

View Full Version : how do i show the userform?



Ago
02-15-2008, 04:43 AM
im trying to make a very simple progressbar, but when i run the code it stops on UserForm1.Show

i need that to show the progress, but the code just stops and wont run untill the userfom is closed again.
and that doesnt really help me :-(

so how do i show the userform without stop ing the makro/code?

qff
02-15-2008, 04:56 AM
Hi

Your form is set to show on modal mode i.e. the form must be closed before the macro can continue.

You can use UserForm1.Show(0) to turn off modal mode and (1) to turn it on.

Ago
02-15-2008, 05:02 AM
ahh! i see. thank you!

Stefan
05-19-2008, 05:56 AM
Hi,

The "modal" solved a similar problem for me. Each time I tried to show a form the VBA editor appeared and I had to press F5 to continue. The same program have been in commercial use for several years so obviously the 2003 Excel version on my PC must have some kind of influence.

Thanks!

/Stefan