🔧 Properties, Events, and Methods of VBA Form Controls
In VBA, various form controls like Buttons, Check Boxes, Labels, Combo Boxes, and more are used to create interactive forms. Each of these controls has specific properties, events, and methods that define their behavior and interaction with the user. Let’s dive into the details of these controls:
📘 Button Control
✅ Properties
- Caption: The text displayed on the button.
- Enabled: Determines if the button is active or disabled.
- Height: Sets the height of the button.
- Width: Sets the width of the button.
✅ Events
- Click: Triggered when the button is clicked.
✅ Methods
- SetFocus: Gives focus to the button control.
📘 Check Box Control
✅ Properties
- Value: Represents whether the checkbox is checked (True) or unchecked (False).
- Caption: The label or text next to the checkbox.
- Enabled: Determines if the checkbox is active or disabled.
✅ Events
- Click: Triggered when the checkbox is clicked.
✅ Methods
- SetFocus: Sets focus to the checkbox control.
📘 Label Control
✅ Properties
- Caption: The text displayed on the label.
- Font: Defines the font style, size, and color.
- ForeColor: Sets the color of the label text.
- Enabled: Determines if the label is visible and active.
✅ Events
- Click: Triggered when the label is clicked (useful for linking).
✅ Methods
- SetFocus: Sets focus to the label control.
📘 ComboBox Control
✅ Properties
- Value: The currently selected item in the ComboBox.
- ListCount: The number of items in the list.
- ListIndex: The index of the selected item.
- Text: The text in the ComboBox.
✅ Events
- Change: Triggered when the selected item changes.
- Click: Triggered when the user clicks on the ComboBox.
✅ Methods
- AddItem: Adds an item to the list.
- RemoveItem: Removes an item from the list.
📘 Group Box Control
✅ Properties
- Caption: The text label displayed in the group box.
- Enabled: Determines if the group box is active.
- Font: Sets the font style and size for the group box label.
✅ Events
- Click: Triggered when the group box is clicked.
✅ Methods
- SetFocus: Sets focus to the group box control.
📘 Option Button (Radio Button) Control
✅ Properties
- Value: Represents whether the option button is selected (True) or unselected (False).
- Caption: The label displayed beside the option button.
✅ Events
- Click: Triggered when the option button is clicked.
✅ Methods
- SetFocus: Sets focus to the option button control.
📘 List Box Control
✅ Properties
- List: A collection of items in the list box.
- ListIndex: The index of the currently selected item.
- MultiSelect: Determines if multiple items can be selected.
✅ Events
- Click: Triggered when the list box item is clicked.
- Change: Triggered when the selected item changes.
✅ Methods
- AddItem: Adds an item to the list box.
- RemoveItem: Removes an item from the list box.
📘 Scroll Bar Control
✅ Properties
- Min: The minimum value of the scroll bar.
- Max: The maximum value of the scroll bar.
- Value: The current value of the scroll bar.
✅ Events
- Change: Triggered when the scroll bar value changes.
✅ Methods
- SetFocus: Sets focus to the scroll bar control.
📘 Spin Button Control
✅ Properties
- Min: The minimum value of the spin button.
- Max: The maximum value of the spin button.
- Value: The current value of the spin button.
✅ Events
- Change: Triggered when the spin button value changes.
✅ Methods
- SetFocus: Sets focus to the spin button control.
📋 Summary
- Each control in VBA has its own set of properties, events, and methods that define how it behaves and interacts with the user.
- Properties allow us to define the appearance and behavior of controls.
- Events define what happens when the user interacts with a control.
- Methods provide actions we can perform on a control, such as adding items, changing values, or setting focus.