I made a new version of my Application Settings addin as per Sébastien’s comments in my last post.
As you can see, there are new settings for the following.
Application.Iteration
Application.MaxIterations
Application.MaxChange
In the case of the last 2 settings, you’ll notice that there are Set, Reset and Save buttons. This is how they work,
Set: Set to the number that is entered in the text box.
Reset: Reset to the real default or “alias” default.
Save: Save an “alias” default instead of Excel’s real default. For example, if you prefer 120 instead of 100 for Max Iterations, you can set the “alias” default so that the form does not appear when opening or saving the active workbook if Application.MaxIterations is set to 120. Also, clicking the Reset button thereafter will reset Application.MaxIterations to 120. And using the Set button to set Application.MaxIterations to any other value than 120 will show the value in red font to indicate it is not the “alias” default.
Hope this is useful. Download the new version here.
I wasn’t familiar with Itera r tive Calculation
Nice update. Glad to have been your muse.
@snb
I rarely use it myself, but have come across a few people who say they use it often. If memory serves correct, one person said it was used for a Monte Carlo simulation and just Googling it now, there’s a few results that pop up. (monte carlo simulation vba)
@snb
Ah, spelling error. Thanks, I’ll fix it!
@Sébastien
Thanks!