Clearing the Immediate window?

[terrypin]

As a VBA novice I'm frequently trying to see what is happening to the variables I'm using. When there are many of them, as in the code below, the msgBox method (my preference) cannot be used because I understand it has a 1024 character limit.
Q1: Is there any way to extend that?

Q2: Assuming not, if instead I use debug.Print is there a statement that will clear it entirely, to avoid doing it manually please?

Q3: Is another alternative possible, such as saving a small text file and then automatically viewing that?

Please Login or Register  to view this content.

[Andy Pope]

No built in command to clear the debug window. You could use sendkeys, if you are brave.
Or write a function to fill the window with blank lines. 250 should do it. But if the cursor in the immediate window is not at the end you will still have text below the cursor.

I believe MZ-Tools offers this feature, but it costs $$

Personally I would use a worksheet and some code that takes a ParamArray so a variable number of arguments can be handle.
Each write adds a new row and each argument is written to a cell.

[TMS]

Ctrl-a Delete is hardly arduous ...

Personally, I wouldn’t try to display 21 variables, bit hard to take in. And I wouldn’t have new lines between each of them ... all depends on the content I guess.

Writing them to a worksheet is one option, but you probably need to date and time stamp the entries.

You could use Print or Write to update a text file.

[terrypin]

Thanks Andy. Pity, a Clear would be handy! I may explore your ParamArray suggestion, although that's new territory.

[terrypin]

Thanks TMS. I agree, but I frequently forget to do it. And without those newlines it's even harder 'to take in'!

I'll investigate Print and Write later.

[KOKOSEK]

Or You can use different type of MsgBox:
Try to:

Please Login or Register  to view this content.

look on pictures (try to display range A1:Y40):
Capture.JPG
Captur11111e.JPG

[terrypin]

Thanks KOKOSEK. That looks interesting, and I ran a simple small example OK.

But I don't really understand how you displayed that large message. And I assume it has the same 1024 character limit as a normal MsgBox.

Could you show a sub that makes it clearer please?

[TMS]

Please Login or Register  to view this content.

[BMV]

terrypin, If you use it for debug then you can place this data to an additional work sheet. I think navigation and control will be easy then looking at the large message box.
Even text box in a worksheet or on the form will be more useful.

[KOKOSEK]

The same range has not been displayed in standard msgbox (limited space) and been displayed in shell msgbox.
@terrypin - I don not know what is not clear for you.

Once more....

1.JPG
2.JPG

EDIT: TMS shows the way meantime

[terrypin]

TMS, KOKOSEK,

Thanks both, got it.

How do you resize and reposition the window?

[terrypin]

Thanks BMV, neat idea. I just added the line

Please Login or Register  to view this content.

and as you suggested that gave a more convenient display.

[Rick Rothstein]

THow do you resize and reposition the window?

There does not appear to be a way to do that. Here is a link to webpage giving a pretty extensive description (in about a little more than the first 1/3 of that webpage) of how to program the PopUp method for WScript.Shell...

http://www.informit.com/articles/art...87429&seqNum=5

[terrypin]

One puzzle. I added another couple of lines so that it would automatically size the cell containing the message. But although it gets the height correct, the width is wrong.

It's very easy to do manually (although strangely even that isn't perfect) but I'm curious why the macro doesn't work.

Please Login or Register  to view this content.

[terrypin]

Thanks Rick, studying that now. Pity its dimensions can't be changed. And at first reading it seems more complicated to setup than in KOKOSEK's simple

Please Login or Register  to view this content.

[Rick Rothstein]

And at first reading it seems more complicated to setup than in KOKOSEK's simple

Please Login or Register  to view this content.

It is the same thing... KOKOSEK simply left out all of the possible optional arguments, that is all. For your current needs, you appear not to need the optional arguments, but knowing they are available could be useful if you decide to use it in the future.

[mjr veverka]

... how ... displayed ... large message ...

1. Clearing the Intermediate Window:

https://www.excelforum.com/excel-pro...ow-in-vba.html

2. For "message output" -> use ordinary notepad for that ... nice fun ... "hardcore game" ...
(only that on new windows (8, 10) "DataObject" may not work)

Please Login or Register  to view this content.

[Rick Rothstein]

2. For "message output" -> use ordinary notepad for that ... nice fun ... "hardcore game" ...
(only that on new windows (8, 10) "DataObject" may not work)

Your are correct... your display_message subroutine did not work on my Window 8 system. However, if you are willing to tolerate a file being written to the c:\temp folder and then deleted from it, this replacement code for your display_message subroutine should work on any system so long as the c: drive has a folder named "temp" (which I believe is standard. Of course, we could modify the code to create a directory, store the file there, load it into Notepad and then delete the file and then the folder, but I decided not to do that for this demo. Anyway, here is the replace code I am suggesting...

Please Login or Register  to view this content.

Note: The file name should be something that won't ever exist in the folder... here I used my nickname with the word Temp inserted between the letters.

[protonLeah]

Are you avoiding the Watch Window on purpose?

[BMV]

Thanks BMV, neat idea. I just added the line

I mean

Please Login or Register  to view this content.

If you need split message by column, it could be done also.

[DevelopmentTest]

Clearing the Immediate window?

Like also Andy Pope is saying, not always good to use send keys.
But following is another alternative I use, working for me mostly.

Open file, Tel U Wot , button press.
( Tel U Wot button for macro Sub ImmediateWindowOpenClearCloseProgramatically() is )
( If VB Editor window is open already, then you must run from within VB Editor instead)


Macro Sub ImmediateWindowOpenClearCloseProgramatically() will open Immediate window with some text in it, then it will clear immediate window, then it will close it. ( It does do that for me , anyway is doing usually is )
There are a few bugs associated with bringing various windows and shapes up. These can often be worked around using some known techniques. These have been applied in the uploaded solution

[terrypin]

It is the same thing... KOKOSEK simply left out all of the possible optional arguments, that is all. For your current needs, you appear not to need the optional arguments, but knowing they are available could be useful if you decide to use it in the future.

But KOKOSEK's code didn't include

Please Login or Register  to view this content.

which that article seems to say is needed?

If I add that I get "Run-time error '424': Object required", with that line highlighted.

[BMV]

Please Login or Register  to view this content.

WScript - it's object from VBS script

[terrypin]

Are you avoiding the Watch Window on purpose?

Thanks Ben, never used that but studying it now and will experiment. Appreciate the heads up!

[terrypin]

Thanks DevelopmentTest, playing with that now.

[mjr veverka]

... a file being written to the c:\temp folder and then deleted from it ...

Ok, that's good

... but studying it now and will experiment ...

We could, if someone likes html, to make output to a blank browser page (the simplest html document or data table)