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).
How To Insert A Text Box In Excel
Oct 16, 2020
A text box is an empty field where a user can fill in a piece of text.
How To Quickly Swap Values In Excel
Oct 16, 2020
This example teaches you how to swap two values in Excel VBA.
How To Test A Selection In Excel With VBA
Oct 16, 2020
This program in Excel VBA uses the Count property, IsNumeric function, IsEmpty function and Intersect method to test a selection.