+ Reply to Thread
Results 1 to 4 of 4

Must close or hide topmost modal form first

  1. #1
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Must close or hide topmost modal form first

    Hi,
    I'm having problems with a couple userforms that I have included in the attached workbook. Could someone take a look and advise what is going wrong.

    I placed some stops in and step through and it seems to work fine, however when I run the code I get an runtime error.

    "Must close or hide topmost modal form first"

    Please Advise:

    Thank You, Mike
    Attached Files Attached Files

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Must close or hide topmost modal form first

    I think I may have helped. Let me know
    Attached Files Attached Files
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  3. #3
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Re: Must close or hide topmost modal form first

    Thanks Mordred... Still getting the same error after I scan the upc. It looks like when the lot number userform comes up is when the error shows up. But not sure just yet. It's hard to tell because it works when I step through the script?

    Any other thoughts?

    Thank You, Mike

  4. #4
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Re: Must close or hide topmost modal form first

    Still cant get this working, I have redone the workbook to include only one user-form and although I don't get the error any longer it skips through all the code most of the time. This must be related to time.

    Does anyone have any suggestions?

    Here is a copy of what I am working with now.

    Thank You, Mike
    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)

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