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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
>
> 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 ***

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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >
> >
> > 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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> >
>> >
>> > 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

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" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > >
> > >
> > > 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