Finance

Charts

Statistics

Macros

Search

Customizing a UserForm or Custom Form, Excel VBA

UserForms have a variety of properties. You can display the Properties window for the UserForm by clicking on View / Properties Window, as shown in the following figure, or by clicking its Properties icon.

Accessing the Properties Window

Below the Project Explorer, you will see the Properties window, partially visible in the following figure.

UserForm Properties Window

For the first UserForm in the workbook, VBA assigns a default value of UserForm1 to its Name and Caption properties, as you can see in the previous figure. If you were to create a second UserForm, its default Name and Caption properties would be UserForm2, and so on. To distinguish between the Name and Caption properties, the following figure shows where the Name property has been changed to frmEmployees and the Caption property, which appears in the UserForm’s title bar, has been changed to Employees.

The Name Property of the UserForm Object

0 0 votes
Évaluation de l'article
S’abonner
Notification pour
guest
0 Commentaires
Le plus ancien
Le plus récent Le plus populaire
Online comments
Show all comments
Facebook
Twitter
LinkedIn
WhatsApp
Email
Print
0
We’d love to hear your thoughts — please leave a commentx