What is Runtime Error 424?

Run-time Error 424: Object Required error usually occurs when an application is unable to carry out an operation due to an unexpected programming unforeseen error. Discussed here are a few examples of this error.

The following error message may be displayed when you try to run the Microsoft Office Chart Wizard in Microsoft Access 2000 on a data access page:

Run-time error '424': Object required

Cause of the Error

This error occurs when you attempt to insert the Office Chart on a data access page when Internet Explorer 6.0 is installed on your computer.

Example

The error will occur when you try to do the following on a computer with Internet Explorer 6.0:

  1. In Microsoft Access 2000, you open Northwind.mdb-which is a sample database.
  2. In the displayed Database window, you select Pages located under Objects and then select New.
  3. In the New Data Access Page box that is displayed, you select New, and then click the OK button.
  4. Next, open the Insert menu, select Office Chart.
  5. In the wizard, select Column located under Chart Type and then you click the Next button.
  6. Select Sales by Category in the Available Database Tables list, and then click Next button.
  7. Click the Next button.
  8. Select CategoryID in the Series names list.
  9. Select ProductSales in the Values list.
  10. Click Finish.

The runtime error 424 will be displayed on the screen.

Solution

To resolve this issue, you can workaround the problem by using one of the following methods:

  • Use a computer that does not have Internet Explorer 6.0 on it.
  • Choose Cancel to exit the Microsoft Office Chart Wizard that displays automatically when you try to insert the Office Chart. Next, create your chart without using the Wizard. To make changes, right-click the chart and the select Property Toolbox.

The following error message is displayed when you attempt to use the Shapes property or ShapeRanges property of Visual Basic for Applications in a Microsoft WordMail message:

Run-time Error 424: Object required

Scenario in Which the Error Is Displayed

  1. If you have Microsoft Outlook 2000 running on your computer and you:
    • Select the Use Microsoft Word to edit e-mail messages option
    • Select the message editor option as Microsoft Outlook Rich Text
  2. Now, you open an existing message or create a new message and then run a Visual Basic command that needs to access the Shapes or the ShapeRanges collection and then you close this message.
  3. Example of the Visual Basic command: Msgbox ActiveDocument.Shapes.Count

  4. Next, you again open an existing message or create a new message and then run a Visual Basic command that needs to access the Shapes or the ShapeRanges collection and then you close this message.
  5. When you do this the run time error message is displayed.

    Solution

    To resolve this problem, you need to work around the problem by setting HTML as the format for editing the message. You can do so by performing the following steps:

  6. In the Microsoft Outlook 2000 window, open the Tools menu, and then select Options.
  7. Next, on the Mail Format tab in the Send in this message format list select the message format you would like to use.
  8. Click OK.