Excel 2007 run-time error 424

Posted on 2011-04-20
Last Modified: 2012-05-11
Hi Experts - a user has tried my file with macros with user forms and gets run-time error 424.
I cannot replicate it on my machine, I tried on 2003 and 2007 with no problems. Any idea what the issue could be, Service Pack, Add-ins, etc?

Cheers, V
Question by:NewToVBA
    LVL 15

    Accepted Solution

    Did you create this in Excel 2007? Since macros and VBA is involved, did you add any additional references in this Excel file? It might be missing some files that you may have on your version of Excel but not on the end user's computer. To check this, open up your worksheet and hold down ALT and hit the F11 key to bring up the Microsoft Visual Basic Editor. Go to Tools > References and see what you have checked there. By default, only a few should be checked. You can check this against what the other user has and see if it could just be missing some reference DLL file.

    Author Comment

    Excellent, will have it verified on the user's machine.
    I use ver 2003 and 2007, the macros were built in 2007 and tested in both versions.
    I got those optins chosen.

    Cheers, V
    LVL 10

    Expert Comment

    Unfortunately, I don't have excel 2003 any more so I can't test my question myself...

    Is the user on office 2003, and if so, do they actually have the "Microsoft * 12.0 Object Library" references on their machine?

    You may need to change some of your code to use late binding...


    Author Closing Comment

    The user has a questionable  Excel install; tests done by other folks using 2003 or 2007 revealed no issues.

    Thank you, V

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Suggested Solutions

    If your system is showing symptoms of browser hijacks or 'google search redirects' check out my other article ( first and run the tool TDSSKiller ( to get rid of the infection. Once done, and if the …
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now