XL: How to Add MS Excel 5.0 Dialog Sheet to a Workbook

ID: Q154930

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Excel 98 Macintosh Edition

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, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals 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 needs. If you have limited programming experience, you may want to contact the Microsoft fee-based consulting line at (800) 936-5200. For more information about the support options available from Microsoft, please see the following page on the World Wide Web:

   http://www.microsoft.com/support/supportnet/refguide/

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

REFERENCES

For more information about the "UserForm Object," click the Index tab in Visual Basic Reference Help, type the following text

   UserForm

and then double-click the selected text to go to the "UserForm Object, UserForms Collection" topic.

Additional query words: vba

Keywords          : kbprg kbdta kbdtacode KbVBA 
Version           : WINDOWS:97; MACINTOSH:98
Platform          : MACINTOSH WINDOWS
Issue type        : kbhowto

Last Reviewed: May 18, 1999