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 …
Excel Macros
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 …
VBA – Excel Macros
In this chapter, you will learn how to write a simple macro in a step by step manner. Step 1 − First, enable ‘Developer’ menu in …
