MS Excel Macros (VBA)
For beginners, intermediate and advanced users
You access, compile and analyse business data (accounting, finance, marketing, sales, purchasing, human resources and others) and you develop reports. You are looking for a tool to make things happen more rapidly, to eliminate repetitive and menial tasks and possibly to develop new and more complex reports with Excel.
Your goals are to:
- Level 1: Understand and adapt macros found for free on the Internet.
- Level 2: Develop your own simple macros.
- Level 3: Develop complex budgeting, accounting, pricing applications.
- Level 4: Become a consultant in VBA for Excel
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: Macros Help and Assistance
Lesson 9: Events in VBA for Excel
Lesson 10: Security and Protection in VBA for Excel
Lesson 11: VBA Coding Tips and General Vocabulary
Lesson 12: Working with Errors
Lesson 13: Working with the Application
Lesson 14: Working with Workbooks
Lesson 15: Working with Worksheets
Lesson 16: Ranges, Cells, Rows and Columns
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: Userforms and Controls Properties
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