Excel VBA Archives • My Online Training Hub

June 20, 2023

Center Across Selection Macro

Annoyingly, there’s a shortcut for Merge & Center on the Ribbon, but nothing for Center Across Selection which is far

August 20, 2020

Display All Matches from Search in Userform ListBox

I've previously described how to use a form to search for a distinct value, like a unique ID. This time

July 3, 2020

Animating Excel Charts

If you are going to use animation in your charts, you should do it to enhance the story your data

June 4, 2020

Dynamic Data Validation Lists in Userforms

Let's say we need to assign staff to work different shifts and no person can work both early and late

May 27, 2020

Show Report Filter Pages for Power Pivot PivotTables

If you are using a filter on a 'regular' pivot table (one that isn't using source data from Power Pivot),

May 8, 2020

Charting Real Time Data in Excel

I've previously written about getting real time data (RTD) into Excel using Python. In this post I'm going to chart

April 20, 2020

Select Multiple Items from Drop Down (Data Validation) List

Data validation lists will only let you choose one item from the list. But what if we have a situation

Excel Calendar (Date Picker) to Use in Worksheets and Userforms

March 18, 2020

Multi-Language Excel Calendar (Date Picker) for Worksheets and Userforms

I've written about using calendars/date pickers in userforms before but this one is particularly easy and flexible to use, even

March 11, 2020

Automating and Emailing Pivot Table Reports

Here's the scenario: I want to send different pages of my pivot table report to different email recipients. I can

January 28, 2020

Searching for Data With a User Form

I was recently asked to provide the ability to search a list of records (like a table) using a user

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

August 1, 2019

Working With Comments in VBA

To start with let's understand that I'm talking about the 'old' style comments like the one on the left. In

July 2, 2019

Custom Data Types in VBA

If you are working with several variables that relate to one thing, for example you are working with employee data,

May 30, 2019

Web Scraping – Filling in Forms

I've written about web scraping before using VBA, but never about interacting with the website to do things like filling

April 10, 2019

Find and Unmerge Merged Cells with VBA

If you've worked with merged cells you may know that they can cause issues with things like copying and pasting,

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

March 1, 2019

Scheduling Macros in Excel With Application.OnTime

If you need Excel to run some VBA at a specific time, or repeatedly at set intervals, you can use

February 22, 2019

RegEx (Regular Expressions) in Excel

RegEx stands for regular expression and is a sequence of characters that defines a pattern that can be used to

January 15, 2019

VBA Like Operator

The VBA Like operator allows you to compare strings against a pattern. You can search a string to check if

December 13, 2018

Play Audio and Video in Excel

We've had a few forum questions recently asking how to play audio files in Excel. Normally I'd just use my

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

November 22, 2018

Quickly Formatting Markers for Dot Plots

Mynda wrote a post about line charts vs dot plots where one of the steps in setting up the dot

October 24, 2018

Web Scraping Multiple Pages from Websites

My last post looked at web scraping using VBA, where I loaded a single page and extracted content. In this

October 17, 2018

Web Scraping With VBA

We can use VBA to retrieve webpages and comb through those pages for data we want. This is known as

September 19, 2018

Remove Formatting from a Table

Let's say you have a range that you want to convert to a table Something like this that has fills,

September 11, 2018

Listing and Deleting Custom Styles

If you end up with a workbook that contains custom styles, removing all of these may be a pain depending

calling vba in an add-in from another vba module

July 3, 2018

Calling VBA in an Add-In From Other VBA Modules

If you've written subs or functions in your own add-in, you can use them in your worksheet as you would

April 19, 2018

Timer or Stopwatch in Excel VBA

We had a post on the forum recently asking how to create a timer in Excel, to record how long

April 13, 2018

Volatile User Defined Functions

Excel has the concept of volatile and non-volatile functions. Microsoft define a volatile function as one that is recalculated every

November 24, 2017

Writing UDFs in Excel With Python

My last post looked at using Python to plot equations in Excel with DataNitro. In this one I want to