Microsoft Office Tutorials and References
In Depth Information
19.6.2 Designing the Dialog
As a bonus, we also include a feature that enlarges the current selection by including the entire
row (or column) containing each selected cell. For instance, applying this to the worksheet in
Figure 19-28 will select rows 12, 16, 18, 23, and 25.
19.6.2 Designing the Dialog
Now that our game plan has be mapped out, we can design and construct the dialog. The final
product is shown in Figure 19-30 . It is a UserForm called dlgSelectSpecial , and its Caption
property should be set to "Select Special."
Figure 19-30. Select Special dialog
As to the operation of the utility, the user will first select one of the mutually exclusive options
under Select Cells If. The actual search range is displayed at the bottom of the dialog.
Here are some of the highlights of this form design. We suggest you read on before creating your
own form.
19.6.2.1 The Frame control
A frame control is used to group other controls. This is often done just to group controls that have
a similar purpose. However, in the case of option buttons, it has a more profound effect. Namely,
the option buttons in a single frame are mutually exclusive , which means that if the user selects
one option button, the others are automatically unselected.
To ensure that the option buttons are really inside the frame and not merely on top of it, make sure
the frame is selected when you click on the OptionButton control icon in the Toolbox. Then create
the option button inside the frame. Also, if you decide to copy and paste the additional option
buttons, make sure that the frame is selected when you choose the Paste command.
19.6.2.2 Control names
The control names were chosen to conform to my naming convention. Their names are:
fraType (frame)
optDifferent
optSame
 
Search JabSto ::




Custom Search