How To Sort Birthdays (Dates) In Excel
Oct 17, 2020
Below we will look at a program in Excel VBA that sorts birthdays to months first and days second (so we ignore years).
How To Split Text String At Specific Character In Excel
Oct 17, 2020
Below we will look at a program in Excel VBA that separates strings.
How To Use Excel VBA Select Case
Oct 17, 2020
Instead of multiple If Then statements in Excel VBA, you can use the Select Case structure.
How To Use Resize Property In Excel VBA
Oct 17, 2020
The Resize property in Excel VBA makes a range (border below for illustration only) a specific number of rows and columns larger or smaller.
How To Use Sales Calculator In Excel
Oct 17, 2020
Below we will look at a program in Excel VBA that calculates the total sales of each employee over a period of three years.
How to use spin buttons in Excel VBA
Oct 17, 2020
A spin button can be used to increment a number in a cell. To create a spin button in Excel VBA, execute the following steps.
How to Create User Defined Function In Excel
Oct 16, 2020
Below we will look at a program in Excel VBA that creates a User Defined Function. Excel has a large collection of functions.
Excel VBA - Union And Intersect
Oct 16, 2020
The Union method in Excel VBA returns a Range object that represents the union of two or more ranges (borders below for illustration only).