VBA – Operators
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 …
Shout4Education
VBA – Constants
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 …
VBA – Variables
Variable is a named memory location used to hold a value that can be changed during the script execution. Following are the basic rules for naming …
VBA – InputBox
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 …
VBA – Message Box
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 …
VBA – Macro Comments
Comments are used to document the program logic and the user information with which other programmers can seamlessly work on the same code in future. …
VBA – Excel Terms
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 …
