I'm not sure if I remembered correctly. I think that the problem with one
suggestion (a long time ago) was that it used sendkeys to try to clear that
immediate window. And sometimes, it would clear the data on a worksheet. (It
may not have anything to do with crashing excel.)



Dave Peterson wrote:

I think someone came up with a suggestion, but sometimes it crashed excel
(IIRC).

Maybe just doing something like:

Option Explicit
Sub testme01()
Dim iCtr As Long
For iCtr = 1 To 1000
Debug.Print
Next iCtr
End Sub

would be enough for the OP.

Zone wrote:

I believe this has come up before, and the answer was there is no way to
programmatically clear the immediate pane. Easiest way to clear it is to
place the cursor in the immediate pane, press Ctrl-a, then press Delete.
James
"tom taol" wrote in message
...


i want to clear the texts after ctrl+g in vbe.
for example
debug.print 3
debug.print 3
debug.print 7


and then
debugWnd.clear this syntax....



*** Sent via Developersdex http://www.developersdex.com ***

--

Dave Peterson

--

Dave Peterson