Stopping and Resetting VBA Procedures

At any time, while stepping through the code of a procedure in the Code window, you can:

■ Press F5 to execute the remaining instructions without stepping through

■ Choose Run | Reset to finish the procedure without executing the remaining statements

When you reset your procedure, all the variables lose their current values. Numeric variables assume the initial value of zero, variable-length strings are initialized to a zero-length string (" "), and fixed-length strings are filled with the character represented by the ASCII character code 0 or Chr(0). Variant variables are initialized to Empty, and the value of the object variables is set to Nothing.

0 0

Post a comment