Using the Call Stack

A call stack can be used to trace through the process of nested procedures. You can use the call stack window when VBA is in break mode by selecting View C> Call Stack. However, you have to create your es

Figure 2.38

| Watches

Expression

| Value Type

Context

mtCounter

<0ut of context;- Empty

modBusinessLogi

■v

Figure 2.39

Watches

Expression Value

type

Context *

intCounter 1

Integer

modBusinessLogi

Figure 2.40

Figure 2.40

own call stack if you are not in Debug Mode. You have various ways to create your own call stack, such as to write various messages to the Immediate Window as you enter certain procedures to see the order in which they were called.

0 0

Post a comment