Share via

Visual Basic for Applications Reference

  • Article

+ Operator Example

This example uses the + operator to sum numbers. The + operator can also be used to concatenate strings. However, to eliminate ambiguity, you should use the & operator instead. If the components of an expression created with the + operator include both strings and numerics, the arithmetic result is assigned. If the components are exclusively strings, the strings are concatenated.

  Dim MyNumber, Var1, Var2
MyNumber = 2 + 2   ' Returns 4.
MyNumber = 4257.04 + 98112   ' Returns 102369.04.

Var1 = "34": Var2 = 6   ' Initialize mixed variables.
MyNumber = Var1 + Var2   ' Returns 40.

Var1 = "34": Var2 = "6"   ' Initialize variables with strings.
MyNumber = Var1 + Var2   ' Returns "346" (string concatenation).