Microsoft Office Tutorials and References
In Depth Information
What Does a Dialog Sheet Look Like?
Dialog sheets are created on the fly, and then deleted automatically, which means the
workbook has less overhead without a UserForm hanging around for its next infrequent
Dialog sheets are fully supported in all versions of Excel up to and including Excel 2010,
having backwards compatibility with earlier versions of Excel.
Dialog sheets are a history lesson in the evolution of Excel, providing a sense as to what gave
rise to the modern-day UserForm.
Dialog sheets have the intangible “wow” factor; you can program and display a custom
UserForm-like dialog box without building a UserForm, with your users appreciating the
simple, straightforward design.
What does a dialog sheet look like?
When I use dialog sheets, only the dialog box (called the DialogFrame ) is seen by the user, not the
dialog sheet itself. If you’d like to see a dialog sheet, right-click any worksheet tab. From the
popup menu, select Insert, and on the General tab of the Insert dialog box, select MS Excel 5.0 Dialog.
Click OK and you’ll insert a dialog sheet that looks like Figure 25-1.
You can also insert a dialog sheet programmatically, by executing this code line
in the Immediate window: