Formatting text in Word 07 as code

[nuge725]

Hello everyone,

I am working on a Word document that I use to keep all of my Excel codes in one place so that I remember what they are and what code performs which function. Is there a way to have the VBA code written int he document to appear in a code box like below?

This is an example of what I'm looking for.

Thanks in advance,

Nuge

 

[SydneyGeek]

Select the text in Word.
Format it to use Courier New 10 and place a border around it if you wish. Adjust the line spacing and the before and after paragraph spacing.
Create a new style using the selection, and name the style CODE.
Next time you insert some VBA text, select it and apply the CODE style.

Denis