Microsoft KB Archive/154930

= How to Add MS Excel 5.0 Dialog Sheet to a Workbook =

Article ID: 154930

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q154930





SUMMARY
This article describes how to add a Microsoft Excel version 5.0 Dialog sheet to your workbook.



MORE INFORMATION
Microsoft Excel version 5.0 dialog sheets have been replaced by UserForms. It is recommended that you use forms rather than Microsoft Excel version 5.0 dialogs in your custom application. UserForms have more programmable features and enable you to use ActiveX controls (.ocx files). Although the use of UserForms is recommended over the use of Microsoft Excel version 5.0 dialog sheets, dialog sheets can still be used for backward compatibility with earlier versions of Microsoft Excel. You can use either of the following methods to insert a Microsoft Excel version 5.0 dialog sheet into your workbook.

Method 1: Insert a Dialog Sheet Through the User Interface

 * 1) Right-click or CONTROL-click a sheet tab in your workbook.
 * 2) On the shortcut menu, click Insert.
 * 3) Click MS Excel 5.0 Dialog and click OK.

Method 2: Insert a Dialog Sheet Through Code
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. You can insert a dialog sheet in the active workbook by running a macro, such as the following: Sub InsertDialog ActiveWorkbook.Sheets.Add Type:=xlDialogSheet End Sub

