Microsoft Office Tutorials and References
In Depth Information
What Does a Dialog Sheet Look Like?
One look at a dialog sheet and you can see the reason to avoid showing it; they are not
pleasantlooking objects. However, what the dialog sheet lacks in attractiveness is compensated for by its ease
of integration with Excel due to its use of Forms controls, to help make custom dialog boxes a
valuable part of your VBA programming skill set.
A downside to dialog sheets is the volume of code they require for being
produced, designed, and discarded. The amount of code can be visually daunting
at first, but please do not get discouraged. You have already seen most of the
kind of code that’s involved. The only difference is, unlike a UserForm where
you manually draw controls onto the form and then assign code to them, with
dialog sheets you are positioning the controls programmatically and assigning
their associated code all at the same time. There are notes at each step to explain
what’s going on.
You might be surprised at what you can do with dialog sheets. They can produce customized dialog
boxes that resemble UserForms in their basic functionality, but they are actually dialog boxes within
which you place Forms controls such as Buttons, DropDowns, Option Buttons, Labels, and Edit
Boxes. Figure 25-2 shows examples of a few custom dialog boxes that I created using dialog sheets.