{"id":2873,"date":"2017-10-11T00:26:00","date_gmt":"2017-10-11T00:26:00","guid":{"rendered":"http:\/\/excelvbatutor.com\/?page_id=2873"},"modified":"2020-04-23T11:00:35","modified_gmt":"2020-04-23T11:00:35","slug":"excel-vba-lesson-4-operators-in-excel-vba","status":"publish","type":"page","link":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-lesson-4-operators-in-excel-vba\/","title":{"rendered":"Excel VBA Lesson 4: Operators in Excel VBA"},"content":{"rendered":"

<<Lesson 3>><\/a> [Contents] <\/a><<Lesson 5>><\/a><\/strong><\/h4>\n

The Operators are important in writing Excel VBA program code. They are used to calculate values, perform certain operations, make comparisons and more. The operators can be divided into three main categories:<\/p>\n

    \n
  • Arithmetic<\/li>\n
  • Comparison<\/li>\n
  • Logical<\/li>\n<\/ul>\n

    4.1 Arithmetic Operators<\/h3>\n

    Arithmetic operators are used to perform mathematical operations in Excel VBA.<\/p>\n

    Table 4.1 Arithmetic Operators<\/h3>\n\n\n\n\n\n\n\n\n\n
    Operator<\/strong><\/th>\nMathematical function<\/strong><\/th>\nExample<\/strong><\/th>\n<\/tr>\n
    \n

    ^<\/p>\n<\/td>\n

    		Exponential<\/td>\nMsgBox 2^4 gives a value of 16<\/td>\n<\/tr>\n
    \n

    *<\/p>\n<\/td>\n

    		Multiplication<\/td>\nMsgBox 4*3 gives a value of 12,<\/td>\n<\/tr>\n
    \n

    \/<\/p>\n<\/td>\n

    		Division<\/td>\nMsgBox 12\/4 gives a value of 3<\/td>\n<\/tr>\n
    \n

    Mod<\/p>\n<\/td>\n

    		Modulus (returns the remainder from an integer division)<\/td>\nMsgBox 15 Mod 4 gives value of 3<\/td>\n<\/tr>\n
    \n

    \\<\/p>\n<\/td>\n

    		Integer Division(discards the decimal places)<\/td>\nMsgBox 19\\4 gives a value of 4<\/td>\n<\/tr>\n
    \n

    + or &<\/p>\n<\/td>\n

    		String concatenation<\/td>\nMsgBox “Excel”&”VBA 2010” or “Excel”+”VBA 2010” produces a new string “Excel VBA 2010”<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n