Introduction to operation

An operator is a character that acts on two operands to give an output.

For example, for example..,

Consider the following expressions:

  1.  A + B = C

Here

A, B and C are called operands

И

+ and = are called operators.

2. C > D

Here

C and D are called operands

И

is called an operator.

Types of operators

Operators are divided into four types.

  1. arithmetic operators
  2. Equation operators
  3. Relational or logical operators
  4. Concentration Operator

Let’s take a look at each of these options – I’ll give you descriptions and many examples along the way.

Arithmetic operators

These operators are mathematical symbols used in calculations. Here is the list of arithmetic operators supported by VBA.

no Operator Description Example
1 + Displays the addition of two operands 4 + 5 equals 9
2 Subtracts the second operand from the first operand 8 – 5 results in 3
3 * Multiplies the two opera scenes on the sides 4 * 6 results in 24
4 / Divide the numerator by the denominator. 9 / 3 gives 3
5 Mod Module operator. This is the net book value after the demerger operation. 10 % 3 gives a memo value of 1 after division.
6 ^ Exposure Operator 10 ^ 3 results in 1000

Example programmes

A program with all the above operators

Sub arith_oper_demo()

Report variables
Dim a, b, c

Assigning values to variables
a = 6
b = 7

Try different calculations and get
‘ Addition operator
c = a + b
Debug.Print Addition: & c

Deduction operator (positive and negative results)
c = b – subtraction
Debug.Print: & c

c = a – b
Subtract from debug printout: & c

Multiplication operator
c = a * b
Debugging, printing Multiplication: & c

division operator
c = a / b
division Debug.Print: & c

Module Operator
c = a Mod b
Debug and print module: & c

Exponentiation
c = a ^ b
Debug.Print Exponentiation: & c

Last Subsection

alt=Using all basic operators as specified in data-orig-width=960 data-orig-height=540 data-ezsrc=http://server.digimetriq.com/wp-content/uploads/2021/02/Your-Guide-to-Using-Operators-in-VBA.png data-ez= />.

alt=pin it! data-ezsrc=/utilcave_com/social/pin_it.png />

alt=Facebook-ezsrc=/utilcave_com/social/fb_share.png />

Calculation of the volume of a sphere

This program takes the radius value as user input, calculates the volume and displays it in the message.

Sub vol_sp()

Variable explanation
Dim Pi, r, vol

Assign values to variables
Pi = 3.14 ‘or (22/7)
r = InputBox( enter the radius of the sphere )

Calculation
ob = (4 / 3) * Pi * (r ^ 3)

Display the calculated volume
MsgBox Volume of the sphere with radius & r & is & full & .

Last Subsection

alt=Volume of a sphere of radius 3 is 113.04 data-orig-width=471 data-orig-height=225 data-ezsrc=http://server.digimetriq.com/wp-content/uploads/2021/02/1614204878_707_Your-Guide-to-Using-Operators-in-VBA.png data-ez= />

alt=pin it! data-ezsrc=/utilcave_com/social/pin_it.png />

alt=Facebook-ezsrc=/utilcave_com/social/fb_share.png />

Comparative operators

These are characters used to compare values. Here is a list of comparison operators provided by VBA that are used for validation in programming.

W/H. Operator Description Example Output
1 = Idem If x = z, then Returns true if the values of the operands ( x and y ) are equal, otherwise it returns false.
2 < Less than If x < z Then If the value of x is less than the value of z, True is returned. Otherwise, he sends it back wrong.
3 > More than If x > z, then If the value of x is greater than the value of z, True is returned. Otherwise, he sends it back wrong.
4 <> Not right away. If x <> z Then If the x value does not match the z value, True is returned. Otherwise, he sends it back wrong.
5 <= Less than or equal to If x <= z Then If the x value is less than or equal to the z value, True is returned. Otherwise, he sends it back wrong.
6 >= Greater than or equal to If x >= z Then If the x value is greater than or equal to the z value, True is returned. Otherwise, he sends it back wrong.

Example programmes

A program that compares the ages of two people

Sub compare_demo()

Declare variables
Dim fath_age, uncl_age

Assign the values
fath_age = InputBox(Enter your father’s age 🙂
uncl_age = InputBox(Enter your uncle’s age 🙂

This compares the ages of your uncle and father
If fath_age > uncl_age Then
MsgBox Your father is older than your uncle.
ElseIf fath_age = uncl_age Then
MsgBox Your father and uncle are the same age.
Else
MsgBox Your uncle is older than your father.
Ends when

Last Subsection

Pre-departure baggage weight check programme

Sub compare_weigh()

Explain variables
Dim allwd_wt, curr_wt

Assign values in kg
allwd_wt = 10
curr_wt = InputBox( Enter the weight of your baggage)

Check if the weight is included in
If curr_wt <= allwd_wt Then
flag = 1
Otherwise
flag = 0
End If

display the appropriate message on the passenger display
If Flag = 1, then
MsgBox The weight of your luggage is within the allowed limit. No further action is required.
Else
MsgBox The weight of your baggage exceeds the allowed limit. Bring some luggage and check it in before you board.
End if
End Sub

The equation in the program above can also be written with the operator more than instead of the operator less than or equal to.

If curr_wt > allwd_wt, then
Flag = 0
Otherwise
Flag = 1
End If

Relational or logical operators

If multiple conditions need to be evaluated, you can use logical operators to see how many different conditions are met.

For example:

Men must be 60 or older to be seniors.

However, women older than 58 are considered elderly. Year of life.

If the program requires a written form to verify eligibility, we must check gender and age to determine whether or not someone is a senior. That’s where the logical operators come in.

The following code snippet uses the two logical operators OR and AND.

If age >= 60 or ( age >= 58 and gender = female ), then
Debug.Print The person is retired.
Other
Debugging.Print Person is not retired.
The end is.

Below are six logical operators that VBA provides.

no Operator Description Example Exit and explanation
1 И This is the logical operator AND. It will come back when conditions on both sides become real again. Len( ABC) = 3 and 5 + 3 = 3 The first condition is true and the second is false. According to the rule of this operator, the final answer is false, even if a condition is returned false.
2 OR This is the logical operator AND. It becomes true again when one of the conditions on either side becomes true again. Len( ABC) = 3 OR (5 + 3) = 3 The first condition is true and the second is false. The rule of this operator is that at least one condition must be true for the final answer to be true. Therefore, the end result is TRUE.
3 PAS This is called the logical operator NOT. It changes the logical state of its operand. If the condition is true, the logical operator does NOT return the opposite value (in this case, the opposite value is false). NOT(Len( ABC) = 3 OR (5 + 3) = 4) The first condition is true and the second is false. The rule of this operator is that at least one condition must be true for the final answer to be true. So the end result is correct. The operator NOT cancels the true answer in FALSE.
4 XOR The XOR operator is called a logical exception. This is a combination of the operators NOT and OR. If only one of the expressions is calculated as true, the result is true. If none of the conditions are true or if more than one condition is true, the XOR operator returns false. Len( ABC) = 3 XOR (5 + 3) = 3 Only one of these conditions is met. Therefore, the end result is TRUE.
5 IS This Boolean operator compares two object variables and returns true only if they store the same object. Workbooks. Worksheets (ABCs) are workbooks. Sheets (DEF). The two worksheets are different and therefore the result will be incorrect.
6 HOW This Boolean operator LIKE allows you to compare two strings to get an inexact match. It can check patterns or strings within another string. string1= I love my country
, if string1 LIKE *love*, then
The condition checks that the string starts with a few characters, contains the word love, and ends with a few characters again. Since these conditions are met, the condition is true.

Example programmes

Use of a similar operator

If Tamil Nadu is in India like Tamil*, then
Debug.Print String starts with expected text
Otherwise
Debug.Print String does not start with expected text
End If

Output

The line begins with the expected text.

Use of the operator NOT

check if the key exists in the dictionary objectIf Not( MyDict.Exists(Class I) ) ThenDebug.Print Does not existEnd if

Using the XORoperator

Sub xor_demo()

Explanation of variables
Dim amt, points

Assign values to the variables
amt = 2000
points = 400

XOR demo – only one condition is met
If number > 200 Xor points > 500 Then
Debug.print (You win the voucher_1)
End if

XOR demo – both conditions are met
If amt > 1500 Xor points > 200 Then
Debug.Print (You win coupon_2)
End If

If the number of points XOR > 6500 Xor > 500 Then
Debug.Print (You win a coupon_3)
End if

Last Subsection

alt=Example XOR data-orig-width=960 data-orig-height=540 data-ezsrc=http://server.digimetriq.com/wp-content/uploads/2021/02/1614204878_213_Your-Guide-to-Using-Operators-in-VBA.png data-ez= />

alt=pin it! data-ezsrc=/utilcave_com/social/pin_it.png />

alt=Facebook-ezsrc=/utilcave_com/social/fb_share.png />

Concentration Operator

These are operators that can merge two expressions.

Message: If both expressions are numbers, they are summed when the + sign is used.

VBA provides the following two operators for concatenation.

no Operator Description
1 + Concentrates two values if one or both is a string. If both are numeric values, they are added together.
2 & Joins two expressions together (connects them).

Program example

Sub concat_demo()

Variable return
Dim str1, str2
Dim num1, num2

Assigning values to variables
str1 = Want to
str2 = Eat cake

Number1 = 32
Number2 = 5

with concatenation operator +
Debug.Print str1 + str2
Debug.Print num1 + num2

with concatenation operator &
Debug.Print str1 & str2
Debug.Print num1 & num2

Last Subsection

alt=Want some cake? data-orig-width=1024 data-orig-height=576 data-ezsrc=http://server.digimetriq.com/wp-content/uploads/2021/02/1614204879_498_Your-Guide-to-Using-Operators-in-VBA.png data-ez= />

alt=pin it! data-ezsrc=/utilcave_com/social/pin_it.png />

alt=Facebook-ezsrc=/utilcave_com/social/fb_share.png />

Completion

These four types of operators are essential to build the logic and redirect the control flow in a program. Many of us stick to the basic operators and can’t remember everything in VBA.

You have to be. B. only do something if a key-value pair is missing from the dictionary object. In this case, we use the keyword Exists to verify existence. However, if this keyword is used in combination with the operator NOT, the number of code lines can be reduced (another code block can be avoided). Depending on the situation, optimal use should be made of these operators.

Marked with: Equation operators, Concentration, Commentary, Logic, Logic operators, Math, NOT, Operand, Operator, Relative operators, XOR

types of operators in visual basic,visual basic operators in hindi,vb net integer operators,divide operator in vb,visual basic logical and,in visual basic “<=” is ________ operator,symbol in vba,vba backslash operator,vba question mark operator,arithmetic operators in vba,what is the output of 5&10&15 in vba,what is the result in vba of expression-10^5,excel vba not equal to blank,not equal vb,excel vba,vba logical operators,vba excel comparison,div visual basic,what is 11 mod 7,vba mod function,what is -11 mod 7,excel mod function,visual basic commands pdf,visual basic commands excel,visual basic command button code,visual basic command words,visual basic functions,visual basic commands dim,Privacy settings,How Search works,vba operators list,arithmetic operators in visual basic,vba comparison operators,operators in visual basic 6.0 pdf,conditional operators in visual basic

You May Also Like

🥇 Upload Videos on Twitch  Step by Step Guide ▷ 2020

Le contenu en ligne est de plus en plus populaire auprès des…

Beginners Guide to Oracle Database 18c Multitenant Architecture – The Geek Diary

The Oracle Database 18c release is here, and it brings some big…

Update Vizio Sound Bar Firmware/Device Software Manually

We have discussed the importance of updating the firmware on your Vizio…

Understanding Oracle Database Quality of Service (QoS) Management – The Geek Diary

How you manage Oracle Database Quality of Service (QoS) will make a…