How to clear immediate window without using SendKeys

[polarisking]

Has anyone seen a clever way to do this without

• Using SendKeys (whose unpredictable behavior is legend)
• Establishing references to libraries
• Authoring massive lines of complex code

Still shaking my head that such a straightforward process is so under served.

Thank you in advance.

 

[Hui]

Click in the Immediate window
Ctrl+A
Delete

 

[polarisking]

Hui, I suspect I wasn't clear about my request (unless you're pulling my leg ). I want to do it using VBA, for example calling a little subroutine at the top of the procedure to clean out whatever debug.print messages have been left behind from prior runs.

Make sense?

 

[Hui]

Have a read of
https://stackoverflow.com/questions/10203349/use-vba-to-clear-immediate-window

 

[polarisking]

a genuine thanks for the link, Hui. I came across this same post earlier and that's why bullet 3 in the original post was

• Authoring massive lines of complex code

Perhaps some things are meant to be, but it just seems to make little sense that the VBA editor would provide a feedback loop (immediate window) and no automated way to erase its contents.

Again, thank you for your responses.

 

[Hui]

Writing code in to work in the VBE isn’t simple

 

[Debaser]

As a kludge you can simply write a couple of hundred blank lines to it. Otherwise, it will require APIs or a 3rd party add-in like MZ Tools.