+ Reply to Thread
Results 1 to 4 of 4

UserForm not recognized as object despite declaration

  1. #1
    Registered User
    Join Date
    04-08-2020
    Location
    Perth Australia
    MS-Off Ver
    365
    Posts
    1

    UserForm not recognized as object despite declaration

    Hello

    Can anyone assist me with this.

    I hve created 3 UserForms (MemberInfo, TrainingRecords and TrainingScheduler) with the following
    code to display each:

    Please Login or Register  to view this content.
    Teh first code generates a 424 runtime error "Object Required". the second and third code work perfectly from either inside the code or when initiated via command button.

    Does anyone have any suggestions regarding what i am missing in this?

    Thanks for any assistance.

    regards
    greg
    Last edited by Pepe Le Mokko; 04-08-2020 at 07:50 AM. Reason: Code tags.....

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: UserForm not recognized as object despite declaration

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I did it for you this time. Please read forum rules. Thanks

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

    Re: UserForm not recognized as object despite declaration

    We would need to see the code in the Initialize event of the userform.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: UserForm not recognized as object despite declaration

    FYI, your declarations are pointless.
    Rory

+ 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. 424 object required in userform
    By SPARKY347 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2016, 10:50 AM
  2. [SOLVED] Userform not recognized??
    By mariec_06 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2016, 06:50 AM
  3. [SOLVED] UserForm not recognized
    By j_Southern in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-11-2015, 06:33 AM
  4. [SOLVED] Userform TextBox Multiline Declaration
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-10-2014, 05:39 PM
  5. OLE Object Array Declaration Syntax Problem
    By beat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2013, 08:11 AM
  6. ActiveDocument object not recognized
    By LauraBorealis in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-14-2006, 04:55 PM
  7. Public Declaration of a Worksheet Object?
    By Mech_Colin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2005, 01:03 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