+ Reply to Thread
Results 1 to 4 of 4

Alt+Tab not working when an userform is opened

  1. #1
    Forum Contributor
    Join Date
    04-21-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    112

    Alt+Tab not working when an userform is opened

    Dear Experts,

    While using an userform, is it not possible to swap to other files in the window?
    I.e Alt+tab function is not working while an userform is opened.

    Is there any solution to avoid this problem???

    Regards,
    Alex
    Last edited by sivdin; 04-28-2009 at 06:35 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Alt+Tab not working when an userform is opened

    You would need to show the userform modeless.
    Either by setting the Modal property to False or using the parameter of the Show method.

    Please Login or Register  to view this content.
    The Alt+Tab will not take you off the userform, but you can click the workbook and then use Alt+Tab
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Alt+Tab not working when an userform is opened

    You need to make the userform modeless. In the UserForm's properties change the showModal property to False. You can set it in the initialize event if you want
    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Contributor
    Join Date
    04-21-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    112

    Re: Alt+Tab not working when an userform is opened

    Thank you everybody

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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