Using the Object Browser in the VBA Editor
This recipe covers usage of the Object Browser in the VBA Editor. The name says it all; the Object Browser lets you browse through the objects available to you.
In later recipes, we will look into the autocompletion of our code. For instance, when you type the name of an object in the code window and type a dot, a context menu appears with a list of actions you can choose from:
Figure 3.9 – The context menu with available library options
The green icons are methods, including cutting, pasting, and clearing contents. The other icons are properties. You can, in other words, choose methods or properties here, or use the Object Browser, as described hereafter.
Getting ready
Make sure that a blank workbook is active in Excel.
How to do it…
- Activate the VBA Editor by pressing Alt + F11.
- With the Editor active, press F2 to activate the Object Browser. You can also do this by clicking...
