«

»

Excel VBA Tip: Change Visual Basic Editor’s (VBE) Default Font Size

Untitled Document

by Jackie Kiadii, Excel VBA Instructor

 

When I teach Excel Macros and Visual Basic for Applications (VBA) courses, one of the student complaints is how difficult the Visual Basic Editor (VBE) is to read. The default font of Courier 10 is not the easiest on the eyes. Fortunately, changing the font is really quick and easy.

 

Excel VBA Change Font Size

 

What is the Visual Basic Editor (VBE)?

 

The VBE is Excel’s code area. You can get to it by clicking the Developer tab, then Visual Basic in the Code group. A shortcut for accessing the VBE is ALT F11.

 

Changing the VBE’s Default Font

Switch to the VBE (ALT F11).

Click the Tools menu.

Click Options.

Click the Editor Format tab.

Change the font and size. To make it easier for students to see my screen, I usually use Verdana 14 pt.

 

About the Author

Jackie Kiadii is an Information Technology professional with a degree in Computer Information Systems. She learned to program with Visual Basic over 20 years ago, and has developed the following Advanced-level Excel courses: Jump Start Excel Macros/VBA™, Painless Pivot Tables ™ and Excel’s Best Functions – from A to Z™. Her company also offers Excel 2007, 2010 and 2013: Certification Prep, Basic through Advanced training.

Need onsite group training? Call 770.498.7333 or email us. Our courses can be customized to your needs. Jackie has provided software training for employees of The Coca-Cola Company, Emory University, Novelis, and more. This training is available for groups of 4 or more students.

Atlanta Computer Training on Facebook Atlanta Computer Training - LinkedIn Software Tips on Twitter

Click to Grab Your Excel Ebook – Free!

Get the free Excel ebook

12 Tips to Empower Excel Users

2 pings

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>