+ Reply to Thread
Results 1 to 21 of 21

Allowing TopUserform to remain when selecting bottom Userform

  1. #1
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,116

    Allowing TopUserform to remain when selecting bottom Userform

    Hi Guys...Little advice here...Must be a way to make this happen...

    In the attached sample file...I want to do the following:
    On opening file...First Userform opens...I then want to click beverages or Snacks which allows for Second Userform to open...
    I then need to click the Qty Increase Alert button On the First Userform ... but need to have the second Userform remain open...
    Attached Files Attached Files
    Last edited by sintek; 04-01-2019 at 03:06 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,887

    Re: Allowing TopUserform to remain when selecting bottom Userform

    Hi, open the first userform Modal False and that you must not forget to close (unload) that form at the end.
    I'll download your file and see if I can implement if for you, but try the idea. works for me in other forms I use with similar contsruction
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,887

    Re: Allowing TopUserform to remain when selecting bottom Userform

    Well, you want to let us crack the vba or do you give us the pw?

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,116

    Re: Allowing TopUserform to remain when selecting bottom Userform

    Hallo Keebellah

    No passwords...

    Surely with The first Userform set to Modal False, The other will not be open as Modeless...


    EDIT...Aplologies, only just realized password was in place...See Post 1 ...New upload....
    Last edited by sintek; 04-01-2019 at 03:06 AM.

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,887

    Re: Allowing TopUserform to remain when selecting bottom Userform

    I thought as much
    Attached Images Attached Images

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,887

    Re: Allowing TopUserform to remain when selecting bottom Userform

    Still the same and I also notice (can't see it due to the VBA project being blcoked that you're probably using other references in your VBA,
    Probably a date picker, I won't work on tour file sinec I am not going to add datepicker controls (ocx modules) to my environment that makes the files very incompatible for sharing.
    Sorry for that, someone else will have to pick this up.
    Attached Images Attached Images

  7. #7
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,116

    Re: Allowing TopUserform to remain when selecting bottom Userform

    Yep...lol...

    As is one needs to click Qty button, then click a number from keypad, then click either Beverages | Meals and then select item which populates selected qty...

    I do not want to have the Qty button on the menu items menu which then has to open another keypad to enter qty...Just seems laborious...

  8. #8
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,116

    Re: Allowing TopUserform to remain when selecting bottom Userform

    Can comment out code and remove reference to Dtpicker...Not needed for this purpose...

  9. #9
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,887

    Re: Allowing TopUserform to remain when selecting bottom Userform

    I understand but then you'll have to account for that in your code.
    When coding you have to account for all possibilities.
    But, I cannot test because I cannot access the VBA project and remove the compile error due to your date picker (invalid)
    Attached Images Attached Images

  10. #10
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,887

    Re: Allowing TopUserform to remain when selecting bottom Userform

    Becasue of the invalid reference all format commands and more are invalid.
    No go without the VBA password.
    Sorry fro that

  11. #11
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,116

    Re: Allowing TopUserform to remain when selecting bottom Userform

    Password has been removed...is "sintek"...Thanks anyway...

  12. #12
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,887

    Re: Allowing TopUserform to remain when selecting bottom Userform

    Got it, but after that and I understand it, you've remove a large number of userforms, macro's that keep throwing errors because they're not present.
    But, what is the issue you really want solved, not that I can at least access the file and edit the vba code, mind explaining it again?
    Name the steps you're taking and what really is the solution you're looking for?
    I must honestly say that I'm not happy with partial working vba code since you cannot foresee issues, but, okay, I'll try.

  13. #13
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,116

    Re: Allowing TopUserform to remain when selecting bottom Userform

    Thanks for your effort...Much appreciated...Yes removed 50 + userforms...and modules...
    Initially the system allowed for When opening either Beverages or Meal menu to click the item each time to increase quantities...This still works...

    I am, however, trying to incorporate an easier method to increase quantities without adding additional userforms...

    As is currently...One needs to click Qty button, then click a number from keypad, then click either Beverages | Meals and then select item which populates selected qty...

    I want to click either Beverages | Meals then click qty and have the Beverages |Meals userform remain open...

  14. #14
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,887

    Re: Allowing TopUserform to remain when selecting bottom Userform

    BTW changing the modal status as I said seems to work.
    The code lines for invalid macros and other I commented out all start with '* so they'll be easy to find
    I've attached the file
    Attached Files Attached Files

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

    Re: Allowing TopUserform to remain when selecting bottom Userform

    Put the lot on a massive multi-page.
    Problem solved

  16. #16
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,887

    Re: Allowing TopUserform to remain when selecting bottom Userform

    And is it still manageable?

  17. #17
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,116

    Re: Allowing TopUserform to remain when selecting bottom Userform

    I think I have not explained correctly...
    When clicking Image 1.png

    Menu pops up over Main menu

    Image 2.png

    When I then press Image 3.png

    I need the top menu to remain...



    Both are visible but because the one is overlapping the other...Top userform loses focus when I click on bottom userform
    Last edited by sintek; 04-01-2019 at 05:23 AM.

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

    Re: Allowing TopUserform to remain when selecting bottom Userform

    Just passing comment after similar attempts a couple of years ago.
    In the end gave up and resorted to multi-pages nested on multi-pages.
    Coding then became a lot easier although very repetitive but stable.
    Good luck I would like to understand where I failed.

    Capturex.JPG

    Capturez.JPG

  19. #19
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,887

    Re: Allowing TopUserform to remain when selecting bottom Userform

    Okay, yeah, I've run into issues like that, and like @torachan mentions the multi page is a good workaround or else depending on you screen size place the extra userforms at a specific position

  20. #20
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,887

    Re: Allowing TopUserform to remain when selecting bottom Userform

    If your screen width allows (mine is 22") then this should work too
    I added a routine to distribute the commandbuttons 4 columns by 8 rows
    The bitmap you use as background of the two extra forms had to be removed and I placed a bitmap in each button. Attached too, named BACKP.gif
    Attached Images Attached Images
    Attached Files Attached Files

  21. #21
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,116

    Re: Allowing TopUserform to remain when selecting bottom Userform

    Hi Keebellah

    Thanks for the advice...I realize that overlapping userform's cannot both be set to focus so the multi page is an option or just a redesign to incorporate all menus on Main Userform

    I had individual images as command buttons, however, the transition was too slow so I incorporated one image which cut down transition time by 1.5 seconds...

    Well, I guess this one is for the archives...Tx again all

    Will mark as solved so no more time is used by other memebers...
    Last edited by sintek; 04-01-2019 at 02:38 PM.

+ 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. Selecting top and bottom from a dynamic table
    By mcp77 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-27-2018, 01:12 PM
  2. Allowing multiple users to use a UserForm
    By joni_depp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2017, 01:40 PM
  3. Userform updated listbox and remain highlight at the last update entry
    By carlrubber in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2017, 12:59 PM
  4. Allowing a text box in a data entry Form to remain empty
    By Drakanish in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2016, 12:17 PM
  5. Call userform 1 from userform 2 allowing to open workbook 1 clicking button 1
    By FMontana in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2015, 02:29 AM
  6. [SOLVED] Trying to get a value to remain copy into a cell and remain the same when condition met
    By shadowlost in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-24-2013, 11:47 AM
  7. Selecting the bottom row via macro recorder
    By Crescent_Credit in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-10-2012, 02:52 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