|   Home    |    eBooks Home    |    Sample Pages    |
eBooks...

The Visual Basic Editor

 

The Visual Basic Editor

The Table of Contents below is reproduced from the Visual Basic Editor ebook. You can see a selection of sample pages from the ebook, browse the free extra content, and buy the ebook online by following the links on the left.

Table of Contents

  • About the Visual Basic Editor

  • Opening the Visual Basic Editor

  • Closing the Visual Basic Editor 5

  • The Visual Basic Editor Window

    • The Menu Bar

    • The Toolbar

    • The Code Window

    • The Project Explorer

      • The Project Explorer in Excel

      • The Project Explorer in Access

      • The Project Explorer in Word

    • The Properties Window

  • Writing Code in the Visual Basic Editor

    • Creating, Removing and Exporting Code Modules

      • Creating and Naming Modules

      • Removing Modules

      • Exporting and Importing Modules

      • A Note About Emailing Files Containing Code

    • Creating Procedures

    • Typing Your Code

    • Knowing What You Can Type

      • AutoList Members

      • Auto Quick Info

      • If Help Does Not Appear

    • Automatic Syntax Checking

      • Error Messages

    • Compiling Code

    • Typing in Lower Case

    • Using Bookmarks

    • Find and Replace

  • Protecting Your Code

    • Adding a Password to a Project

    • Unprotecting the Project

    • Protecting the User

  • Getting Help

    • Using the Help Menu

    • Context Sensitive Help with the F1 Key

    • The Object Browser

      • Search on a Chosen Keyword

      • Browse a Class

      • What Do the Icons Represent?

  • Good Practice in Code Writing

    • Indenting Text

    • Breaking a Line of Text

    • Adding Comments to Code

  • Running Code from the Visual Basic Editor

    • Starting and Stopping Procedures

    • Stepping Through a Procedure

      • Step Into

      • Step Over

      • Step Out

      • Run To Cursor

    • Setting Break Points

    • Reading Values in Break Mode

  • The Locals Window

  • The Watch Window

  • The Immediate Window

    • Getting Information

    • Executing Code Statements

    • Sending Data to the Immediate Window

  • Ten Tips for Writing Good VBA Code

  • Practical Exercises: Exploring the Visual Basic Editor

    • About the Exercises

    • Step-by-Step: Stepping Through Code

    • Step-by-Step: Stepping Over Code

    • Step-by-Step: Stepping Out of a Procedure

    • Step-by-Step: Using Break Points

    • Step-by-Step: The Immediate Window

    • Step-by-Step: Using the Locals Window

    • Step-by-Step: Using the Watch Window

  • Appendix I: Keyboard Shortcuts

    • Keyboard Shortcuts for Editing Code

    • Keyboard Shortcuts for Running and Debugging Code

  • Notes and Further Information

    • About the Author

    • Copyright

    • Limitation of Liability

 

 
^ top
 

Hit Counter