By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

Immediate Window

Quick Steps

Go to Excel

Press Alt+F11 --> VBA Editor Opens

Press Ctrl+G --> Immediate Window is activated

Using

Display variables

Run method

View contents

The Immediate Window looks like

and you access it via the Ctrl+G

Use the Print or ? to display the contents of a

Variable --> a = 3:?a

Property --> ? sheets.count

Enter an Object and Method to do something

Object.Method --> Sheets1.Select

In VBA Code

use Debug.Print "what to print"