VBA

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…

Following logical operators are supported by VBA. Assume variable A holds 10 and variable B holds 0, then − OperatorDescriptionExampleANDCalled Logical AND operator. If both the conditions are True, then…

There are the 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…

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…

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 the following types of…

Constant is a named memory location used to hold a value that CANNOT be changed during the script execution. If a user tries to change a Constant value, the script…

Variables are a named memory location used to hold a value that can be changed during the script execution. Following are the basic rules for naming a variable. You must use…

The InputBox function prompts the users to enter values. After entering the values, if the user clicks the OK button or presses ENTER on the keyboard, the InputBox function will return the…

The MsgBox function displays a message box and waits for the user to click a button and then an action is performed based on the button clicked by the user. Syntax MsgBox(prompt[,buttons][,title][,helpfile,context])…

In this chapter, you will acquaint yourself with the commonly used excel VBA terminologies. These terminologies will be used in further modules, hence understanding each one of these is important.…