Customizing the VBE Environment

If you're serious about becoming an Excel programmer, you'll be spending a lot of time with the VBE window. To help make things as comfortable as possible, the VBE provides quite a few customization options.

When the VBE is active, choose Tools Options. You see a dialog box with four tabs: Editor, Editor Format, General, and Docking. I discuss some of the most useful options on these tabs in the sections that follow. By the way, don't confuse this with the Excel Options dialog box, which you bring up by choosing Office

Excel Options in Excel.

0 0

Post a comment