VBATrain.com
Chapter 1 The Visual Basic Editor Page 11 of 11

   VBATrain Home    |    Sample Lessons Index    |   Previous Page


Chapter 1 Summary

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.



   VBATrain Home    |    Sample Lessons Index    |   Previous Page

Click here for feedback and questions about this chapter.

Copyright © 2006-2008 J. Donald McClenagan, PhD, ALL RIGHTS RESERVED