Techniquices

From [https://www.excelcampus.com/vba/vba-immediate-window-excel/] 5 Ways to Use the VBA Immediate Window in Excel Jon Acampora  September 23, 2014 The VBA Immediate Window is an awesome tool that allows you to get immediate answers about your Excel files, and quickly execute code.  It is built into the Visual Basic Editor, and has many different uses that can be very helpful when writing macros, debugging code, and displaying the results of your code. Every Excel user can benefit from the Immediate Window, even if you’re not writing macros.  This post will explain 5 different uses for the Immediate Window.  Once you understand the capabilities of this tool, you will find yourself using it all the time. Where is the Immediate Window? The Immediate window is located in the  Visual Basic Editor window . The fastest way to get to the Immediate Window is to: Press  Alt+F11  (hold Alt key, then press F11 key) from anywhere in Excel.  The Visual Basic Editor wind