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

ID: Q213255

The information in this article applies to:

Microsoft Excel 2000

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 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

Right-click a sheet tab in your workbook.

On the shortcut menu, click Insert.

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/overview/overview.asp

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 UserForm Object, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type UserForm Object, UserForms Collection in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: vba XL2000

Keywords : xlvbainfo xlvbmigrate
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbhowto