Excel VBA Basics #6 - Fun with the Immediate Window

In this short video, we learn how to view the current value of variables, objects or even make quick changes in the middle of a macro using the Immediate Window. This is extremely useful when debugging (going line by line).

Fantastic Developer Tools:

[txixoig]

Thanks Man for teaching us all of this stuff. Its been a week since I am watching your videos and it has helped me a lot in learning VBA. Have a great life ahead and thanks again! :)

[rajganguly]

Great work !! The similarity between ExcelIsFun and ExcelVBAISFUN is the "Awesomeness".Thanks
Raj Ganguly

[joymeng]

Haven been watching it 1-5, and all episodes are very helpful! Thanks, Daniel! Happy New Year and God bless you! 

[neilgill]

Excellent tutorial. Better than any books/videos I've viewed to date. Thanks!

[ExcelVbaIsFun]

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

[ExcelVbaIsFun]

Crap! I forgot I had seen that ages ago. No, I need to remember that and put it into practice. Thanks Modelbaan! I'm so glad you reminded me of this!!! Dan

[divyakhare]

Great work. Thanks for your amazing videos.

[OptionGal]

After another all-night of coding, thought I'd take a break to watch some Daniel Strong videos. I must be getting really punchy because I could swear this video is titled "Fun with the Immediate Window".  :-)  I'm just sorry didn't see it earlier... Another great VBA lesson from Dan -- keep 'em coming!

[CADSharp]

Good video, though you should also note that Debug.Print can be placed in the code itself to print values / comments while the code is running.

[vyvu]

Is function of debug.print still available on Excel 2010? I try but either no result came out or error 1004. Thanks

[Sur]

So, when you change the value of 'x' in the immediate window, how do you undo it if you want it to just go back to whatever it was?

[jsteele]

#5 is out of order, I was really confused at first when I moved from #4 to #5, haha

[ModelbaanTBM]

Did you know that "?" does the same thing as "Debug.Print"?

[andreikilla]

if x is 2 to 10 why pizza is in row 15?