| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to force the immediate window in the VBE to clear
Hi all,
Is there a piece of code that can force the immediate window to clear out on demand? Thank you, Ben -- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to force the immediate window in the VBE to clear
I just CTRL A and delete it. Not elegant, but it works. Or did you want to
do it programmatically? -- HTH, Barb Reinhardt "Ben" wrote: Hi all, Is there a piece of code that can force the immediate window to clear out on demand? Thank you, Ben -- |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to force the immediate window in the VBE to clear
Sub ClearImmediateWindow()
Application.SendKeys "^g ^a {DEL}" End Sub -- __________________________________ HTH Bob "Ben" wrote in message ... Hi all, Is there a piece of code that can force the immediate window to clear out on demand? Thank you, Ben -- |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to force the immediate window in the VBE to clear
yeah, I would like to do it programmatically.
Thanks, Ben -- "Barb Reinhardt" wrote: I just CTRL A and delete it. Not elegant, but it works. Or did you want to do it programmatically? -- HTH, Barb Reinhardt "Ben" wrote: Hi all, Is there a piece of code that can force the immediate window to clear out on demand? Thank you, Ben -- |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to force the immediate window in the VBE to clear
Got it. Thank you Bob.
Ben -- "Bob Phillips" wrote: Sub ClearImmediateWindow() Application.SendKeys "^g ^a {DEL}" End Sub -- __________________________________ HTH Bob "Ben" wrote in message ... Hi all, Is there a piece of code that can force the immediate window to clear out on demand? Thank you, Ben -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to clear Immediate Window programmatically within a procedure? | Excel Programming | |||
| The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
| Force linked spreadsheet to open in fullsized window? | Excel Discussion (Misc queries) | |||
| How do I force a hyperlink in a spreadsheet to open a new window? | Excel Worksheet Functions | |||
| clear intermediate window automatically | Excel Programming | |||
Linear Mode
