A procedure is a group of statements that is called and executed as a unit<\/p>\n
Sub ProcedureName<\/span> () We will put all our statements inside procedures. Note: each time a macro is recorded in Excel a sub procedure is automatically generated in a new module.<\/p>\n A variable is a reference to a location in memory where data is stored. It’s good practice to declare the types of your variables. To do this, use the command<\/p>\n Dim<\/span> variableName As DataType<\/span><\/p>\n A data type categorizes the values that can be assigned to a variable. Most common data types used are:<\/p>\n A constant variable is a variable whose value will never change. To declare a constant, we use<\/p>\n Const <\/span>variable = value<\/p>\n You can declare an array (a variable that contains a vector of values instead of a single value) in a similar way, either hard-coding the number of elements it contains or not. This command creates a single-dimension array with 5 values: note that counting starts from 0:<\/p>\n Dim<\/span> numbers(4) As Integer<\/span><\/p>\n We’ll talk more about arrays on a different page.<\/p>\n +, -, *, \/, ^, mod<\/span><\/p>\n For example, Abs(),\u00a0 Sqrt(), Int(), Exp(), Log()…A more complete list is here<\/a>.<\/p>\n You can use Excel functions in VBA with the Application object and WorksheetFunction method:<\/p>\n Application.WorksheetFunction.Sum<\/span>() The arguments for these functions are the same as when we use them in Excel, but now you can use VBA variables:<\/p>\n
\nstatements
\nEnd Sub<\/p>\n2. Variables<\/h2>\n
\n
3. Math Operations and Functions<\/h2>\n
Arithmetic Operators<\/h3>\n
Math functions<\/h3>\n
Excel functions in VBA<\/h3>\n
\nApplication.WorksheetFunction.Average<\/span>()
\nApplication.WorksheetFunction.VLookup<\/span>()
\nApplication.WorksheetFunction.NormInv<\/span> ()<\/p>\n