Hide Userform modeless

[Ger]

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

 

[Norman Jones]

Hi Ger,

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

 

[Johz]

either set it's visible property to false or call it's hide -function...
frmModeless.visible = false
or
frmModeless.hide

 

[Norman Jones]

Hi Ger,

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

 

[Guest]

Hi Ger,

Please ignore my last post!

 

[Ger]

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

 

[Ger]

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

 

[Ger]

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