Your job, if you choose to accept it, is to add some controls to this UserForm.You use the tools in the Toolbox to add controls to your UserForm.
![]() If, for some reason, the Toolbox doesnt appear when you activate your UserForm, choose View Toolbox. After you add a control, you can move and resize it by using standard techniques. In addition, the UserForm itself has its own set of properties. You can change these properties with the aptly named Properties window. This shows the Properties window when a CommandButton control is selected. If you select a different control, the properties change to those appropriate for that control. To hide the Properties window and get it out of the way, click the Close button in its title bar. To change a property using the Properties window, follow these steps. If youre viewing code, double-click the UserForm name in the Project window to return to the UserForm. Most of the time, you wont have any more code in the procedure. As you later see, you put your event-handler procedures in the Code window for the UserForm. These procedures kick in when the user works with the controls on the UserForm. For example, if you add a CheckBox control to a UserForm named UserForm1, the CheckBox control is named CheckBox1 by default. You can use the Properties box to make this control appear with a check mark. ![]() The following statement executes a macro named PrintReport if the check box (named CheckBox1) is checked. He has been named a Microsoft MVP for his ongoing contributions to the Excel community.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |