Properties Window
The Properties window has two tabs.
The Alphabetic tab displays all the properties in alphabetical order
The Categorized tab displays the properties grouped into logical categories.
Both tabs contain the same properties.
To change a property just click it and specify a new value.
If you select more than one control then the Properties window only displays the properties that are common to both.
The Image control's Picture property is a bit different because you either select a graphic file or you can paste a graphic directly from the clipboard. Using (Ctrl + V).
Tag Property
Every userform and control has a tag property.
This property does not represent anything specific and is empty by default.
You can use this tag to store your own information in.
For example you may have a series of textboxes on a userform.
The user may be required to enter text into some of the textboxes but not all of them.
You could use the tag property to indicate if a textbox is required to be filled in or not.
For Each objControl In UserForms.Controls
If TypeName(objControl) = "TextBox" Then
If objControl.Tag = "Required" Then
End If
End If
Next objControl
All the controls on a userform make up the collection Userform1.Controls.
There is not a collection for each type of control so you must use the TypeName function to determine the type of each control.
Common Properties
Depending on the type of control will depend on the methods and properties that are available.
There are however some properties that are common to all types of control
ControlTipText | Tool tip text to appear when you hover the mouse over the control |
ControlSource | Links the control to a cell on a worksheet |
Default | True if the control is to be selected when the Enter key is pressed |
Enabled | |
Height | |
HelpContextID | |
Left | |
Tag | Invisible tag that can be used for control management |
Top | |
Visible | True if the control is visible when the userform is displayed |
Width |
Common Methods
Depending on the type of control will depend on the methods and properties that are available.
There are however some properties that are common to all types of control
SetFocus | Moves the input focus to that control |
Common Events
Depending on the type of control will depend on the methods and properties that are available.
There are however some properties that are common to all types of control
Enter | Sent when a control receives the input focus |
Error | Sent when an error has occurred |
Exit | Sent when the control loses the input focus |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext