Welcome to Ozgrid.
Have you looked at the ShowModal property of the Userform ?
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 :/.
welcome to Ozgrid.com
u can hide one while using the other
hope this helpsVB:Private Sub CommandButton1_Click() UserForm1.Hide UserForm2.Show End Sub
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)