Immediate Window?

[Charlotte E.]

Hello,


- Is there a way to open and close the Immediate window from VBA?

- Is there a way to clear the Immediate window from VBA?


TIA,

 

[dustinbrearton via OfficeKB.com]

If you are just trying to make it appear and re-appear you can either go to
view in the menu bar and select immediate window or use shortcut key ctrl+g.
To clear it just highlight everything and hit delete.

 

[NateBuckley]

CTRL + G opens the window, you can close it by clicking the x in its window.

Or go to the menu - > View - > Immediate window.

To delete (clear) click inside window push

CTRL + A
Then push delete.

CTRL + A just selects all the text. Make sure you've put your cursor in the
actual window though.

 

[Bob Phillips]

Sub OpenImmediateWindow()
Application.SendKeys "^g"
End Sub


Sub ClearImmediateWindow()
Application.SendKeys "^g ^a {DEL}"
End Sub

 

[Charlotte E.]

Bingo!

Just needed to be preceeded with:

Application.VBE.MainWindow.Visible = True
Application.VBE.MainWindow.SetFocus

Thanks