Excel has not changed much since the 1970's but the computer on your desk has changed dramatically. It is hundreds of times faster and more powerful than 10 years ago. It is also connected to multiple sources of data within your enterprise and connected to data sources from around the world through the Internet.

Due to these changes to your computer and its network, Excel has become limitless as a data analysis and reporting program.

Excel Macros (VBA)
VBA is the programming language used within Excel to develop macros
It stands for Visual Basic for Applications

Up to the 2007 version you do not need to install anything
to be able to develop and use macros  in Excel.

For users of Excel 2007 and newer versions:
Installing the Visual Basic Editor in Excel from your Office CD

This website is divided in three sections:

Beginner

Section 1 - Beginner : Excel Macros Programming: Lessons 1 to 10
This section is about recording, writing, modifying and testing macros in the Visual Basic Editor. You will also learn about security and discover "events" (an event is what starts the macro).

- Lesson 1: Visual Basic Editor in Excel (VBE)
- Lesson 2: Project  Window in the Visual Basic Editor
- Lesson 3: Properties  Window in The Visual Basic Editor
- Lesson 4: Code  Window in the Visual Basic Editor
- Lesson 5: Building Macros in Excel
- Lesson 6: Testing Macros in Excel
- Lesson 7: Macro Recorder in Excel
- Lesson 8: Modifying Macros in Excel
- Lesson 9: Events in VBA for Excel
- Lesson 10: Security and Protection In VBA for Excel

Intermediate

Section 2 - Intermediate : Excel VBA Vocabulary: Lessons 11 to 23
Developing a macro is communicating with Excel and to do so you need to use a language called Visual Basic for Applications (VBA). In section 2 you will learn all the VBA vocabulary that is essential to work with business data (accounting, sales, production and others).

- Lesson 11: Coding Tips
- Lesson 12: Working with Errors
- Lesson 13: Working with the Application
- Lesson 14: Working with Workbooks
- Lesson 15: Working with Worksheets
- Lesson 16: Range and Cells
- Lesson 17: Message Boxes in VBA for Excel
- Lesson 18: Excel VBA Vocabulary to Filter and Sort Data
- Lesson 19: Working with Variables
- Lesson 20: Working with Statements
- Lesson 21: Working with Functions
- Lesson 22: Working with SQL and External Data
- Lesson 23: Working with other programs in VBA for Excel

Advanced

Section 3 - Advanced : Forms and Controls in VBA for Excel: Lessons 24 to 33
The userform is a small or large dialog window that you create and allows the user to submit values that will be used by your macros. To these userforms you will add controls (command buttons, text boxes, list boxes and others) and program them.

- Lesson 24: Userforms in VBA for Excel
- Lesson 25: Userform Properties and VBA Code
- Lesson 26: Labels in VBA for Excel
- Lesson 27: Text Boxes in VBA for Excel
- Lesson 28: Command Button in VBA for Excel
- Lesson 29: Combo Boxes in VBA for Excel
- Lesson 30: List Boxes in VBA for Excel
- Lesson 31: Check Boxes, Frames and Option Buttons
- Lesson 32: Spin Buttons
- Lesson 33: Image Controls