User forms

[matpj]

Hi,

I have a user form that presents the user with a list box and a 'run'
button.
when this button is pressed I want to display another user form,
resized to show only the title-bar.

this will display 'Please Wait...'

the only thnig is, i get an error when I try to run it :
"cant show non-modal form when modal form is displayed"

can anyone suggest a way to get around this?

thanks in advance,
Matt

 

[Guest]

Hi,
Show both as modeless

Userform1.show vbmodeless
......
Userform2.show vbModeless ' <=== from your Button_Click macro

Both will appear on screen

 

[matpj]

thanks!
that works perfectly!

: