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

User Forms and Controls in Monte Carlo simulations


In this next example named FastSlow, we'll introduce several new concepts, as well as perform a direct comparison of execution speed between two ways of handling interaction between the worksheet and VBA.

New concepts we'll introduce are:

  • Using additional embedded controls in the worksheet

  • Incorporating a VBA user form for interacting with the code during execution

  • Outputting the raw data from each iteration to the worksheet

  • A shortcut for clearing out the data

Below is a screenshot of the worksheet.  We'll discuss each of the above concepts on the subsequent pages.



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.