The
following subjects were presented in this chapter:
- The VB Editor (VBE): how to open it and
its main components
- How to insert a code module
- How to use the Properties pane to modify
properties of an object; our example is the worksheet object
- The two main ways to refer to a worksheet
in VBA; in our example we activated a worksheet using code
- How to step through code
- Recording a macro and modifying the code
The next chapter introduces the main code blocks used in VBA. You will
use these blocks in several exercises. Some of these exercises consist
of writing useful code snippets that you can use over and over again.