How to hide a form or make invisible in Excel

[dariusd77]

How do I make a fomr disappear after another form is opened. basically I have a menu that leads to sub menu(sub form s) so when I click on a button in the menu another form opens but i want the menu form to close. until I open it again by clicking on a button on the other form.

I tried the following but does not work

userform1.visible = false

and userform1.hide....

Neither works

here is the actual code.

Private Sub btnOpenDatasheetMenu_Click()




frmUsrDataSheet.Show


frmUserFormExample.Visible = False








End Sub

 

[xenou]

vbaProject.frmUserFormExample.Hide
vbaProject.frmUsrDataSheet.Show

You might want to consider using one tabbed form. Then you can easily switch between tabs as needed without having to keep track of multiple userforms.

 

[dariusd77]

vbaProject.frmUserFormExample.Hide
vbaProject.frmUsrDataSheet.Show

You might want to consider using one tabbed form. Then you can easily switch between tabs as needed without having to keep track of multiple userforms.

Ok i am very new at this..So I don't know what you mean by ..one tabbed form.. What is that?

 

[dariusd77]

vbaProject.frmUserFormExample.Hide
vbaProject.frmUsrDataSheet.Show

You might want to consider using one tabbed form. Then you can easily switch between tabs as needed without having to keep track of multiple userforms.

Do i have to use "vbaProject" or can i just use frmUserFormExample.Hide...

 

[dariusd77]

Do i have to use "vbaProject" or can i just use frmUserFormExample.Hide...

wow it work. Can you explain to me why you have to insert "vbaProject" in front of the form for it to work?

 

[xenou]

Hi,
I don't think I have a good explanation. It's just the way it is with forms - they just don't have the same scope as other objects in Excel.

 

[dariusd77]

Ok Thanks.either way..it worked.

 

[royUK]

I've never had to use vbaProject to do this. This type of code always works for me

Option Explicit


Private Sub CommandButton1_Click()
    Me.Hide '<- hides this userForm
    UserForm1.Show '<-displays the other UserForm
End Sub

However, one form with a MultiPage control is easier to work with as xenou suggested

 

[RoryA]

You don't need to qualify it with the project name. In fact, since you're referring to the form running the code you should use Me:

Private Sub btnOpenDatasheetMenu_Click()
Me.Hide
frmUsrDataSheet.Show
Me.Show
End Sub

Assuming your second form is modal (the default), this will hide the first form and load the second form, then whenever the second form is hidden or closed, the first form will be shown again automatically with no code required in the second form to show it. Indeed, you should not use code in the second form to reload the first or you will end up in a circular chain of events.

 

[dariusd77]

OK I will try this. I did however use the code by senou and it works. and I did put the code in both the first and second form..just flipping which form tho hide and to show. and it works..but I will try your code since it is more efficient. less code is always better.