Immediate window is a very important element in the VBA Environment. You can use it to see the result of the debugging statements. Also you can directly write commands to the immediate window as well.
Following are two main benefits of immediate window.
- Find the result of the functions.
- Find Current values of the variables.
If your VBA environment looks like this then your immediate window is not visible.
To make it visible, you can follow these steps.
First click on the “View” menu. Then click on the “Immediate Window”.
Immediate Window will appear below the code Window.
Also you can use the following keyboard shortcut to show the immediate window.
Ctrl + G