Properties Window

Here is the place where you can save a lot of time typing code. As you know, VBA is based on Visual Basic. The “Visual” part of that name means that you don’t always need to type code. You can select options from the list in the Properties window. You can open the Properties window by either pressing F4 or selecting View | Properties Window. This window is shown in Figure 7-5 with the Alphabetic tab selected.

Figure 7-5: Properties window in alphabetical order

Select the Categorized tab to see the items classified by type. This is shown in Figure 7-6. The Categorized view allows you to expand or collapse categories using either the [+] or [-] to the left of each category.

Figure 7-6: Properties window in categorized order