ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to force the immediate window in the VBE to clear (https://www.excelbanter.com/excel-programming/416548-how-force-immediate-window-vbe-clear.html)

Ben

How to force the immediate window in the VBE to clear
 
Hi all,

Is there a piece of code that can force the immediate window to clear out on
demand?

Thank you,

Ben


--


Barb Reinhardt

How to force the immediate window in the VBE to clear
 
I just CTRL A and delete it. Not elegant, but it works. Or did you want to
do it programmatically?
--
HTH,
Barb Reinhardt




"Ben" wrote:

Hi all,

Is there a piece of code that can force the immediate window to clear out on
demand?

Thank you,

Ben


--


Bob Phillips[_3_]

How to force the immediate window in the VBE to clear
 
Sub ClearImmediateWindow()
Application.SendKeys "^g ^a {DEL}"
End Sub

--
__________________________________
HTH

Bob

"Ben" wrote in message
...
Hi all,

Is there a piece of code that can force the immediate window to clear out
on
demand?

Thank you,

Ben


--




Ben

How to force the immediate window in the VBE to clear
 
yeah, I would like to do it programmatically.
Thanks,

Ben

--



"Barb Reinhardt" wrote:

I just CTRL A and delete it. Not elegant, but it works. Or did you want to
do it programmatically?
--
HTH,
Barb Reinhardt




"Ben" wrote:

Hi all,

Is there a piece of code that can force the immediate window to clear out on
demand?

Thank you,

Ben


--


Ben

How to force the immediate window in the VBE to clear
 
Got it. Thank you Bob.

Ben

--



"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"Ben" wrote in message
...
Hi all,

Is there a piece of code that can force the immediate window to clear out
on
demand?

Thank you,

Ben


--






All times are GMT +1. The time now is 01:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com