VISUAL BASIC (VBA) in Excel

WHAT is VBA? This is the programming language for all Microsoft applications. WORD, POWERPOINT, EXCEL, ACCESS.

I am just going to use part of the definition of Wikipedia for Visual Basic: Visual Basic is a third-generation event-driven programming language and integrated development environment (IDE) from Microsoft for its COM programming model first released in 1991. Microsoft intended Visual Basic to be relatively easy to learn and use. Visual Basic was derived from BASIC and enables the rapid application development of graphical user interface applications, access to databases using Data Access Objects, Remote Data Objects, or ActiveX Data Objects, and creation of ActiveX controls and objects.

Here the main items to remember are:

1) It is EVENT DRIVEN: meaning that an action (event) will trigger a reaction that you programmed. Typically a button press or a cell value change for example can trigger a reaction or a behaviour you have decided to program.

2) It is based on the BASIC language, so it is EASY to learn!! Really Easy. So try.

 

We are going to discuss :

Basics : what can you do with it? Here you will find basic examples of VBA

Buttons have a lot of potential to help you move around the user of your sheet.

Switch from one sheet to another with button

Jump to another area of the same sheet

Scrolling down the sheet with button

Display a Message Box with MsgBox

More in depth : good VBA references.

Add Worksheets, Count Worksheets and workbooks

Excel Workbook hierarchy