From the course: Excel: Learning VBA

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Verify output using the Immediate window

Verify output using the Immediate window - Microsoft Excel Tutorial

From the course: Excel: Learning VBA

Start my 1-month free trial Buy for my team

Verify output using the Immediate window

“

- [Instructor] So far in this course, I have verified my code's output using message boxes. Message boxes are fine, but they require that the user, probably you, click a button to dismiss them and continue running the program. If you prefer to bypass message boxes and still get the feedback on your code, you can use the Immediate Window. The Immediate Window is a panel that appears at the bottom of the Visual Basic Editor. In this movie, I will demonstrate how to use it. My sample file is 04_04_immediate, and you can find it in the Chapter 4 folder of the Exercise Files collection. I have some data in this workbook so that the subroutine we work with will have something to display. And I've got the value of tax owed to the State of Virginia, specifically to the city of Mt. Crawford. To look at the VBA code that operates on this data, I'll press ALT F11 to move to the Visual Basic Editor. And I have a subroutine called…

Contents