Solved: How to open a form from another form

[fiza]

Hi Anyone,

I'm searching for a code to open a form from another form in excel 2007.

Any help will be appreciated.

Thanks
Fiza

[mdmackillop]

[vba]Private Sub CommandButton1_Click()
UserForm2.Show
End Sub
[/vba]

Also consider a MultiPage form if you're inputting data from both. It looks more "professional"

BTW, Please do not rate your own question on posting it.

[fiza]

Hi mdmakillop

Thanks for the help. I really appreciate it. Ill take your advice to build up my form.Moreover I want to know how to modify the code if I wanted to open a worksheet from the form.Thanks in advance.

Regards
Fiza

[mdmackillop]

To work on a sheet, you will need to open your form non-modally

[vba]

Userform1.Show False

[/vba]

To open another sheet

[vba]

Private Sub CommandButton2_Click()

Sheets(2).Activate
End Sub

[/vba]

[fiza]

Thanks for the help. It was really helpful.