Also referred to as Radio Button.Įxecutes one action when clicked first and a different action on the second click. Used to make one selection from multiple options. Used to select mutually exclusive options viz. Is a list of items from which a user can select, but does not allow user to enter his own item.Ī CheckBox whether selected or not, indicates True or False values. ComboBox is a combination of TextBox and ListBox. Is a list of items from which a user can select, and also allows user to enter his own item in the text box. Holds text by allowing user to enter or modify. Stores text which is not editable by user, and is used to describe other controls. UserForm Controls ToolBox is shown in Image 2 Each control in the Toolbox such as a Label or TextBox, has its own associated properties, which can be edited in the Properties Window (ensure that the respective control is selected). 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)
