Changing properties

The first thing we need to do after inserting a UserForm is to change certain properties. The Properties window displays a list of 35 different properties that can be changed, but we're going to start off slow. Once you know how to change one property, the rest will be easy.

In this recipe, we will be changing properties on a UserForm.

Getting ready

Make sure that UserForms.xlsm is still open. UserForm1 should be visible, and both the Project Explorer and the Properties window should be visible on the left of the VBA Editor.

How to do it…

Let's start by changing the first property:

1. We need to give UserForm1 a more appropriate name. In the Properties window, click on the first property of the form, and type in frmNewRecord:

   Figure 14.5 – New form name visible in the Project Explorer

   Note

   This recipe book uses Hungarian notation as standard. Read more about its origin here: https://en.wikipedia.org/wiki/Hungarian_notation...