Share this Page URL

Chapter 5. Using Visual Basic to Automat... > Setting Up the Visual Basic Editor - Pg. 165

Using Visual Basic to Automate Your Database 165 Quick Check Q. Which control structure can you use to define a set of conditions that will determine which set of instructions a procedure runs? A. If...Then...Else or Select Case. Q. How is the GoTo statement frequently used? A. At the start of error-handling code. Setting Up the Visual Basic Editor As you work in the Visual Basic Editor, you'll develop preferences for how to arrange windows, view code, and use the IntelliSense feature. In this section, we'll review some of the choices you have for setting up the Visual Basic Editor and for the information that IntelliSense provides. You make these selections in the Options dialog box, shown in Figure 5-1, which you open from the Tools menu. We won't cover every option here; clicking the Help button in the Options dialog box will lead you to information for those we don't cover. Figure 5-1. The Editor tab of the Options dialog box lists a set of options for working with IntelliSense and viewing code. Use the other tabs to manage windows, code formatting, and other general options The Editor Tab The Code Settings area of the Editor tab lists options for the information provided by IntelliSense. It also includes the option Require Variable Declaration, which, as mentioned, adds the Option Explicit statement to the general declarations of any new module. You're then required to declare each variable explicitly. We recommend selecting this option. The following list describes other options you should try out: