What is a Call Stack?
The concept of a call stack explained in under 100 words. #Under100
![What is a Call Stack?](/content/images/size/w2000/2021/11/booth-71154.jpg)
In programming, a call stack is a last-in, first-out listing of procedure calls.
Real World Analogy
My wife has a question for my son, Luke, but he's off in the woods. So the question gets relayed through the whole family:
![](https://nolongerset.com/content/images/2021/11/image-5.png)
![](https://nolongerset.com/content/images/2021/11/image-6.png)
![](https://nolongerset.com/content/images/2021/11/image-7.png)
![](https://nolongerset.com/content/images/2021/11/image-8.png)
![](https://nolongerset.com/content/images/2021/11/image-9.png)
Unwinding the Stack
As each person responds, the stack shrinks:
![](https://nolongerset.com/content/images/2021/11/image-10.png)
![](https://nolongerset.com/content/images/2021/11/image-18.png)
![](https://nolongerset.com/content/images/2021/11/image-17.png)
![](https://nolongerset.com/content/images/2021/11/image-16.png)
![](https://nolongerset.com/content/images/2021/11/image-15.png)
Viewing the Call Stack
To view the call stack in VBA, go to View > Call Stack... (Ctrl + L).
![](https://nolongerset.com/content/images/2021/11/image-23.png)
Note that the call stack window is only available while the code is executing.
Image by PublicDomainPictures from Pixabay
UPDATED [2021-11-05]: Added sample code to the VBA Call Stack screenshot; added image credit.