Excel 2007 run-time error 424

Posted on 2011-04-20
Medium Priority
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
  • 2
LVL 15

Accepted Solution

greyknight17 earned 200 total points
ID: 35437391
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

ID: 35437509
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

ID: 35446914
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

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

Thank you, V

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

864 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