Ask a new question

Calling a userform from another userform

I'm new at using userforms in VBA, but need some help in knowing how to call up a userform from another userform.  Example, my desire is to have one main Userform and then by selecting one of several different buttons, proceed to another useform, and after finishing task go back to the original.  I have tried looking on the web but can not find anything that shows me how to do these steps.  Any direction as to where to go look, or help otherwise would be much appreciated.

 

Steve

Answer
Answer

Hi,

try something like this..

 

Private Sub CommandButton1_Click()
Unload Me ' UserForm1
UserForm2.Show
End Sub

 

XXXXXXXXXXXXXXXXXX

 

and in each CommandButton on UserForm2

before End Sub

add the lines..

..................

Unload Me 'UserForm2
UserForm1.Show
End Sub

--------------------------------
Microsoft365 on Windows 10
---------------------------------

28 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated January 28, 2024 Views 15,289 Applies to: