Testing Macros in the Visual Basic Editor in Excel

    

613-749-4695 (Peter)
[email protected]

Home Page

Tips and Ideas on Excel
Table of Contents on Excel

Tips and Ideas on Macros
Table of Contents on VBA

Quick Links

 

VBA Chapter 5 of 24: Testing  Macros in the Visual Basic Editor for Excel

Note: The images and the text below refer to the workbook "vba-tutorial-editor.xls"

Close every program on your computer. Open Excel and one of the workbooks mentioned above. Open the Visual Basic Editor. On the Window status bar at the bottom of your screen you can see that Excel is open and also the VBE. Right click on the status bar in the empty space where I have added the orange stars:

Status Bar

The following menu appears:

Contextual Menu

Click on "Tile Windows Vertically" and the screen will look SOMEWHAT like this. Yours will be full screen.

VBA for Excel split window

The Excel workbook occupies half of the screen and the VBE occupies the other half. Excel can be in the left half of the screen or the right half. Make  the Code window wider in the VBE so that you can see most of the code.

 

Next Chapter: Security and Protection in VBA for Excel

VBA Table of Contents
or use the quick links below

 

Discover Even More in 50 Excel spreadsheets

 

    

613-749-4695 (Peter)
[email protected]

Home Page

Tips and Ideas on Excel
Table of Contents on Excel

Tips and Ideas on Macros
Table of Contents on VBA

Quick Links

Testing Macros in the Visual Basic Editor in Excel