On clicking the UserForm in the Project Explorer, you can view and change the properties of the UserForm in the Properties Window. If the Properties Window is not visible, click on View -> Properties Window. Controls are added in the UserForm from the Toolbox, in the Visual Basic Editor. Toolbox consists of Controls required for developing a VBA Application. If the Toolbox does not appear by itself, first check if it is not hidden by clicking on the UserForm (or double-clicking on UserForm name in Project Window), else click View -> Toolbox (while UserForm is selected) Open Visual Basic Editor (VBE) in Excel by pressing ALT+F11 in an open workbook, or right-click on the worksheet tab at the bottom, and select View Code.Ĭlick on View -> Project Explorer if the Project window is not visible.Ĭreate a Userform in the Project window of the Visual Basic Editor by clicking Insert -> UserForm, and your screen should appear as shown in Image 1. Using ActiveX Controls on a Worksheet have been illustrated in detail, in the separate section of " Excel VBA: ActiveX Controls, Form Controls & AutoShapes on a Worksheet". By itself, a UserForm will not be of much use unless controls are added to it which are the actual user-interactive objects.ĪctiveX controls can be used with VBA code or without, either directly on worksheets, while some can be used only on VBA UserForms. UserForm acts as a container in which you add multiple ActiveX controls, each of which has a specific use and associated properties. It enables a user to interact, using a Form, in an organized and logical manner, to make data entry or for data retrieval with an Excel worksheet or to run a VBA application. UserForm is a customized user interface, developed in VBA. Note: In below given examples, vba codes are required to be entered in the Code Module of the UserForm, unless specified otherwise. UserForms in Excel VBA - UserForm Basics Add Controls dynamically at run-time using the Add Method UserForm Controls (A Snapshot)
0 kommentar(er)
