Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 4 of 4

Thread: Multiple Active Userforms

  1. #1
    Join Date
    4th December 2005

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

    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    14th January 2005

    Re: Multiple Active Userforms

    Welcome to Ozgrid.

    Have you looked at the ShowModal property of the Userform ?

    Excel Video Tutorials / Excel Dashboards Reports

  3. #3
    Join Date
    13th September 2003

    Re: Multiple Active Userforms

    hi GravityAB,

    welcome to Ozgrid.com

    u can hide one while using the other
    Private Sub CommandButton1_Click()
    End Sub
    hope this helps
    All you need to learn VBA is an internet connection and Ozgrid.com

  4. #4
    Join Date
    4th December 2005

    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.

    Excel Video Tutorials / Excel Dashboards Reports

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. UserForms with multiple monitors
    By BillV in forum Technical Issues Help
    Replies: 11
    Last Post: March 4th, 2015, 19:22
  2. Alternative To Multiple UserForms
    By Karebac in forum EXCEL HELP
    Replies: 6
    Last Post: May 23rd, 2007, 17:23
  3. Replies: 12
    Last Post: September 29th, 2006, 18:56
  4. Printing Multiple UserForms on One Page
    By russellgardham in forum EXCEL HELP
    Replies: 7
    Last Post: October 16th, 2005, 03:03
  5. connecting multiple userforms
    By tdsmith in forum EXCEL HELP
    Replies: 1
    Last Post: July 4th, 2004, 13:40


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts