power4XL Microsoft Excel Resource Center
Free Macros, Formulas, Functions, Tutorials, Downloads, Add-Ins & More!

Opening Excel's Visual Basic Editor

ShareThis

One step remains before beginning to create your own Excel Monte Carlo simulations using VBA code: you need to open the Visual Basic Editor.

In Excel 2007, the editor is opened by clicking on the Visual Basic button under the Developer tab on the Ribbon Interface.

 

In Excel 2003, the editor is opened by pressing the shortcut key combination Alt+F11, or by selecting the drop-down menu Tools - Macro - Visual Basic Editor as illustrated below.

Now we'll begin our first example, the Simple Coin Toss.

 

Prev | Contents | Next

Copyright notice:  This site and all content, including computer code and spreadsheet examples, are copyright 2006 by Fritz Dooley.  License is granted for individual users to download examples and to copy code directly into user's spreadsheets and Visual Basic for Applications files.  Users may not redistribute code in any way.  Providing hyperlinks to this web site is encouraged, but posting code and examples on other web sites is expressly forbidden.  "Microsoft" is a registered trademark of Microsoft Corporation.   Neither this web site nor Fritz Dooley is affiliated with Microsoft Corporation.