Microsoft Office Tutorials and References
In Depth Information
Part 5: Manipulating Excel Objects
Creating Advanced User Forms
A Frame control surrounds a collection of label and text box controls.
In the final step of the wizard, shown in Figure 20-11, yet another Frame control provides a
container for a text box control called Review . This text box has the MultiLine property set to
Tr ue and the BackColor property set to &H8000000F, which is the same color as the background
of the form. This indicates to the user that the data contained in the text box can’t be changed.
A summary of the options selected is displayed in the Review text box.