|| | Novice | || | Beginner | || | Intermediate | || | Advanced | || | Specialist | || | Expert | || |
VBA stands for Visual Basic for Applications . It is also called Excel Macros
VBA enables writing Code to automate repeated activities and helps reduce time and manual effort

Visual Basic Editor consists of three parts Projects Window , Properties Window and Code Window
Warning comments
Shortcut
Developer Option in the Ribbon Click for more >>


Developer Option in the Ribbon Click for more >>
Record Macro is a very useful and powerful tool in VBA. This helps in recording keystrokes which
can be pasted into a VBA code , you may also modify the Code to delivery customized results
Shortcut
[Alt]+T+M+R Click for more >> Enable Macros

[Alt]+T+M+R Click for more >> Enable Macros
Variables are used to store data , they are basic classified into Numeric and Non Numeric
Numeric data has multiple sub types like Integer, Double , Currency etc.. each taking its own defined storage space
Non Numeric data has Text, date etc.. It could be a one character or combination known as string , Date etc..each taking its own defined storage space
Click for more >>
Click for more >>
A Well structured VBA code is essential to easily make modifications in future and
helps in re-usuability of the code
Standard code follows the flow of Define Variables, collect inputs , process the data and output the values
Details on Structure of VBA
Click for more >>
Standard code follows the flow of Define Variables, collect inputs , process the data and output the values
Details on Structure of VBA
Click for more >>
VBA code plays between the input recieved and the output delivered
Warning comments
Shortcut
Write Details on Input box and message box Inputbox
Msgbox
Click for more >>


Write Details on Input box and message box Inputbox
Msgbox
Click for more >>
Loops are useful for repeating a action multiple times The No.of.Iterations can be fixed or condition based

Click for more >>