User forms

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

Hi,
Show both as modeless

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

Both will appear on screen

"matpj" wrote:

>
> 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
>
>
> --
> matpj
> ------------------------------------------------------------------------
> matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
> View this thread: http://www.excelforum.com/showthread...hreadid=514330
>
>

thanks!
that works perfectly!