MS Excel VBA Stands for
VBA (Visual Basic for Applications) is a language related to Visual Basic that can only run through a host application (Excel, in our case). Using VBA, we can do almost anything imaginable with Excel.
This Excel VBA Tutorial aims to introduce you to the basics of the Excel Visual Basic programming language. If you can master VBA programming, you can perform virtually any task you wish in your Excel file. You can produce macros that will interact with your users, perform automated responses to mouse clicks or other user actions, and save hours of time by performing a hundreds of actions within a few seconds – all at the click of a button!
While this tutorial is by no means a comprehensive index of all Visual Basic Excel commands and functionality, it should assist the beginner in getting started with writing Excel Macros, using VBA code. If you want to study Excel VBA programming in more depth, there are some excellent books available on the subject. Click on the following links to view each stage of the Excel Visual Basic tutorial. It is advised that complete beginners start at the beginning and work through all stages of the tutorial, although those with some previous experience of VBA programming may want to dip into specific pages.
Visible Developer Tab
But before we get started, let’s begin by making sure that the tools we need are visible.
If you are using Excel version 2007 (or a higher version), click on
File > Options > Customize the Ribbon and then check “Developer”.
A new tab will be added :
Content of VBA Tutorials
Module 7.1 : Getting Started With VBA
Module 7.2 : Variables
Module 7.3 : Conditional Logic
Module 7.4 : Strings and String Functions
Module 7.5 : Programming Loops
Module 7.6 : Programming Arrays
Module 7.7 : Subs and Functions
Module 7.8 : Text File in VBA
Module 7.9 : Excel User Forms
Module 7.10 : VBA Picture Viewer Project
Module 7.11 : VBA Simple Calculator Project
Module 7.12 : Excel VBA Recap
Module 7.13 : VBA Exercise with Projects