Use VBA to Clear Immediate Window?

excel vba immediate-window
Alpha picture Alpha · Apr 18, 2012 · Viewed 100.5k times · Source

Does anyone know how to clear the immediate window using VBA?

While I can always clear it myself manually, I am curious if there is a way to do this programmatically.

Answer

Blaz Brencic picture Blaz Brencic · Jun 20, 2012

Below is a solution from here

Sub stance()
Dim x As Long

For x = 1 To 10    
    Debug.Print x
Next

Debug.Print Now
Application.SendKeys "^g ^a {DEL}"    
End Sub

Related questions

How can I print a range variable in the immediate window? Excel VBA

I'm attempting something that should be very simple. However I've just started learning today and and can't quite understand. This is my code so far: Public Sub getCellData() Dim wb As Workbook: Set wb = ThisWorkbook Dim ws As Worksheet: Set …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
How do I declare a global variable in VBA?

I wrote the following code: Function find_results_idle() Public iRaw As Integer Public iColumn As Integer iRaw = 1 iColumn = 1 And I get the error message: "invalid attribute in Sub or Function" Do you know what I did wrong? I tried …

Read More