+ Reply to Thread
Results 1 to 3 of 3

Run-Time error '424' on form initializing

  1. #1
    Valued Forum Contributor scaffdog845's Avatar
    Join Date
    02-01-2008
    Location
    Aston, PA. USA.
    MS-Off Ver
    Microsoft 365
    Posts
    375

    Run-Time error '424' on form initializing

    Morning all,

    I tried to create a simple VBA form to assure users have a few key cell entries done before generating a weekly budget report. When I click on the User Form Button to initialize the form I am getting a Run-Time error '424' Object required error message.

    Any idea what may be missing or incorrect to cause this message???

    Thanks!
    Attached Files Attached Files
    Last edited by scaffdog845; 12-29-2009 at 11:25 AM. Reason: Solved
    Click here to read the Forum Rules
    Whatever it is in life you decide to go after, go after with great ferocity.

  2. #2
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    Re: Run-Time error '424' on form initializing

    TextMonth and TextWorkDay are the textboxes.

    You init with:
    Please Login or Register  to view this content.
    These do not exits and by default a textbox is "".

    I would introduce a combobox for the working day
    Please Login or Register  to view this content.
    Last edited by rwgrietveld; 12-29-2009 at 10:18 AM.
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  3. #3
    Valued Forum Contributor scaffdog845's Avatar
    Join Date
    02-01-2008
    Location
    Aston, PA. USA.
    MS-Off Ver
    Microsoft 365
    Posts
    375

    Re: Run-Time error '424' on form initializing

    Thanks Ricardo,

    Adjusted the references and all was good. Now I'm going to go out and catch a chill on in this blistery December wind. LOL.

    Thanks

+ 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