+ Reply to Thread
Results 1 to 8 of 8

Multi UserForm Show, but need to display on the front from Base UserForm

  1. #1
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    251

    Post Multi UserForm Show, but need to display on the front from Base UserForm

    Hi All Good People,

    I have four UserForm. The UserForm1 as base or main control for others UserForm.
    I use "Modal False" for each UserForm, because I want to display of each UserForm if the CommandButton to calll UserForm will be pressed.
    And if the button "PIN" is pressed i.e. on UserForm2 (mean UserForm2 will be kept on displaying), then other UserForm (i.e. UserForm3) will be called to display, and the problem is the UserForm2 will be displaying under UserForm1.
    Another things, I want to make the CommandButton2 on the Userform2, Userform3 and Userform4 will be activated/visible for One Second if the mouse will be moving/passing through the Table1.
    Please find the file for reference.
    Thank you in advance for any helps.

    Iqballhud
    Attached Files Attached Files

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,411

    Re: Multi UserForm Show, but need to display on the front from Base UserForm

    It would help if you explained further what you are finally trying to achieve by this method - have you considered a simpler approach using a multipage on a single userform - this will contain all your code within one envelope making referencing easier.
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

  3. #3
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    251

    Re: Multi UserForm Show, but need to display on the front from Base UserForm

    Hi Torachan,

    I will not use the multipage for this scheme.
    It will use multiple UserForm's as on attached file example.
    The things is, if the "PIN" activated then the UserForm (2, 3 or 4) will will be displaying under UserForm1.

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,411

    Re: Multi UserForm Show, but need to display on the front from Base UserForm

    any closer to your request ?
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    251

    Re: Multi UserForm Show, but need to display on the front from Base UserForm

    Hi Torachan,
    Thank you so much for prompt response.
    The design and display like the file that I was attached on this thread. The sequence of display UserForm is OK, no need to modify.
    The problem is, if UserForm2 opened And PIN Activated, And if I will open Userform3 by click on CommandButton2, then the UserForm3 will be displaying and UserForm2 will be hided under UserForm1.

    What do I need is, the UserForm2 (with PIN activated) will be displaying above UserForm1 (NOT under/backward/below/hide from UserForm1) which the UserForm3 is opened.
    So both UserForms (UserForm2 (Pin Activated) and UserForm3) will be displaying together above UserForm1.

    So, what so ever the UserForm"X" with PIN activated, the display of UserForm"X" will remain above/forward on UserForm1.

    Your helps still far, but appreciated Sir.

  6. #6
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    251

    Re: Multi UserForm Show, but need to display on the front from Base UserForm

    hi,

    anybody which has an idea to show multiple userform, please.

  7. #7
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,411

    Re: Multi UserForm Show, but need to display on the front from Base UserForm

    any closer this time ?
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    11-17-2013
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    251

    Re: Multi UserForm Show, but need to display on the front from Base UserForm

    Hi Torachan,

    yes right as expected, the UserForm's remain displaying over base UserForm1.
    Thank you so much, Sir.

    Another thing for my second question, I need "Label1" to make visible for two seconds while mouse moving over "Label1" in UserForm2, UserForm3 and UserForm4.
    "Label1" properties is False for initial.
    File attached.

    Thanks in advance for your codes and helps.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] display/show and print a PDF file selected on a listbox on a UserForm
    By bluepomme in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 10-11-2018, 05:11 PM
  2. [SOLVED] Userform Launch - show userform when any cell in range on any worksheet is double clicked
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-27-2016, 03:38 AM
  3. Replies: 2
    Last Post: 05-24-2016, 05:27 AM
  4. Search db Capability for a userform with multi-field display
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2016, 12:09 AM
  5. Date picker UserForm to stay always in front of the main UserForm
    By Gabor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2014, 07:31 AM
  6. UserForm help - display list of open workbooks except workbook userform code is in
    By kensweep in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-09-2014, 12:26 PM
  7. userform is large.....how to use scrollbar of userform to show all of the userform
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2010, 04:11 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1