|
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.

|