Results 1 to 3 of 3

424 Object required error when calling a UserForm from another

Threaded View

  1. #1
    Registered User
    Join Date
    11-12-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    48

    424 Object required error when calling a UserForm from another

    I have a book with a few UserForms... Wizard1, Wizard2, Wizard3, etc

    From any of the forms, I can call any Wizard except Wizard 6. If I have:

    Wizard6.Show
    An error pops up and says Runtime Error 424 Object Required.

    There is clearly a Wizard6. The same code with a Wizard1.Show or a Wizard2.Show works perfectly. Just not Wizard6.Show.

    If I have to provide more info, I'd prefer to keep it in private so the whole book isn't exposed to the internet.

    NOTE: Disregard.. Found the error... Wizard6 was referencing Wiard7, not Wizard7 and that was the problem...
    Last edited by rybussell; 10-04-2013 at 01:10 PM. Reason: Found it

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Object required when Calling a procedure from Useform?
    By lexusap in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2013, 09:41 PM
  2. [SOLVED] Object Required Error
    By Steve0492 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-14-2012, 06:36 PM
  3. Name.Object (Error Object Required)
    By dssrun209 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2010, 01:38 PM
  4. Compile error : object required in userform
    By asha3010 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2010, 04:08 AM
  5. Error 424 Object Required Error when Using AddItem to ListBox Generated in Code
    By jclark419 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2010, 12:47 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