code. Select the code and click one of these buttons to change the block’s indenting.
The Drag-and-Drop Text Editing option
The Drag-and-Drop Text Editing option, when enabled, lets you copy and move text by dragging and dropping with your mouse.
The Default to Full Module View option
The Default to Full Module View option sets the default state for new modules. (It doesn’t affect existing modules.) If set, procedures in the Code pane appear as a single scrollable list. If this option is turned off, you can see only one procedure at a time.
The Procedure Separator option
When the Procedure Separator option is turned on, separator bars appear between each procedure in a Code pane. Separator bars provide a nice visual line between procedures, making it easy to see where one piece of code ends and where another starts.
The Editor Format tab
Figure 2-5 shows the Editor Format tab of the Options dialog box. With this tab, you can customize the way the VBE looks.
FIGURE 2-5: Change the way VBE’s looks with the Editor Format tab.
The Code Colors option
The Code Colors option lets you set the text color and background color displayed for various elements of VBA code. This is largely a matter of personal preference.Some Excel developers stick with the default colors. But if you like to change things up, you can play around with these settings.
The Font option
The Font option lets you select the font that’s used in your VBA modules. For best results, stick with a fixed-width font such as Courier New. In a fixed-width font, all characters are exactly the same width. This makes your code more readable because the characters are nicely aligned vertically and you can easily distinguish multiple spaces (which is sometimes useful).
The Size setting
The Size setting specifies the point size of the font in the VBA modules. This setting is a matter of personal preference determined by your video display resolution and how good your eyesight is.
The Margin Indicator Bar option
This option controls the display of the vertical margin indicator bar in your modules. You should keep this turned on; otherwise, you won’t be able to see the helpful graphical indicators when you’re debugging your code.
The General tab
Figure 2-6 shows the options available under the General tab in the Options dialog box. In almost every case, the default settings are just fine.
The most important setting on the General tab is Error Trapping. If you are just starting your Excel macro writing career, it’s best to leave the Error Trapping set to Break on Unhandled Errors. If Excel encounters an error, it stops executing, highlights the line that caused the error, and gives you a chance to figure out what went wrong.
FIGURE 2-6: The General tab of the Options dialog box.
The Docking tab
Figure 2-7 shows the Docking tab. These options determine how the various windows in the VBE behave. When a window is docked, it is fixed in place along one of the edges of the VBE program window. This makes it much easier to identify and locate a particular window. If you turn off all docking, you have a big, confusing mess of windows. Generally, the default settings work fine.
FIGURE 2-7: The Docking tab of the Options dialog box.
Конец ознакомительного фрагмента.
Текст предоставлен ООО «ЛитРес».
Прочитайте эту книгу целиком, купив полную легальную версию на ЛитРес.
Безопасно оплатить книгу можно банковской картой Visa, MasterCard, Maestro, со счета мобильного телефона, с платежного терминала, в салоне МТС или Связной, через PayPal, WebMoney, Яндекс.Деньги, QIWI Кошелек, бонусными картами или другим удобным Вам способом.
