• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Advanced VBA Techniques > Navigation Tips and Tricks

Navigation Tips and Tricks

Using the tips and tricks of the trade (many of which are highlighted in this chapter) effectively can save you hours of time. These tricks help you to navigate around the coding environment as well as quickly and easily modify your code. They include the ability to easily zoom to a user-defined procedure, search and replace within modules, get help on VBA functions and commands, and split the Code window so that two procedures can be viewed simultaneously.

Mysteries of the Coding Environment Solved

If you're a developer who's new to VBA, you might be confused by the coding environment. The Code window has two combo boxes, shown in Figure 9.1. The combo box on the left lists objects. For a form or report, the list includes all its objects; for a module, which has no objects, only (General) appears.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint