Declaring constants
If a variable is a line of VBA coding with the purpose of storing information on a temporary basis, a constant is a line of coding that stores information on a permanent basis.
Let's work with a practical example again.
Doing calculations in Excel is easy; you use a function or a formula and the problem is solved. But let's say you have to calculate the tax for products sold in a store on a daily basis. The data is not only on one spreadsheet, and people often randomly ask you to do these tax calculations.
As simple as it is to add a short formula, this is a waste of time. If you could click on a button with a macro assigned to it to do the calculation for you automatically, it would make your life much easier.
The tax rate can be stored as a permanent value in a constant and, depending on the VBA code, you can click on a cell and run the macro to calculate the tax for that specific item.
Getting ready
Open Excel and make sure that...