VBA Programming for absolute Beginners with Real-Life Projects

Subscribe Now!
New videos every Weekend!

Like what I do? Donate

Did I help you? Did one of my tutorials save you sometime? 

You can say thank you by buying me a cup of coffee, I go through a lot of it.

Help keep Greater Good resources free for everyone. Please donate today. 

This page is not monitored so for questions please comment on the youtube video page. For suggestions email vbaa2z.team@gmail.com

Topics Covered so far

       Sign-up to participate, get assignments and certificates:- https://bit.ly/3eX8tzl 

       Lesson-1: bit.ly/VBAlesson1
       Lesson-2: bit.ly/VBAlesson2
       Lesson-3: bit.ly/VBAlesson3 
       Lesson-4: bit.ly/VBAlesson4 

1. Set up Development Environment. Get familiar with IDE
2. Macro Security. Set up a Trusted Location
3. Excel Objects, Objects Hierarchy
4. Objects Properties, Methods, and Events
5. Various ways to work with Workbook
6. Various ways to work with WorkSheets
7. Various ways to work with Range
8. Read & Write to Cell
9. Loops - Do Until
10. MsgBox()
11. Shortcuts
12. Variables
13. Data Type
14. Operators
15. How to create User-Defined Variables
16. ..Then...Else Statement
17. IIF
18. ..Case Statement
19. Write a Custom Function to Validate prior submission
20. Custom Form / UI
21. UserForm with Tips and Tricks
22. Simple Automation of watermarks for Input fields to guide users
23. Exit sub / End
24. Handling Errors and Trapping Errors
25. WorkSheetFunction
26. Arrays. Static, Dynamic, Single, and Multi-Dimensional Array.
27. Multiple Data type in Array / Defined Data Type with Array. 
28. Working with Excel Table Objects
29. Error Handling
30. Pivot table, Source/Cache Update, Filter Single / Multi items using Array.
31. How to use formula and inbuilt functions in VBA & WorksheetFunction
32. Debugging
33. Trap Errors
34. Break (F9), Local (Alt + v + s), Watch (Shift + F9), Immidiate Window (CTRL + G),
35. Turn off Alerts, ScreenUpdating
36. 
    

    LOOPS

26. For Each Loop
27. For Next Loop, For Next with Steps, Nested Loops
28. Do Until | Do Loop Until
29. Do While | Do Loop While
30. While Wend Loop

 

Projects

1. Submit Data from Form to Sheet within Workbook + Loops
2. Submit Data from Form to External Workbook + Dynamic Range
3. Submit Data from Form to External Workbook + Dynamic Range + Variables + User-Defined Variables
4. Submit Data from UserForm UI to Sheet with Advanced Function + Error Handlers
5. Adding validation using If Else
6. Get Application info
7. Workbook Events
8. Data Convert, to Text or to Numbers
9. Consolidate Data from all Sheets to Master Sheet
10. Loop through all files in folder or DIR
11. Update Pivot Source
12. UserForm UI Project