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.

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!

Free Webinar Recording – Recorded Macros Tips Tricks and Traps

Getting started with recorded macros

It is easy to create a recorded macro. It is not so easy to create a flexible and re-usable recorded macro. Click the materials Button below to download the pdf manual and example file.

Learn the techniques that can allow you to record effective macros that can handle different ranges and changes to sheet names.

Macros can speed up your work and reduce the time taken for tedious tasks, as well as adding functionality to Excel.

This is the first in a series of webinars dedicated to macros. Future paid sessions this month (August 2019) will expand on the techniques taught in this session. Click here to register.

CPD note – if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances.

Download Materials

Range Names and Macros

Range names rule

When you record a macro that refers to a particular cell or range on a particular sheet in Excel the range reference is hard coded into VBA (macro) code. Unfortunately this means if rows or columns are inserted or deleted in the reference range the code is not updated. There is an easy way to get around this.

Creating a Book Index in Excel

A macro to simplify and speed up the process

My book was published just over four years ago and part of the writing process was creating an Index. To make the task easier I wrote a macro to assist me. Adding an Index to a large document can improve its usefulness. I am sharing the file I used in this blog post.

Stopping the Clipboard from being cleared in Excel VBA

How to check if the clipboard is empty

It is common knowledge (or it should be) that running a macro clears the undo list. In general you can’t undo a macro. However some macros also clear the clipboard which can stop you copying and pasting. I have found a workaround for the clipboard problem.

Thank You Matthew Harris

Recently I learned about the passing of Chip Pearson an Excel legend.

He was so generous with his content and I had thanked him for his contributions years back, but it got me thinking about thanking others who had helped me along the way.

My third thank you goes out to Matthew Harris. Here is a link to his website

Back in the 90’s I taught myself VBA using his book – Teach Yourself Visual Basic For Applications in 21 Days. It has pride of place on my bookshelf.

The book really made a difference to the way I used Excel and opened my eyes to so many possibilities.I found I really enjoyed programming when working in VBA and Excel.

I have learned a lot since, but his book gave me a great grounding in VBA.

Thank you so much Matthew for your book, it has made a huge difference in my life.

Name Box and Macros

I have found out yet another feature of the Name Box.

The Name Box is on the left of the Formula Bar and above the column letters – see image below.

During a recent macro webinar I tried to create a new range name called Test using the Name Box.

But I also has already created a macro called Test as part of the training.

As soon as I pressed Enter after typing Test into the Name Box to create the Test range name, I was magically transported to the VBA window to the Test macro – Wow!

This means you can’t create a range name in the Name Box that is the same as a macro name.

You have to use the Define name icon on the Formulas tab to do that.