Excel VBA Archives • My Online Training Hub

October 30, 2019

Checking Values in Range Objects With VBA

One thing I often found frustrating with VBA is the lack of any easy way to see the values in

April 4, 2019

Static Variables in VBA

Normally variables cease to exist once your Sub or Function has finished executing. Static variables allow you to preserve a

November 30, 2018

Save Chart as Image

You might want to save your charts as images that can then be used in other applications, like email or

Clearing Downstream Dependent Data Validation Lists

August 25, 2016

Clear Downstream Dependent Data Validation Lists

Following on from Mynda's post last week on Dependent Data Validation, I've written a little VBA that enhances the functionality.

June 15, 2016

Excel Status Bar

In my previous blog post I created a progress bar using a userform. We can use this progress bar to

June 9, 2016

Excel Progress Bar for VBA

If your code runs for any noticeable amount of time, you might find that using some sort of visual feedback

December 4, 2015

Error Handling in VBA

If VBA can’t execute a statement (command) then a run-time error occurs. By default Excel deals with these, so when

November 6, 2015

Finding File Meta Data Using FileSystemObject

In a previous post I looked at using the FileSystemObject to search through folders on your computer's disk and create

September 25, 2015

Automatically Add Items to Data Validation List

If you are using data validation (and you should) to help you with your data entry, then you might find

September 11, 2015

Excel End of Period Dates

“Funny” days versus funny “Days” Guest post by Roger Govier, Microsoft Excel MVP Do you ever have “Funny” days? You

September 4, 2015

Add Data to Combo Box Drop Down List in Excel Form

If you've been following the previous posts in this series you'll know that by now we have a user form

Excel forms, insert, update, delete data

August 21, 2015

Excel Forms – Insert, Update and Delete

Carrying on with the Excel form I created in an earlier post, I’m adding code to allow us to insert

July 9, 2015

Excel Date Picker

In my previous post about Excel forms the date picker I used was a 32 bit ActiveX control. If mentioning

July 2, 2015

Excel Forms

Excel forms, or Userforms, can be used to collect information from a user, validate it, then enter that data into

Highlight Selected Cell In Excel and Preserve Cell Format

May 20, 2015

Highlight Selected Cells in Excel and Preserve Cell Formatting

When you select a cell, or cells, in Excel, the row and column headers change color to indicate what you

November 19, 2014

Workbook & Worksheet Events in Excel VBA

What Are Events? An Event occurs when certain actions are performed by the user or VBA. For example when you

September 23, 2014

Change the Color of Words in Text

One of our students (hi Leah 🙂 ) sent me a question last week asking how she could change the

June 18, 2014

Protect and Unprotect All Sheets in a Workbook

I recently had a client who has a requirement to protect and unprotect a lot of sheets. This was something

June 18, 2014

Customize the Ribbon in Excel

You can customize the Ribbon in Excel so that you add your own tabs and icons to run commonly used

April 9, 2014

Macro Enabled Excel Templates

What You Can Do With Macro Enabled Templates This is up to you. Using a template allows you to design

April 1, 2014

Unhide Multiple Worksheets in Excel

I’m sure most of us have experienced frustration at Excel’s refusal to allow us to unhide multiple worksheets. This is

April 1, 2014

Create a Personal Macro Workbook PERSONAL.XLSB

When you create a macro in Excel, by default, the macro works only in the workbook that contains it. But

February 27, 2014

Create Barcodes With (Or Without) Excel VBA

Barcode Types & Uses There are LOTS of barcode types used for a multitude of things. Various internationally recognised standards

February 7, 2014

Convert Numbers (Currency) to Words With Excel VBA

We get requests now and again asking how to convert numbers to words (or convert currency) e.g. 123.45 becomes One

December 11, 2013

Assign a Macro to a Shape or Use a Shortcut Sequence

So you’ve got some code and you want to be able to run it, but opening up the list of

November 27, 2013

How To Enable the Developer Tab in Excel

The Developer tab in Excel gives you access to features and tools that help you to write and run macros.

October 14, 2013

VBA to Create PDF from Excel Worksheet Then Email It With Outlook

Real World Scenario One of my customers (thanks Tony) creates invoices in Excel for his clients and at the end

October 1, 2013

Merge Excel Worksheets with VBA

The Scenario Let’s say that you have a lot of sheets in your workbook and you want to merge all

September 11, 2013

Finding Missing Numbers in a Range Using VBA

The Problem You have a sequence of numbers, and you want to find the numbers that are missing from that

August 3, 2012

Excel Factor 8 Highlight Cells Containing Formulas

This Excel Factor tip was sent in by Shannon Hommel of the UK. If you’re setting up a template or