about ctrl+g in vbe
 

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 ***

about ctrl+g in vbe
 

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 ***

about ctrl+g in vbe
 

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

about ctrl+g in vbe
 

MZ Tools (www.mztools.com) seems to do it programmatically, but I don't know
how it works. I tried subclassing the Immediate window using SPY++ to see
what messages it was receiving, but I never got the right messages. This is
but one of many very nice tools that are supplied by MZ Tools; it is a good
add-in for any serious VB/VBA/NET programmer.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Dave Peterson" wrote in message
...
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

about ctrl+g in vbe
 

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