Hide Userform modeless
 

Hi,
I've two userform in the Excel VBA application.
The one is modal and the other modeless.
I should hide the modeless userform in some cases.
How can I do?

Thanks in advanced
Ger



*** Sent via Developersdex http://www.developersdex.com ***

Hide Userform modeless
 

Hi Ger,

Try something like:
'=============
Private Sub CommandButton1_Click()
Me.Hide
UserForm1.Hide
Me.Show
End Sub
'<<=============


---
Regards,
Norman


"Ger" wrote in message
...
Hi,
I've two userform in the Excel VBA application.
The one is modal and the other modeless.
I should hide the modeless userform in some cases.
How can I do?

Thanks in advanced
Ger



*** Sent via Developersdex http://www.developersdex.com ***

Hide Userform modeless
 

Hi Ger,

See (at least) one response to your original post.



---
Regards,
Norman


"Ger" wrote in message
...
Hi,
I've two userform in the Excel VBA application.
The one is modal and the other modeless.
I should hide the modeless userform in some cases.
How can I do?

Thanks in advanced
Ger



*** Sent via Developersdex http://www.developersdex.com ***

Hide Userform modeless
 

Hi Ger,

Please ignore my last post!



---
Regards,
Norman


"Norman Jones" wrote:

Hi Ger,

See (at least) one response to your original post.



---
Regards,
Norman


"Ger" wrote in message
...
Hi,
I've two userform in the Excel VBA application.
The one is modal and the other modeless.
I should hide the modeless userform in some cases.
How can I do?

Thanks in advanced
Ger



*** Sent via Developersdex http://www.developersdex.com ***

Hide Userform modeless
 

Thank you, thank you very much!!!! :-)
It works OK

Then I use to visualize it again
=============
Private Sub CommandButton2_Click()
Me.Hide
UserForm1.Show 0
Me.Show
End Sub
'<<=============

Thank you again and again!!!!!
Ger

*** Sent via Developersdex http://www.developersdex.com ***

Hide Userform modeless
 

Sorry!!! But I've another problem!
In the first time I've already visualized my modal form, but when I use

=============
Me.Hide
UserForm1.Hide
Me.Show
'<<=============

the code is blocked in Me.Show and the following operation
are not executed.

Bye and thanks
Ger

*** Sent via Developersdex http://www.developersdex.com ***

Hide Userform modeless
 

Hi!
I've discovered that to visualize the NoModal form, the Modal form have
been unloaded in the right points of the code with

Unload frmModal

Bye
Ger



*** Sent via Developersdex http://www.developersdex.com ***