Summary
"Sales tax rate" is sSalesTaxRate. Price is just sPrice.
Situation
You need to name some variable names.
Needs
A cell in a worksheet.
Action
The first character or two tell you the data type of the variable.
| Type | Start with | Example | Notes |
|---|---|---|---|
Single |
s |
Dim sGoatWeight As Single |
|
String |
t |
Dim tGoatName As String |
t stands for "text." s is already being used for Single. |
Range |
r |
Dim rGoatData As Range |
After the data type letter, use one or more words. The first character of each word is uppercase, like tGoatEyeColor.
Use names that explain what the variable is. Long names are OK. For example, instead of tGtLn, use tGoatLastName.
Don't forget Ctrl+Space when you're writing code. Type the first few characters of a variable's name, then hit Ctrl+Space. VBE will show you the symbols that start with those characters. Faster, and fewer spelling errors.
Where referenced