Multiple Active Userforms

[GravityAB]

Is it possible to have multiple active Userforms at the same time? I want to be able to edit/change information on both UserForms without having to close the other one.

I kinda dont want to have to combine both of these large programs together if I can avoid it at all costs.

I find myself using 2 different instances of excel and it can get quite anoying :/.

[carlmack]

Welcome to Ozgrid.

Have you looked at the ShowModal property of the Userform ?

[xlite]

hi GravityAB,

welcome to Ozgrid.com

u can hide one while using the other

Private Sub CommandButton1_Click() 
    UserForm1.Hide 
    UserForm2.Show 
End Sub 

hope this helps

[GravityAB]

OMG... Thank you so much carlmack! I set both UserForms ShowModal to False and it is now allowing both programs to be opened from the same Excel file.

Now that both are set to False, the code that contains the UserForm.Show will need to be adjusted because it no longer stops there until that UserForm closes, which is fine by me.