{"id":14625,"date":"2018-03-17T23:50:00","date_gmt":"2018-03-17T23:50:00","guid":{"rendered":"http:\/\/learnexcelmacro.com\/wp\/?p=14625"},"modified":"2018-03-18T08:22:17","modified_gmt":"2018-03-18T08:22:17","slug":"what-is-immediate-window-and-how-to-use-it-in-excel-vba","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2018\/03\/what-is-immediate-window-and-how-to-use-it-in-excel-vba\/","title":{"rendered":"What is Immediate Window and how to use it in Excel VBA"},"content":{"rendered":"
Dear Friends,<\/p>\n
Have you heard of Immediate Window in Excel VBA programming? Do you know how to make use of it? <\/p>\n
If you have not been using this while doing vba programming then trust me you were missing something really cool stuff which excel provided to the programmers.<\/p>\n
In this article I am going to explain you the following<\/p>\n
1. What is immediate window in Excel VBA and how to open it?
\n2. What is the use of Immediate windows?
\n3. Top 5 Usage of immediate window with examples\n<\/p><\/div>\n
Immediate window is a plane white background simple window in Visual Basic Editor, which can be used for different purposes. By Default, this window is not visible when you open the VBE in your excel. To view this window in your Excel VBE Click on View –> Immediate Window ( or Use Shortcut key Ctrl + G) <\/em><\/strong>to view this window as shown in below picture<\/p>\n