I would like a main screen that would call other forms when clicking on
different buttons on the main screen (splash screen). Is it best to create
the main screen in
Excel worksheet with the form tools or in VB UserForm? How do I call other
forms using the buttons on the main screen? Thank you in advance.

hi
I create my forms in the vb editor. i am not sure which is best. but to call
a form from a button, in the button code put......
Sub showforms()
Load userform1
userform1.Show 0
End Sub

if you have other forms, they will be numbered. just put the appropriate
form name.

Regards
FSt1

"TotallyConfused" wrote:

I would like a main screen that would call other forms when clicking on
different buttons on the main screen (splash screen). Is it best to create
the main screen in
Excel worksheet with the form tools or in VB UserForm? How do I call other
forms using the buttons on the main screen? Thank you in advance.

I used this code and it does work. I want to be able to click on button
(commandbutton1) and it will show next form. what am I missing?
"FSt1" wrote:

hi
I create my forms in the vb editor. i am not sure which is best. but to call
a form from a button, in the button code put......
Sub showforms()
Load userform1
userform1.Show 0
End Sub

if you have other forms, they will be numbered. just put the appropriate
form name.

Regards
FSt1

"TotallyConfused" wrote:

I would like a main screen that would call other forms when clicking on
different buttons on the main screen (splash screen). Is it best to create
the main screen in
Excel worksheet with the form tools or in VB UserForm? How do I call other
forms using the buttons on the main screen? Thank you in advance.

Please disregard previous post. I got it to work. Thank you very much.

"TotallyConfused" wrote:

I used this code and it does work. I want to be able to click on button
(commandbutton1) and it will show next form. what am I missing?
"FSt1" wrote:

hi
I create my forms in the vb editor. i am not sure which is best. but to call
a form from a button, in the button code put......
Sub showforms()
Load userform1
userform1.Show 0
End Sub

if you have other forms, they will be numbered. just put the appropriate
form name.

Regards
FSt1

"TotallyConfused" wrote:

I would like a main screen that would call other forms when clicking on
different buttons on the main screen (splash screen). Is it best to create
the main screen in
Excel worksheet with the form tools or in VB UserForm? How do I call other
forms using the buttons on the main screen? Thank you in advance.