+ Reply to Thread
Results 1 to 3 of 3

How do I check if a user form is loaded?

  1. 05-09-2021, 03:07 PM #1
    IZoomU
    IZoomU is offline
    Registered User
    Join Date
    10-17-2013
    Location
    Houston, Tx
    MS-Off Ver
    Excel 2013
    Posts
    8

    How do I check if a user form is loaded?

    I want to check if my user form (auditDrivers) is loaded. If it is loaded I want to unload it.
    Reply With QuoteRegister To Reply
  2. 05-09-2021, 04:21 PM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How do I check if a user form is loaded?

    Why not just code the Unload instruction. If its open or hidden it will unload, if it's not loaded the instruction will be ignored.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  3. 05-10-2021, 08:56 AM #3
    IZoomU
    IZoomU is offline
    Registered User
    Join Date
    10-17-2013
    Location
    Houston, Tx
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: How do I check if a user form is loaded?

    It would give an error when I did that. I just recoded around it so I wouldn't have to do the unload
    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)

Similar Threads

  1. Test if a user form is loaded
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2017, 12:37 PM
  2. [SOLVED] VBA UserForm.Value Check If User Form Buttons checked Not Working. Check Button on Open.
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-11-2016, 05:55 PM
  3. User Form to check data before closing form
    By CityMPLSEmpolyee in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-15-2012, 12:42 PM
  4. User Form to save Form entries & check for duplicates
    By KPK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2010, 05:44 AM
  5. Checking for User Form loaded
    By scottintexas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2008, 02:58 AM
  6. Event when a user form is loaded
    By shashi1515 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2006, 04:34 PM
  7. How check if form is loaded?
    By Jos Vens in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2005, 09:06 AM

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