Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a difference between CTRL+D and CTRL+" (quotation marks) | Excel Discussion (Misc queries) | |||
How to make Ctrl-C, ctrl-V work in Office 2007 | Excel Discussion (Misc queries) | |||
Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets | Excel Discussion (Misc queries) | |||
Redefining the Ctrl [ and Ctrl ]s short cut with OnKey? | Excel Programming | |||
Disabling Ctrl-PgUp and Ctrl-PgDn | Excel Programming |