+ Reply to Thread
Results 1 to 2 of 2

Open userforms and close them in reverse order.

  1. 03-25-2013, 06:45 PM #1
    Francisco Sousa
    Francisco Sousa is offline
    Registered User
    Join Date
    08-06-2010
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    35

    Open userforms and close them in reverse order.

    Hello,

    I have three userforms, frmAAA, frmBBB and frmCCC, but I would like to open and close them in reverse order: frmCCC, frmBBB and frmAAA.

    My problem is that when you open them in reverse order, the other userforms are hidden and only appear when the others are closed.

    Any help would be great.


    Regards

    FS
    Last edited by Francisco Sousa; 03-25-2013 at 07:26 PM.
    Reply With QuoteRegister To Reply
  2. 03-25-2013, 07:14 PM #2
    Francisco Sousa
    Francisco Sousa is offline
    Registered User
    Join Date
    08-06-2010
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: Open userforms and close them in reverse order.

    I found myself, just put them in the following order;

    frmAAA.Hide
    frmBBB. Hide
    frmCCC.Hide

    Simply put vbModeless at the end.

    frmCCC.Show vbModeless
    frmAAA.Show vbModeless
    frmBBB. Show vbModeless

    Regards
    FS
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1