Excel VBA: Immediate Window - 5 Ways to Use it

The Immediate Window of Excel VBA can be very useful. It enables you to debug and execute code immediately to help you write macros.

This video tutorial explores 5 different ways of using the Immediate Window.

Once you start using this brilliant feature I'm sure there will be no going back. And this handy tool can be added to any existing tools and tricks you use to help write and troubleshoot your Excel macros.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[wayneedmondson]

Hi Alan.. thanks for this video.. very helpful as I work my way through your VBA course. Thumbs up!

[ms.glorimar]

You helped me with this tutorial. Thank you very much!

[mohideenthassim]

Thanks Alan, great video, though I am still long way from finishing your course on VB

[michalroesler]

Great Video, Alan - I've learnt a lot from it. Thumbs up!!!

[xof]

Thank You, Alan
This is usefull information.

[FrancescoMediciBruno]

Hi, thanks for your videos. I ask you for help on the vba interface. The right edge of the page where the code is written, where the icons appear: bookmark (in blue), breackpoint (red) and pause debug (in yellow). This border has disappeared and I can't restore it. Can you help me?

[kherratabdesselem]

Hi
I copied letter by letter the last macro and, il gave me compile error.
I would like to know how to access the library of color
Thanks

[karunanithir]

Sir, At 5.35, in your video, how the yellow arrow is appearing to manually run the code, what are the keys to activate ? I am not clear at this juncture.

[manishbaps]

Did not understand the paramter u aresupplying into the changecolor function... can u pls explain? is it the RGB value?

[rraushan]

Hi dear sir I hv query in excel....I want a value which is located in my sheet1 when I put formula I could get its cell address ....like a finder works.. I m trying it from this formula =CELL("address", INDEX($A$18:$A$24, MATCH(A26, $A$18:$A$24, 0))) but in this formula hv limitations of criteria...if I increase it’s criteria than it’s not working me ....sir I want data is located anywhere in the workbook when I put the formula I could get the results that’s value addresses....help me