Master Microsoft Excel Macros and VBA with 6 Simple Projects

2. Understanding the Why and How Behind Excel Macros

3. Introduction to Project #1: Inserting and Formatting Text

4. Project #1: Start Recording!

5. Project #1: Running a Macro with a Button

6. Project #1: Opps! I Need to Edit My Macro

7. Project #1: Practical Uses of Excel Macros

8. Excel VBA Concepts

9. The Visual Basic Editor

10. Excel VBA Modules

11. Creating Excel VBA Procedures

12. Understanding Excel VBA Variables

13. Working with Excel VBA Loops to Repeat Blocks of Code

14. Building Logic with an IF Statement

15. Project #2: Intro to Interacting with the User

16. Project #2: Breaking Down the VBA Code

17. Project #2: Prompting the User for Information

18. Project #2: Alerting the User of Errors

19. Project #2: Other Practical Uses of Messages Boxes and Input Boxes

20. Project #3: Intro to Cleaning and Formatting Data

21. Project #3: Using the Macro Recorder to Lay the Foundation

22. Project #3: Preparing to Use to the Macro Recorder

23. Project #3: Inserting Headers

24. Project #3: Formatting Headers

25. Project #3: Putting it All Together with a Little VBA Magic

26. Project #4: Automate Microsoft Excel Formulas

27. Project #4: Automate the SUM Function through Code

28. Project #4: Loop the SUM Function Over Multiple Worksheets

29. Project #5: Creating the Final Report

30. Project #5: Putting it all Togehter to Create the Final Report

31. Project #6: Working with Excel VBA Forms

32. Project #6: Creating an Excel VBA Form

33. Project #6: Adding Controls to the Form

34. Project #6: Changing Control and Form Properties

35. Project #6: Adding VBA Code to the Intialize Event

36. Project #6: Adding VBA Code to the ComboBox Change Event

37. Project #6: Adding VBA Code to the Add Worksheet Button

38. Project #6: Adding VBA Code to the Create Report Button

39. Project #6: Showing the Form

40. Congratulations