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.
How To Use Excel VBA That Sums Numbers By Color
Oct 16, 2020
Below we will look at a program in Excel VBA that sums numbers by color.
How To Use Relative References In Excel
Oct 16, 2020
By default, Excel records macros in absolute mode. However, sometimes it is useful to record macros in relative mode.
How to Use Tasks on Schedule In Excel VBA
Oct 16, 2020
Below we will look at a program in Excel VBA that sets the background color of tasks that are on schedule to green.
How To Using Excel VBA for Tax Rates
Oct 16, 2020
Below we will look at a program in Excel VBA that calculates the tax on an income.
Variables and Variable Scope In Excel VBA
Oct 16, 2020
The scope of a variable in Excel VBA determines where that variable may be used. You determine the scope of a variable when you declare it.