Testing Macros in the Visual Basic Editor in Excel
|
613-749-4695 (Peter) |
Tips and Ideas on Excel |
Tips and Ideas on Macros |
VBA Chapter 5 of 24: Testing Macros in the Visual Basic Editor for ExcelNote: 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:
The following menu appears: Click on "Tile Windows Vertically" and the screen will look SOMEWHAT like this. Yours will be full screen. 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 |
Discover Even More in 50 Excel spreadsheets |
|
613-749-4695 (Peter) |
Tips and Ideas on Excel |
Tips and Ideas on Macros |
Testing Macros in the Visual Basic Editor in Excel