Microsoft Office Tutorials and References
In Depth Information
Chapter 13: Introducing UserForms
13
Introducing UserForms
In This Chapter
Creating, showing, and unloading UserForms
Exploring the UserForm controls available to you
Setting the properties of UserForm controls
Controlling UserForms with VBA procedures
Creating a UserForm
Introducing the types of events relevant to UserForms and controls
Customizing your control Toolbox
Going over a handy checklist for creating UserForms
How Excel Handles Custom Dialog Boxes
Excel makes creating custom dialog boxes for your applications relatively easy. In fact, you can
duplicate the look and feel of many of Excel’s dialog boxes.
Excel developers have always had the ability to create custom dialog boxes for their applications.
Beginning with Excel 97, things changed substantially — UserForms replaced the clunky old
dialog sheets. UserForms are much easier to work with, and they offer many additional capabilities.
Even though UserForms haven’t been upgraded over the years, you’ll find that this feature works
well and is very flexible.
A custom dialog box is created on a UserForm, and you access UserForms in the Visual Basic
Editor (VBE).
 
Search JabSto ::




Custom Search