VBA Operators VBA uses a handful of simple operators and relations, the most common of which are shown in Table 5-5 . Table 5-5. VBA Operators and Relations Type Name Symbol Arithmetic Operators Addition + Subtraction - Multiplication * Division / Division with Integer result \ Exponentiation ^ Modulo Mod String Operator Concatenation & Logical Operators AND And OR Or NOT Not Comparison Relations Equal = Less than < Greater than > Less than or equal to <= or =< Greater than or equal to >= or => Not equal to <> or >< The Mod operator returns the remainder after division. For example: 8 Mod 3 returns 2, since the remainder after dividing 8 by 3 is 2. To illustrate string concatenation, the expression: "To be or " & "not to be" is equivalent to: "To be or not to be"
We'll provide you everything! Thanks for being here!