From the Debug object Print method Help page:

"[...T]he Print method typically prints with proportionally-spaced
characters [...]. [...Y]ou can print using a fixed-pitch font (such
as Courier)".

How can I change the font to Courier (or anything else)?

On Feb 13, 4:46*pm, joeu2004 wrote:
From the Debug object Print method Help page:

"[...T]he Print method typically prints with proportionally-spaced
characters [...]. *[...Y]ou can print using a fixed-pitch font (such
as Courier)".

How can I change the font to Courier (or anything else)?

Well, I'm still interested in the answer.

But the Print method is already printing in a non-proportional font
(either Courier or Terminal; I cannot tell). So either the Print
method help page is wrong (so what else is new? ;-), or I figured out
or someone told me long ago how to change the font, and I have forgot
(so what else is new? ;- ;-).

Inside the VBE:
Tools|Options|Editor format
Changing the font here changed the immediate window and the code window.

Courier New (Western)
Was mine--just in case you change and can't remember.



joeu2004 wrote:

On Feb 13, 4:46 pm, joeu2004 wrote:
From the Debug object Print method Help page:

"[...T]he Print method typically prints with proportionally-spaced
characters [...]. [...Y]ou can print using a fixed-pitch font (such
as Courier)".

How can I change the font to Courier (or anything else)?

Well, I'm still interested in the answer.

But the Print method is already printing in a non-proportional font
(either Courier or Terminal; I cannot tell). So either the Print
method help page is wrong (so what else is new? ;-), or I figured out
or someone told me long ago how to change the font, and I have forgot
(so what else is new? ;- ;-).

--

Dave Peterson

After reading Chip's response, I see that I left out the "choose Normal text"
instruction.



Dave Peterson wrote:

Inside the VBE:
Tools|Options|Editor format
Changing the font here changed the immediate window and the code window.

Courier New (Western)
Was mine--just in case you change and can't remember.

joeu2004 wrote:

On Feb 13, 4:46 pm, joeu2004 wrote:
From the Debug object Print method Help page:

"[...T]he Print method typically prints with proportionally-spaced
characters [...]. [...Y]ou can print using a fixed-pitch font (such
as Courier)".

How can I change the font to Courier (or anything else)?

Well, I'm still interested in the answer.

But the Print method is already printing in a non-proportional font
(either Courier or Terminal; I cannot tell). So either the Print
method help page is wrong (so what else is new? ;-), or I figured out
or someone told me long ago how to change the font, and I have forgot
(so what else is new? ;- ;-).

--

Dave Peterson

--

Dave Peterson

I believe you have to change the font assigned to "Normal Text". In the VBA
editor, go to the Tools menu, choose Options, then the Editor Format tab.
There, select "Normal Text" in the Code Colors ListBox. Then, change Font to
"Courier New (Western)". I would hate to have to program in a proportional
font. You will likely want make sure all the text types are set to Courier
New.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


"joeu2004" wrote in message
...
From the Debug object Print method Help page:

"[...T]he Print method typically prints with proportionally-spaced
characters [...]. [...Y]ou can print using a fixed-pitch font (such
as Courier)".

How can I change the font to Courier (or anything else)?

On Feb 13, 5:26*pm, "Chip Pearson" wrote:
I believe you have to change the font assigned to "Normal Text".
In the VBA editor, go to the Tools menu, choose Options, then
the Editor Format tab. There, select "Normal Text" in the Code
Colors ListBox. Then, change Font to "Courier New (Western)".

Bingo! Thanks Dave and Chip for reminding me.