+ Reply to Thread
Results 1 to 6 of 6

Error 424 object required

  1. 07-07-2008, 06:19 AM #1
    Ranpak
    Ranpak is offline
    Registered User
    Join Date
    07-07-2008
    Location
    Netherlands
    Posts
    13

    Exclamation Error 424 object required

    I made a simple form in Visual Basic. After starting I get an error:Run-time error 424 object required. A downloaded example works fine. Debugging show:

    Please Login or Register  to view this content.
    Can anybody help?
    Last edited by mudraker; 07-07-2008 at 07:52 AM.
    Reply With QuoteRegister To Reply
  2. 07-07-2008, 07:51 AM #2
    mudraker
    mudraker is offline
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    Ranpak

    Welcome to Exceltip forum

    Please take a couple of minutes and read the Forum Rules (rule 3)

    As there is a time limit on editing your posting I have wrapped your VBA code for you
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.
    Reply With QuoteRegister To Reply
  3. 07-07-2008, 08:06 AM #3
    dominicb
    dominicb is offline
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good morning Ranpak

    Some (but not all) errors generated within userforms helpfully point out the line of code that opens the userform, rather than the actual line that the error lies within. That is what has happened in this instance.

    You would be better off either posting your userform code (remeber to use code tags this time ) or upload your workbook for someone to take a look at.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.
    Reply With QuoteRegister To Reply
  4. 07-07-2008, 08:30 AM #4
    Ranpak
    Ranpak is offline
    Registered User
    Join Date
    07-07-2008
    Location
    Netherlands
    Posts
    13
    I'm inexperienced forum user. Thanks for your remarks.

    I will include the complete code with [code]


    Quote Originally Posted by mudraker
    Ranpak

    Welcome to Exceltip forum

    Please take a couple of minutes and read the Forum Rules (rule 3)

    As there is a time limit on editing your posting I have wrapped your VBA code for you
    Reply With QuoteRegister To Reply
  5. 07-07-2008, 09:13 AM #5
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Check the UserForm_Initialize and/or UserForm_Activate code, the error is probably there.
    Hope that helps.

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

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
  6. 07-07-2008, 09:56 AM #6
    Ranpak
    Ranpak is offline
    Registered User
    Join Date
    07-07-2008
    Location
    Netherlands
    Posts
    13
    Quote Originally Posted by royUK
    Check the UserForm_Initialize and/or UserForm_Activate code, the error is probably there.

    PROBLEM FOUND! I did not re-NAME the TEXTBOX. The tutorials a followed did not mention to do this

    Thanks RoyUK.

    Cheers, Ranpak
    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)

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