Exceltechie.com

Easiest way to learn excel on the planet
Facebook-exceltechie Twitter-exceltechie Linkedin-exceltechie
|| 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


Shortcut ALT + F11

Visual Basic Editor consists of three parts Projects Window , Properties Window and Code Window
Warning Warning comments

Shortcut Shortcut
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 Shortcut
[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 >>
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 >>
VBA code plays between the input recieved and the output delivered

Warning Warning comments

Shortcut Shortcut

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

Warning Loops should have a definite end

Click for more >>
We have a repository of Excel VBA codes to help you

Click for more >>