+ Reply to Thread
Results 1 to 3 of 3

UserForm display issue on multiple screens (SOLVED)

  1. #1
    Registered User
    Join Date
    12-12-2019
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    5

    UserForm display issue on multiple screens (SOLVED)

    Hi all,

    As title describes - I've got an issue where the UserForms don't open where I would like them to on the first time of asking (where users have multiple screens). However, they DO work after exiting the form and running the same code again.

    Any ideas on how to fix this? Code I'm using is below:

    Please Login or Register  to view this content.
    Last edited by OhItsTroy; 04-29-2021 at 11:15 AM. Reason: Solved

  2. #2
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    365 32bit Win
    Posts
    1,935

    Re: UserForm display issue on multiple screens

    If the form is Modal, i.e. you can't interact with anything else while the form is showing, then the code execution will stop after the ".show" until you close or hide the form, so the position never gets executed until it's too late which is why it doesn't work the first time.
    The second time, since the position has been set from the first time, it'll work correctly.

    I think you just need to set the position before showing it.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-12-2019
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: UserForm display issue on multiple screens

    This has solved the issue - thank you! It seems so obvious now I know what the issue is!

+ 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] Issue with numlock activating when switching screens between excel and software Win10
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2019, 09:51 AM
  2. Search and display results in userform Issue. Results are incorrect
    By olypro in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-07-2019, 10:16 AM
  3. Replies: 0
    Last Post: 07-04-2016, 06:27 AM
  4. Open multiple workbooks and display on two screens
    By questionguy in forum Excel General
    Replies: 1
    Last Post: 02-02-2013, 07:27 PM
  5. Replies: 0
    Last Post: 08-07-2012, 07:24 AM
  6. Multiple split screens
    By Andy Ringsmuth in forum Excel General
    Replies: 2
    Last Post: 02-01-2006, 06:10 PM
  7. Replies: 7
    Last Post: 09-15-2005, 05:05 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