XL2000: How to Add a Microsoft Excel 5.0 Dialog Sheet to a Workbook (213255)

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 Excel version 5.0 dialog sheets, dialog sheets can still be used for backward compatibility with earlier versions of Excel.

You can use either of the following methods to insert an Excel version 5.0 dialog sheet into your workbook.

Method 1: Insert a Dialog Sheet Through the User Interface

1. Right-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