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

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

October 26, 2017

Excel 4.0 Macro Functions

Before VBA there were XLM macros. VBA was introduced in Excel version 5, so these Excel macros are also known

September 15, 2017

VBA Shell

The VBA Shell function runs a command in the operating system shell. The shell refers to the interface, typically where

August 10, 2017

VBA SELECT CASE

VBA SELECT CASE allows you to test an expression against multiple conditions, and then carry out a series of commands

August 3, 2017

VBA IF THEN ELSE

The VBA IF THEN ELSE statement lets you test a condition, and then carry out other commands if the test

June 21, 2017

List Files in a Folder Using FILES XL Macro (XLM)

Way back, when Excel 4.0 was around, it used a macro language called XLM. VBA was introduced in Excel 5.0.

May 12, 2017

More Tips for Debugging VBA

After my last post on debugging VBA I received a few comments with other tips or commands people use for

May 4, 2017

Debugging VBA Code

When you write VBA, or any programming language, you are going to encounter errors in it, or should we call

March 10, 2017

Excel VBA String Functions

If you are working with strings (a sequence of letters, numbers or other characters) in VBA then you are going

January 31, 2017

Return An Array From A UDF

This post is going to look at how to return an array from a udf. My last post looked at

January 24, 2017

Return a Range from a UDF

I've previously written a UDF to count colored cells and then perform various maths functions on the values in those

November 25, 2016

Count, Sum and Average Colored Cells

We often get asked if we can count colored cells on a worksheet, and yes you can. You could count

November 11, 2016

Create an Excel Add-In for User Defined Functions (UDF’s)

In a previous post I discussed storing your UDF's in PERSONAL.XLSB so that you could use them in any workbook.

creating a reference to personal.xlsb for user defined function udf

October 27, 2016

Creating a Reference to PERSONAL.XLSB for User Defined Functions (UDF’s)

You've created your own PERSONAL.XLSB and want to use it to store VBA that you are going to use all

September 21, 2016

Creating Multi-Function UDF’s

My last post looked at creating a simple user defined function (UDF). This post looks at a little more advanced

September 15, 2016

Creating a UDF (User Defined Function) in Excel

Any user of Excel will have used its functions. From the humble SUM to VLOOKUP, INDEX and MATCH, OFFSET and

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.

July 28, 2016

Moving VBA Code and Forms Into PERSONAL.XLSB

After you’ve written some VBA, or created your own form, or you’ve found some useful code on the internet, you

Hide, Delete, Sort Sheets with VBA in Excel

July 21, 2016

Hide, Delete and Sort Sheets With VBA Userform

You have a workbook with lots of sheets and you want to do things like hide sheets, delete some sheets

June 30, 2016

How to Record a Macro in Excel

Prompted by a couple of questions on our Excel forum I thought I'd write about how to record a macro

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

April 27, 2016

Maximize Excel Across Multiple Screens

If you want to maximise Excel on a single monitor you can just click on the maximize button That's ok

show text, numbers, dates, formulas on sheet

April 6, 2016

Highlight Text, Numbers, Dates and Formulas on a Sheet

Imagine that you are preparing data for a pivot table, and you want to make sure that all the cells

March 15, 2016

Get Started With VBA – 3 Easy Examples

You can create very complicated and powerful VBA routines in Excel, but not all VBA code has to be like

selecting multiple items in data validation list

March 3, 2016

Populating Multiple Cells from Single Data Validation (Drop Down) List

If you want to limit the choices available for the values that can be entered into a cell, you could

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

October 1, 2015

Save Settings in Registry Using Excel

If you want to save data from one Excel session to another, you can store this in the Windows registry.

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