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


--
matpj
------------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=514330

User forms
 

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

User forms
 

thanks!
that works perfectly!

:

--
matp
-----------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=51433