(view different TabStrip sets of information for (runs CommandButton related controls) subs) (displays a picture) Image (presents multiple MultiPage screens of info as a (increments and SpinButton single set) decrements numbers) (returns or sets the value of ScrollBar another control based on the position of the scroll box) (similar to a TextBox control, but used RefEdit specifically to let the user select a worksheet range) Note: Many other controls can be added to the Toolbox. To see them, right-click on any of the controls in the tool box, and select Controls…. A →Additional useful one is Microsoft Date and Time Picker Control 6.0 (SP6), which lets you put a date box on the form where the user selects the date from a calendar. Adding Controls to the User Form To any control, click it in the Toolbox add and then drag it onto the form. a control by selecting it and then Size clicking and dragging one of the handles on the outside. a control by clicking it and dragging. Move
TabStrip (view different sets of information for CommandButton (runs related controls) subs) Image (displays a picture) MultiPage (presents multiple screens of info as a SpinButton (increments and single set) decrements numbers) ScrollBar (returns or sets the value of another control based on the position of the scroll box) RefEdit (similar to a TextBox control, but used specifically to let the user select a worksheet range) Note: Many other controls can be added to the Toolbox. To see them, right-click on any of the controls in the tool box, and select →Additional Controls…. A useful one is Microsoft Date and Time Picker Control 6.0 (SP6), which lets you put a date box on the form where the user selects the date from a calendar. Adding Controls to the User Form To add any control, click it in the Toolbox and then drag it onto the form. Size a control by selecting it and then clicking and dragging one of the handles on the outside. Move a control by clicking it and dragging.
MgtOp-470-Topic-3-Set-4.docx