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

Learn the basics for FREE on this website

Discover how powerful macros are
Disover how easy and how much fun it can be to learn about them

Up to the 2007 version you did 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

- 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

- 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

- 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