Announcement

Collapse
No announcement yet.

Multiple Active Userforms

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Multiple Active Userforms



    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 :/.

  • #2
    Re: Multiple Active Userforms

    Welcome to Ozgrid.

    Have you looked at the ShowModal property of the Userform ?
    locii Insight
    Locii Solutions. Business IT Training. Business Consulting. Excel Training. Business Intelligence using Excel 2010. Cyprus.

    Comment


    • #3
      Re: Multiple Active Userforms

      hi GravityAB,

      welcome to Ozgrid.com

      u can hide one while using the other
      Code:
      Private Sub CommandButton1_Click()
      UserForm1.Hide
      UserForm2.Show
      End Sub
      hope this helps
      Cheers
      ___________
      Xlite
      All you need to learn VBA is an internet connection and Ozgrid.com

      Comment


      • #4


        Re: Multiple Active Userforms

        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.

        Comment

        Working...
        X