Hungarian variable names


"Sales tax rate" is sSalesTaxRate. Price is just sPrice.


You need to name some variable names.


A cell in a worksheet.


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