VBA

Hi Pamela

Variables are names used to represent values that may change during the procedure and identify a unique location in memory.

As a basic yardstick any time you ask the user to input any data or to select an option this should be stored in a variable.

Anothere use of variables is to store results of calculations.

The syntax is Dim/Public/Private VariableName [As type]. eg:

Dim Reply As Byte

Hope this helps

Carlos