Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Multiple Active Userforms

  1. #1
    Join Date
    4th December 2005
    Posts
    13

    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
    Location
    Cyprus
    Posts
    2,252

    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
    Location
    Singapore
    Posts
    1,236

    Re: Multiple Active Userforms

    hi GravityAB,

    welcome to Ozgrid.com

    u can hide one while using the other
    VB:
    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

  4. #4
    Join Date
    4th December 2005
    Posts
    13

    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: 10
    Last Post: 2 Weeks Ago, 08:14
  2. Alternative To Multiple UserForms
    By Karebac in forum EXCEL HELP
    Replies: 6
    Last Post: May 23rd, 2007, 16:23
  3. Replies: 12
    Last Post: September 29th, 2006, 17:56
  4. Printing Multiple UserForms on One Page
    By russellgardham in forum EXCEL HELP
    Replies: 7
    Last Post: October 16th, 2005, 02:03
  5. connecting multiple userforms
    By tdsmith in forum EXCEL HELP
    Replies: 1
    Last Post: July 4th, 2004, 12:40

Bookmarks

Posting Permissions

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