Increase Font Size in VBA Window

Easy change

Yes, you can make the text in the VBA window easier to read.

It is also great for training.

(This tip may not work on 4K monitors.)

To open the VBA Window press Alt + F11.

Click the Tools menu and then Options  – see image below.

Click the Editor Format tab and change the Size drop down to 14, or whatever you want – see image below.

Click OK and the font size will now be increased in the code window.

See below for a comparison between 10 and 14 point.

Must easier to read!

Unlocking coloured cells in Excel

Styles and Find solutions

When you create an Excel file that handles inputs it is best practice to colour code the input cells. The colour you choose isn’t important but making sure you use it consistently is. You may need to unlock the input cells if you plan to add sheet protection to the file. Here’s a couple of ways to do that.

Twelve months of free Excel webinars

Free monthly Excel webinars

This month celebrates 12 consecutive free monthly Excel training webinars. One a month since August 2018.

(I have kept adding the new free sessions to the list)

You can view the recordings and download the materials using the table below. Sorted by Skill Level.

17 hours of free, practical CPD. Remember to keep your own records of recording viewing for CPD purposes.

Please share with the your network, enjoy!

Latest Free Excel Webinars

Free Courses (One hour each)LevelRecording LinkMaterials
Excel Keyboard ShortcutsBegRecordingMaterials
Excel Mouse Shortcuts BegRecordingMaterials
Excel Formatting TipsBegRecordingMaterials
Excel 2016 Conditional FormatsIntRecordingMaterials
Excel Date and Time CalculationsIntRecordingMaterials
Excel Custom Number FormatsIntRecordingMaterials
Excel Financial Functions Part 1
Excel Financial Functions Part 2
Dashboard Guidelines & TechniquesIntRecordingMaterials
Format As Table FeaturesIntRecordingMaterials
Excel 2016 Chart Tips & TricksIntRecordingMaterials
Excel Yourself 2018 Beg/Int/AdvRecordingMaterials
Excel Yourself 2019Int/AdvRecordingMaterials
Mastering Excel's Form Controls
Excel 2016 What-If Techniques AdvRecordingMaterials
Excel Budget ChallengeAdvRecordingMaterials
Excel Recorded MacrosAdvRecordingMaterials
Interactive Excel ChartAdvRecordingMaterials
Introduction to Power QueryAdvRecordingMaterials
Sorted by Level - updated January 2020
Level Beg = Beginner, Int = Intermediate, Adv = Advanced

Handling Exceptions in Excel

Two ways to consider

When developing budgets and financial models you may need the same rate/value (say debtor days) for 10 months of the year but need to adjust it for 2 months. It is usually December and January as they tend to be a little different due to the Christmas / New Year period. Here’s a couple of ways to handle exceptions in Excel.