Microsoft KB Archive/136522

= Showing xlDialogFormatChart Causes Run-Time Error =

Article ID: 136522

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0c
 * Microsoft Excel 5.0 Standard Edition

-



This article was previously published under Q136522





SYMPTOMS
When you use the following line of code in a Visual Basic, Applications Edition, procedure Application.Dialogs(xlDialogFormatChart).Show you will receive the following error message:

Run-time error 1004: Show method of Dialog class failed



CAUSE
xlDialogFormatChart is the equivalent of clicking Options in the Format Chart Type dialog box. The Application.Dialog show method is the Microsoft Excel 5.0 Visual Basic for Applications equivalent to the Microsoft Excel 4.0 macro (XLM) command FORMAT.CHART?(1). If the XLM command requires one or more arguments, then so does the Visual Basic for Applications method.



RESOLUTION
The following Visual Basic for Applications code produces the results as intended by using the Application.Dialogs(xlDialogFormatChart).Show.

NOTE: This code assumes that you have an embedded chart named "Chart 1" on a worksheet.

Microsoft provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. This Visual Basic procedure is provided 'as is' and Microsoft does not guarantee that it can be used in all situations. Microsoft does not support modifications of this procedure to suit customer requirements for a particular purpose. Sub FormatGroup 'Select the actual chart. ActiveSheet.DrawingObjects("Chart 1").Select 'Activate the chart. ActiveSheet.ChartObjects("Chart 1").Activate 'Show the dialog box Application.Dialogs(xlDialogFormatChart).Show 1 End Sub



MORE INFORMATION
The Application.Dialog Show method follows the interactive XLM command (in this case =FORMAT.CHART?(1)). If the XLM command requires one or more arguments, then so does the Visual Basic for Applications method.

For more information about "Built-In Dialog Box Argument Lists," click the Index tab in Help, type the following text

Built-In Dialog

and then double-click the selected text to go to the "Built-In Dialog Box Argument Lists" topic.

