$show=home

VBA - Operators

VBA - Operators Shout4Education
An Operator can be defined using a simple expression - 4 + 5 is equal to 9. Here, 4 and 5 are called operands and + is called operator. VBA supports following types of operators −
  1. Arithmetic Operators
  2. Comparison Operators
  3. Logical (or Relational) Operators
  4. Concatenation Operators

The Arithmetic Operators

Following arithmetic operators are supported by VBA.
Assume variable A holds 5 and variable B holds 10, then −
OperatorDescriptionExample
+Adds the two operandsA + B will give 15
-Subtracts the second operand from the firstA - B will give -5
*Multiplies both the operandsA * B will give 50
/Divides the numerator by the denominatorB / A will give 2
%Modulus operator and the remainder after an integer divisionB % A will give 0
^Exponentiation operatorB ^ A will give 100000

VBA - Arithmetic Operators

Following arithmetic operators are supported by VBA.
Assume variable A holds 5 and variable B holds 10, then −
OperatorDescriptionExample
+Adds the two operandsA + B will give 15
-Subtracts the second operand from the firstA - B will give -5
*Multiplies both the operandsA * B will give 50
/Divides the numerator by the denominatorB / A will give 2
%Modulus operator and the remainder after an integer divisionB % A will give 0
^Exponentiation operatorB ^ A will give 100000

Example

Add a button and try the following example to understand all the arithmetic operators available in VBA.
Private Sub Constant_demo_Click()
   Dim a As Integer
   a = 5
   
   Dim b As Integer
   b = 10
   
   Dim c As Double
   
   c = a + b
   MsgBox ("Addition Result is " & c)
   
   c = a - b
   MsgBox ("Subtraction Result is " & c)
   
   c = a * b
   MsgBox ("Multiplication Result is " & c)
   
   c = b / a
   MsgBox ("Division Result is " & c)
   
   c = b Mod a
   MsgBox ("Modulus Result is " & c)
   
   c = b ^ a
   MsgBox ("Exponentiation Result is " & c)
End Sub
When you click the button or execute the above script, it will produce the following result.
Addition Result is 15

Subtraction Result is -5

Multiplication Result is 50

Division Result is 2

Modulus Result is 0

Exponentiation Result is 100000

The Comparison Operators

There are following comparison operators supported by VBA.
Assume variable A holds 10 and variable B holds 20, then −
OperatorDescriptionExample
=Checks if the value of the two operands are equal or not. If yes, then the condition is true.(A = B) is False.
<>Checks if the value of the two operands are equal or not. If the values are not equal, then the condition is true.(A <> B) is True.
>Checks if the value of the left operand is greater than the value of the right operand. If yes, then the condition is true.(A > B) is False.
<Checks if the value of the left operand is less than the value of the right operand. If yes, then the condition is true.(A < B) is True.
>=Checks if the value of the left operand is greater than or equal to the value of the right operand. If yes, then the condition is true.(A >= B) is False.
<=Checks if the value of the left operand is less than or equal to the value of the right operand. If yes, then the condition is true.(A <= B) is True.

VBA - Comparison Operators

There are following comparison operators supported by VBA.
Assume variable A holds 10 and variable B holds 20, then −
OperatorDescriptionExample
=Checks if the value of the two operands are equal or not. If yes, then the condition is true.(A = B) is False.
<>Checks if the value of the two operands are equal or not. If the values are not equal, then the condition is true.(A <> B) is True.
>Checks if the value of the left operand is greater than the value of the right operand. If yes, then the condition is true.(A > B) is False.
<Checks if the value of the left operand is less than the value of the right operand. If yes, then the condition is true.(A < B) is True.
>=Checks if the value of the left operand is greater than or equal to the value of the right operand. If yes, then the condition is true.(A >= B) is False.
<=Checks if the value of the left operand is less than or equal to the value of the right operand. If yes, then the condition is true.(A <= B) is True.

Example

Try the following example to understand all the Comparison operators available in VBA.
Private Sub Constant_demo_Click()
   Dim a: a = 10
   Dim b: b = 20
   Dim c

   If a = b Then
      MsgBox ("Operator Line 1 : True")
   Else
      MsgBox ("Operator Line 1 : False")
   End If

   If a<>b Then
      MsgBox ("Operator Line 2 : True")    
   Else
      MsgBox ("Operator Line 2 : False")    
   End If

   If a>b Then
      MsgBox ("Operator Line 3 : True")    
   Else
      MsgBox ("Operator Line 3 : False")    
   End If

   If a<b Then
      MsgBox ("Operator Line 4 : True")    
   Else
      MsgBox ("Operator Line 4 : False")    
   End If

   If a>=b Then
      MsgBox ("Operator Line 5 : True")    
   Else
      MsgBox ("Operator Line 5 : False")    
   End If

   If a<=b Then
      MsgBox ("Operator Line 6 : True")
   Else
      MsgBox ("Operator Line 6 : False")
   End If

End Sub
When you execute the above script, it will produce the following result.
Operator Line 1 : False

Operator Line 2 : True

Operator Line 3 : False

Operator Line 4 : True

Operator Line 5 : False

Operator Line 6 : True

The Logical Operators

Following logical operators are supported by VBA.
Assume variable A holds 10 and variable B holds 0, then −
OperatorDescriptionExample
ANDCalled Logical AND operator. If both the conditions are True, then the Expression is true.a<>0 AND b<>0 is False.
ORCalled Logical OR Operator. If any of the two conditions are True, then the condition is true.a<>0 OR b<>0 is true.
NOTCalled Logical NOT Operator. Used to reverse the logical state of its operand. If a condition is true, then Logical NOT operator will make false.NOT(a<>0 OR b<>0) is false.
XORCalled Logical Exclusion. It is the combination of NOT and OR Operator. If one, and only one, of the expressions evaluates to be True, the result is True.(a<>0 XOR b<>0) is true.

VBA - Logical Operators

Following logical operators are supported by VBA.
Assume variable A holds 10 and variable B holds 0, then −
OperatorDescriptionExample
ANDCalled Logical AND operator. If both the conditions are True, then the Expression is true.a<>0 AND b<>0 is False.
ORCalled Logical OR Operator. If any of the two conditions are True, then the condition is true.a<>0 OR b<>0 is true.
NOTCalled Logical NOT Operator. Used to reverse the logical state of its operand. If a condition is true, then Logical NOT operator will make false.NOT(a<>0 OR b<>0) is false.
XORCalled Logical Exclusion. It is the combination of NOT and OR Operator. If one, and only one, of the expressions evaluates to be True, the result is True.(a<>0 XOR b<>0) is true.

Example

Try the following example to understand all the Logical operators available in VBA by creating a button and adding the following function.
Private Sub Constant_demo_Click()
   Dim a As Integer
   a = 10
   Dim b As Integer
   b = 0
      
   If a <> 0 And b <> 0 Then
      MsgBox ("AND Operator Result is : True")
   Else
      MsgBox ("AND Operator Result is : False")
   End If

   If a <> 0 Or b <> 0 Then
      MsgBox ("OR Operator Result is : True")
   Else
      MsgBox ("OR Operator Result is : False")
   End If

   If Not (a <> 0 Or b <> 0) Then
      MsgBox ("NOT Operator Result is : True")
   Else
      MsgBox ("NOT Operator Result is : False")
   End If

   If (a <> 0 Xor b <> 0) Then
      MsgBox ("XOR Operator Result is : True")
   Else
      MsgBox ("XOR Operator Result is : False")
   End If
End Sub
When you save it as .html and execute it in the Internet Explorer, then the above script will produce the following result.
AND Operator Result is : False

OR Operator Result is : True

NOT Operator Result is : False

XOR Operator Result is : True

The Concatenation Operators

Following Concatenation operators are supported by VBA.
Assume variable A holds 5 and variable B holds 10 then −
OperatorDescriptionExample
+Adds two Values as Variable. Values are NumericA + B will give 15
&Concatenates two ValuesA & B will give 510
Assume variable A = "Microsoft" and variable B = "VBScript", then −
OperatorDescriptionExample
+Concatenates two ValuesA + B will give MicrosoftVBScript
&Concatenates two ValuesA & B will give MicrosoftVBScript
Note − Concatenation Operators can be used for both numbers and strings. The output depends on the context, if the variables hold numeric value or string value.

VBA - Concatenation Operators

Following Concatenation operators are supported by VBA.
Assume variable A holds 5 and variable B holds 10 then −
OperatorDescriptionExample
+Adds two Values as Variable. Values are NumericA + B will give 15
&Concatenates two ValuesA & B will give 510

Example

Try the following example to understand the Concatenation operator available in VBScript −
Private Sub Constant_demo_Click()
   Dim a as Integer : a = 5
   Dim b as Integer : b = 10
   Dim c as Integer

   c = a + b  
   msgbox ("Concatenated value:1 is " &c) 'Numeric addition 
   
   c = a & b 
   msgbox ("Concatenated value:2 is " &c) 'Concatenate two numbers 
End Sub
Try the following example to understand all the Logical operators available in VBA by creating a button and adding the following function.
Concatenated value:1 is 15

Concatenated value:2 is 510
Concatenation can also be used for concatenating two strings. Assume variable A = "Microsoft" and variable B = "VBScript" then −
OperatorDescriptionExample
+Concatenates two ValuesA + B will give MicrosoftVBScript
&Concatenates two ValuesA & B will give MicrosoftVBScript

Example

Try the following example to understand all the Logical operators available in VBA by creating a button and adding the following function.
Private Sub Constant_demo_Click()
   Dim a as String : a = "Microsoft"
   Dim b as String : b = "VBScript"
   Dim c as String

   c = a + b 
   msgbox("Concatenated value:1 is " &c) 'addition of two Strings
   
   c = a & b 
   msgbox("Concatenated value:2 is " &c) 'Concatenate two String
End Sub
When you save it as .html and execute it in the Internet Explorer, then the above script will produce the following result.
Concatenated value:1 is MicrosoftVBScript

Concatenated value:2 is MicrosoftVBScript

Comments

Blogger
Name

.NET_Interview,1,Accenture,1,Accenture News,1,Accenture_GFT,1,Accenture_Prep,1,Advance_Excel,22,Advance_Python,10,Advanced_Linux,6,Advanced_SQL,18,Advanced_Unix,6,AI,1,Alexa,1,Amazon,1,Amazon News,5,AMCAT,1,AMCAT_Prep,1,AMCAT_Solved_Papers,1,Ancient India,5,Android,1,Ansible,2,Apache_Sqoop,10,Aptitude,1,AWS,23,AWS CLI,6,AWS DeepRacer,1,AWS Tutorials,13,AWS_Dumps,1,AWS_Interview,1,AZ-104,1,AZ-900,2,Azure,3,Azure Administrator Associate,1,B_Tech,19,B.Tech,1,B.Tech Jobs,1,Backup,2,Banking Exam,1,Banking_Exam,1,Basic_Linux,29,Basic_Python,19,Basic_SQL,24,Basic_Unix,30,Best_Websites,1,Big_Data_Analytics,70,Blog,447,Blogger,3,Blogging,2,Blogspot,1,Books,2,BTech,20,C++_Interview,1,CBSE,93,Certification,5,Cheat Sheet,2,Civil_1st_Semester,1,Class 11,2,Class 11 Physics,2,Class 12,61,Class 12 Biology,16,Class 12 Chemistry,16,Class 12 English,14,Class 12 Physics,15,Class_12,28,Class_12_Chemistry,4,Class_12_Computer_Science,7,Class_12_Mathematics,1,Class_12_NCERT,15,Class_12_NCERT_Solutions,15,Class_12_Physics,18,Class_12_Physics_NCERT_Solutions,15,Class_12_Science,29,Cloud,2,Cloud_Service,1,CloudFormation,2,Coding,1,Cognizant News,1,Communication,2,Computer,18,Computer_Memory,2,Computer_Programming,2,Computer_Science,4,Control_System,9,Crack_Interview,3,CSE_5th_Semester,1,CSS,1,Data Analyst Jobs,1,Data Science,2,Data Science Interview,1,Data_Analytics,16,Data_Science,18,Data_Science_Interview,1,Database,47,Database Interview,2,Database_Interview,4,DP-900,1,Dumps,2,ECE_1st_Semester,1,ECE_1st_Year,1,ECE_4th_Semester,9,Electrical,2,Electrical_1st_Semester,1,Electronics,2,Electronics & Communication,1,Electronics_&_Communication,14,English,2,Error,1,Ethical Hacking,2,Ethical_Hacking,1,ETL_Tools,17,Exam Dumps,1,Exam Preparation,13,Exam_Cracker,3,Exams,5,Exams_Banking,1,Exams_Prep,1,Excel,22,Excel_Macros,22,Excel_Terms,1,Excel_VBA,22,File System,1,Free_OS,1,Free_Softwares,1,Games,3,GATE,20,GATE EC,1,GATE Electronics & Communication,1,GATE_2019,16,GATE_2020,16,GATE_2021,7,GATE_EC,10,GATE_ECE,9,GATE_ECE_Best_Book,1,GATE_Electrical,1,GATE_Electronics,12,GATE_Made_Easy,1,GATE_ME,6,GATE_Mechanical,6,GGSIPU,1,Google,1,Google Cloud,2,Google News,2,Government Jobs,2,Graphic,1,GRUB,1,Handwritten_Notes,10,Hardware,6,HCL_Prep,1,HDFS,1,Hive,1,Hive Tutorials,1,Hosting,2,How To,15,How_To,8,HR Interview,2,HR Interview Questions,1,HR_Interview,3,Hyderabad_News,1,IBPS,2,IBPS_English,1,IBPS_PO,2,Indian History,5,Informatica,1,Informatica_Interview,1,Information,20,Internet,5,Interview,20,Interview Preparation,5,Interview_Prep,20,IPU,1,ISRO Jobs,1,IT Jobs,4,IT News,1,Java,2,Java Interview,1,Java_Interview,2,Java_Questions_&_answers,1,JavaScript,1,JEE,6,JEE_Mains,6,Job Alert,6,Jobs,1,Kali Linux,1,Kali Linux Tools,1,Katoolin,1,Keyboard,1,Keyboard_Shortcuts,1,Learn_VBA,22,Linux,42,Linux Command,1,Linux Interview,1,Linux Mint,1,Linux Tools,4,Linux Tutorials,1,Linux_Distributions,1,Linux_Interview,1,Linux_Redirections,1,Linux_Scripting,30,Linux_Shell_Arrays,1,Linux_Shell_Functions,1,Linux_Shell_Quote,1,Linux_Signals_And_Traps,1,Logical_Reasoning,1,M.Tech Jobs,1,Machine Learning,1,Machine Learning Interview,1,Machine_Learning,1,Machine_Learning_Interview,1,Macros,22,Manufacturing_Processes,1,ME_1st_Semester,1,ME_Fluid_Mechanics,1,ME_Industrial_Engineering,1,ME_Machine_Design,1,Mechanical,6,Memory,1,Microcontroller,1,Microsoft,5,Microsoft Azure Associate,1,Microsoft Azure Fundamentals,3,Microsoft_Azure,1,Microsoft_Azure_Interview,1,Mobile,1,Mobile News,1,MS_Access,40,MySQL,44,NCERT Solutions,63,Network,2,News,3,Notes,31,OOPs,1,Open_Source_OS,1,OpenTelemetry,1,Operating_Systems,2,Operating_Systems_Interview,1,Oracle,42,Oracle Interview,1,Oracle_Interview,1,Paytm Jobs,1,Physics,2,PL_SQL,42,PL_SQL_Interview,1,Placement,21,Placement Preparation,18,Placement_Prep,24,Poetry,1,Programming,28,Programming_Languages,1,Python,28,Python_Built_In_Strings_Methods,2,Python_built_In_Tuple_Functions,1,Python_CAlling_a_Function,1,Python_CGI,1,Python_Class,1,Python_Data_Types,1,Python_DAte,1,Python_Decision_Making,1,Python_Dictionary,1,Python_DOM_APIs,1,Python_Features,1,Python_Files_Functions,1,Python_For_Loop,1,Python_Functions,6,Python_GUI,1,Python_History,1,Python_If_Else,1,Python_import_Statements,1,Python_Installation,1,Python_Interview,1,Python_JPython,1,Python_Lists,2,Python_Loops,1,Python_Methods,1,Python_Modules,1,Python_MySQL,1,Python_Nested_If_Else,1,Python_Nested_Loops,1,Python_Number_Type_Conversion,1,Python_Numbers,2,Python_Object_Oriented,1,Python_OOP,1,Python_Pass_By_Reference_vs_Value,1,Python_Programming,28,Python_Scripting,28,Python_Special_Operators,1,Python_Strings,2,Python_Strings_Functions,1,Python_Threading_Module,1,Python_Time,1,Python_Tkinter,1,Python_Tuples,2,Python_Tutorial,28,Python_Types_of_Loops,1,Python_Variables,1,Python_Web_Server,1,Python_While_Loop,1,Python_wxPython,1,Python_XML_Processing,1,PythonPath_Setup,1,Quantitative,1,Quantitative_Aptitude,2,RDBMS,1,Run,1,S3,1,Sabrent,1,Samsung,1,SBI Jobs,1,Scripting,52,Scripting Interview,1,Security,1,Server,2,service now,1,Shell_Command_Manual,1,Shell_Logging_Commands,1,Shell_Scripting,31,Shell_Scripting_Interview,1,Software Engineering Interview,1,Software_Engineering_Interview,1,Solutions,1,Spinnaker,1,SQL,46,SQL Interview,1,SQL_Alias_Syntax,1,SQL_Alter_Table_Query,1,SQL_Alter_Table_Statement,1,SQL_AND_OR_Query,1,SQL_AND_OR_Statement,1,SQL_Architecture,1,SQL_Clone_Table,1,SQL_Commands,1,SQL_Conjunctive_Operators,1,SQL_Constraints,1,SQL_Create_Database,1,SQL_Create_Table,1,SQL_DataTypes,1,SQL_Date_Functions,1,SQL_Date_Statement,1,SQL_DCL,1,SQL_Server,39,SQL_Temporary_Table_Statement,1,SQLite,43,Sqoop,9,Sqoop_Tutorial,10,SSC,4,SSC CGL,1,SSC CHSL,1,SSC_CGL,3,SSC_CGL_English,1,SSC_CHSL,1,SSC_CPO,1,SSC_GS,1,SSC_Quantative,1,SSD,1,ssl,1,Storage,1,Talend,17,Talend Interview,1,Talend_ETL,15,Talend_Tutorials,16,TCS Interview,1,TCS Jobs,1,TCS News,1,TCS_Interview,1,TCS_Prep,1,Tech News,15,Tech Tips,18,Teradata_Interview,1,Terraform,2,Tips & Tricks,12,Tips_&_Tricks,18,Top 10,3,Top 50,10,Top_10,1,Top_50,18,Top25,1,Tutorials,165,Tutorials_Python,28,Tutorials_VBA,11,Unix,32,Unix Interview,1,Unix Tutorials,1,Unix_Interview,1,Unix_Scripting,31,UPSC,5,VBA,22,VBA_Basics,22,VBA_Excel,22,VBA_Scripting,22,VBA_Tutorials,22,VirtualBox,1,Visual_Basic_Application,22,VPN,1,Websites,3,Windows,22,WordPress,2,Yarn,1,
ltr
item
Shout4Education - Get Jobs, Tutorials and Notes: VBA - Operators
VBA - Operators
VBA Tutorials ... Best VBA Tutorials only @ Shout4Education ... Learn VBA in an Easy and Simplified Way ... Keep Shouting For Education and Keep Learning ... VBA - Operators Shout4Education An Operator can be defined using a simple expression - 4 + 5 is equal to 9. Here, 4 and 5 are called operands and + is called operator. VBA supports following types of operators − Arithmetic Operators Comparison Operators Logical (or Relational) Operators Concatenation Operators The Arithmetic Operators Following arithmetic operators are supported by VBA. Assume variable A holds 5 and variable B holds 10, then − Operator Description Example + Adds the two operands A + B will give 15 - Subtracts the second operand from the first A - B will give -5 * Multiplies both the operands A * B will give 50 / Divides the numerator by the denominator B / A will give 2 % Modulus operator and the remainder after an integer division B % A will give 0 ^ Exponentiation operator B ^ A will give 100000 VBA - Arithmetic Operators Following arithmetic operators are supported by VBA. Assume variable A holds 5 and variable B holds 10, then − Operator Description Example + Adds the two operands A + B will give 15 - Subtracts the second operand from the first A - B will give -5 * Multiplies both the operands A * B will give 50 / Divides the numerator by the denominator B / A will give 2 % Modulus operator and the remainder after an integer division B % A will give 0 ^ Exponentiation operator B ^ A will give 100000 Example Add a button and try the following example to understand all the arithmetic operators available in VBA. Private Sub Constant_demo_Click() Dim a As Integer a = 5 Dim b As Integer b = 10 Dim c As Double c = a + b MsgBox ("Addition Result is " & c) c = a - b MsgBox ("Subtraction Result is " & c) c = a * b MsgBox ("Multiplication Result is " & c) c = b / a MsgBox ("Division Result is " & c) c = b Mod a MsgBox ("Modulus Result is " & c) c = b ^ a MsgBox ("Exponentiation Result is " & c) End Sub When you click the button or execute the above script, it will produce the following result. Addition Result is 15 Subtraction Result is -5 Multiplication Result is 50 Division Result is 2 Modulus Result is 0 Exponentiation Result is 100000 The Comparison Operators There are following comparison operators supported by VBA. Assume variable A holds 10 and variable B holds 20, then − Operator Description Example = Checks if the value of the two operands are equal or not. If yes, then the condition is true. (A = B) is False. <> Checks if the value of the two operands are equal or not. If the values are not equal, then the condition is true. (A <> B) is True. > Checks if the value of the left operand is greater than the value of the right operand. If yes, then the condition is true. (A > B) is False. < Checks if the value of the left operand is less than the value of the right operand. If yes, then the condition is true. (A < B) is True. >= Checks if the value of the left operand is greater than or equal to the value of the right operand. If yes, then the condition is true. (A >= B) is False. <= Checks if the value of the left operand is less than or equal to the value of the right operand. If yes, then the condition is true. (A <= B) is True. VBA - Comparison Operators There are following comparison operators supported by VBA. Assume variable A holds 10 and variable B holds 20, then − Operator Description Example = Checks if the value of the two operands are equal or not. If yes, then the condition is true. (A = B) is False. <> Checks if the value of the two operands are equal or not. If the values are not equal, then the condition is true. (A <> B) is True. > Checks if the value of the left operand is greater than the value of the right operand. If yes, then the condition is true. (A > B) is False. < Checks if the value of the left operand is less than the value of the right operand. If yes, then the condition is true. (A < B) is True. >= Checks if the value of the left operand is greater than or equal to the value of the right operand. If yes, then the condition is true. (A >= B) is False. <= Checks if the value of the left operand is less than or equal to the value of the right operand. If yes, then the condition is true. (A <= B) is True. Example Try the following example to understand all the Comparison operators available in VBA. Private Sub Constant_demo_Click() Dim a: a = 10 Dim b: b = 20 Dim c If a = b Then MsgBox ("Operator Line 1 : True") Else MsgBox ("Operator Line 1 : False") End If If a<>b Then MsgBox ("Operator Line 2 : True") Else MsgBox ("Operator Line 2 : False") End If If a>b Then MsgBox ("Operator Line 3 : True") Else MsgBox ("Operator Line 3 : False") End If If a=b Then MsgBox ("Operator Line 5 : True") Else MsgBox ("Operator Line 5 : False") End If If a<=b Then MsgBox ("Operator Line 6 : True") Else MsgBox ("Operator Line 6 : False") End If End Sub When you execute the above script, it will produce the following result. Operator Line 1 : False Operator Line 2 : True Operator Line 3 : False Operator Line 4 : True Operator Line 5 : False Operator Line 6 : True The Logical Operators Following logical operators are supported by VBA. Assume variable A holds 10 and variable B holds 0, then − Operator Description Example AND Called Logical AND operator. If both the conditions are True, then the Expression is true. a<>0 AND b<>0 is False. OR Called Logical OR Operator. If any of the two conditions are True, then the condition is true. a<>0 OR b<>0 is true. NOT Called Logical NOT Operator. Used to reverse the logical state of its operand. If a condition is true, then Logical NOT operator will make false. NOT(a<>0 OR b<>0) is false. XOR Called Logical Exclusion. It is the combination of NOT and OR Operator. If one, and only one, of the expressions evaluates to be True, the result is True. (a<>0 XOR b<>0) is true. VBA - Logical Operators Following logical operators are supported by VBA. Assume variable A holds 10 and variable B holds 0, then − Operator Description Example AND Called Logical AND operator. If both the conditions are True, then the Expression is true. a<>0 AND b<>0 is False. OR Called Logical OR Operator. If any of the two conditions are True, then the condition is true. a<>0 OR b<>0 is true. NOT Called Logical NOT Operator. Used to reverse the logical state of its operand. If a condition is true, then Logical NOT operator will make false. NOT(a<>0 OR b<>0) is false. XOR Called Logical Exclusion. It is the combination of NOT and OR Operator. If one, and only one, of the expressions evaluates to be True, the result is True. (a<>0 XOR b<>0) is true. Example Try the following example to understand all the Logical operators available in VBA by creating a button and adding the following function. Private Sub Constant_demo_Click() Dim a As Integer a = 10 Dim b As Integer b = 0 If a <> 0 And b <> 0 Then MsgBox ("AND Operator Result is : True") Else MsgBox ("AND Operator Result is : False") End If If a <> 0 Or b <> 0 Then MsgBox ("OR Operator Result is : True") Else MsgBox ("OR Operator Result is : False") End If If Not (a <> 0 Or b <> 0) Then MsgBox ("NOT Operator Result is : True") Else MsgBox ("NOT Operator Result is : False") End If If (a <> 0 Xor b <> 0) Then MsgBox ("XOR Operator Result is : True") Else MsgBox ("XOR Operator Result is : False") End If End Sub When you save it as .html and execute it in the Internet Explorer, then the above script will produce the following result. AND Operator Result is : False OR Operator Result is : True NOT Operator Result is : False XOR Operator Result is : True The Concatenation Operators Following Concatenation operators are supported by VBA. Assume variable A holds 5 and variable B holds 10 then − Operator Description Example + Adds two Values as Variable. Values are Numeric A + B will give 15 & Concatenates two Values A & B will give 510 Assume variable A = "Microsoft" and variable B = "VBScript", then − Operator Description Example + Concatenates two Values A + B will give MicrosoftVBScript & Concatenates two Values A & B will give MicrosoftVBScript Note − Concatenation Operators can be used for both numbers and strings. The output depends on the context, if the variables hold numeric value or string value. VBA - Concatenation Operators Following Concatenation operators are supported by VBA. Assume variable A holds 5 and variable B holds 10 then − Operator Description Example + Adds two Values as Variable. Values are Numeric A + B will give 15 & Concatenates two Values A & B will give 510 Example Try the following example to understand the Concatenation operator available in VBScript − Private Sub Constant_demo_Click() Dim a as Integer : a = 5 Dim b as Integer : b = 10 Dim c as Integer c = a + b msgbox ("Concatenated value:1 is " &c) 'Numeric addition c = a & b msgbox ("Concatenated value:2 is " &c) 'Concatenate two numbers End Sub Try the following example to understand all the Logical operators available in VBA by creating a button and adding the following function. Concatenated value:1 is 15 Concatenated value:2 is 510 Concatenation can also be used for concatenating two strings. Assume variable A = "Microsoft" and variable B = "VBScript" then − Operator Description Example + Concatenates two Values A + B will give MicrosoftVBScript & Concatenates two Values A & B will give MicrosoftVBScript Example Try the following example to understand all the Logical operators available in VBA by creating a button and adding the following function. Private Sub Constant_demo_Click() Dim a as String : a = "Microsoft" Dim b as String : b = "VBScript" Dim c as String c = a + b msgbox("Concatenated value:1 is " &c) 'addition of two Strings c = a & b msgbox("Concatenated value:2 is " &c) 'Concatenate two String End Sub When you save it as .html and execute it in the Internet Explorer, then the above script will produce the following result. Concatenated value:1 is MicrosoftVBScript Concatenated value:2 is MicrosoftVBScript @ Shout 4 Education , @ Shout For Education
https://1.bp.blogspot.com/-6xBCiWeXIsc/XoZMSCtu_6I/AAAAAAAAA40/L-2muAnBbkEdiOgs7Ja3hJoFd8-3ofuuQCPcBGAYYCw/s640/VBA_Tutorials_Shout4Education.jpg
https://1.bp.blogspot.com/-6xBCiWeXIsc/XoZMSCtu_6I/AAAAAAAAA40/L-2muAnBbkEdiOgs7Ja3hJoFd8-3ofuuQCPcBGAYYCw/s72-c/VBA_Tutorials_Shout4Education.jpg
Shout4Education - Get Jobs, Tutorials and Notes
https://www.shout4education.com/2020/04/vba-operators.html
https://www.shout4education.com/
https://www.shout4education.com/
https://www.shout4education.com/2020/04/vba-operators.html
true
7947974353386595563
UTF-8
Loaded All Posts Not Found Any Posts :( View All Read More Reply Cancel Reply Delete By Home Pages Posts View All Similar Posts Label Archive Search All Posts Not Found Any Post Match with Your Request Sorry !! Search Something Blazing :) Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Just Now 1 Minute Ago $$1$$ minutes ago 1 Hour Ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago More than 5 Weeks Ago Followers Follow :) This Premium Content is LOCKED !!! STEP 1: Share. STEP 2: Click the Link You Shared to Unlock Copy All Code Select All Code All Codes were Copied to Your Clipboard :) Can NOT Copy the Codes / Texts, Please Press [CTRL]+[C] (or CMD+C with Mac) to Copy