Excel VBA Archives • Page 3 of 3 • My Online Training Hub

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 Form Data Validation

When creating Excel userforms it seems like a good idea to check the data going into the form before adding

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

March 30, 2015

Pausing or Delaying VBA Using Wait, Sleep or A Loop

You may want some way of pausing or delaying VBA code execution and you can do this with two functions

February 19, 2015

Find Missing Numbers, Really Fast

A while ago I wrote a routine using the .Find method to find missing numbers in a sequence. So if

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

May 20, 2014

Create Hyperlinked List of Files in Subfolders

I wrote a macro a few weeks ago which created a list of files with hyperlinks to those files, but

April 16, 2014

Create Hyperlinked List of Files in a Folder Using VBA

So you have a load of PDF's, or scanned documents, or some nice pictures of your stamp collection*, and you

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 9, 2014

Trusted Locations

If you want Excel to stop asking you if you want to enable macros every time you open a macro

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 Use VBA Code From The Internet

So you’ve found some VBA code on the ‘net that will save you hours and hours of work, but how

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

May 10, 2012

List Sheet Tab Names with Excel VBA

As I promised last week, today’s tutorial is a dead easy macro that will allow you to extract a list