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,

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.

Charlotte E. wrote:
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,

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200808/1

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.

"Charlotte E." wrote:

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,

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


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


--
__________________________________
HTH

Bob

"Charlotte E." wrote in message
...
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,

Bingo! :-)

Just needed to be preceeded with:

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

Thanks :-)



"Bob Phillips" skrev i en meddelelse
...


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


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


--
__________________________________
HTH

Bob

"Charlotte E." wrote in message
...
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,