About Course
Visual Basic for Applications (VBA) is the secret sauce that transforms Excel from a powerful tool into an unstoppable productivity machine. This course is designed to take you from recording your first macro to building advanced applications, enabling you to automate repetitive tasks and create dynamic solutions.
In this course, you’ll not only learn the fundamentals of VBA but also dive deep into debugging, troubleshooting, and creating full-fledged applications. By the end, you’ll have the skills to build tools like a shared expense application in Excel, similar to Splitwise, in the .xlsm format.
If you’re ready to take your Excel skills to the next level and streamline your workflow, this course is for you.
Course Content
VBA Introduction
-
Introduction
03:07
VBA Environment
File Types & Object Model
Object Model
Record a Macro
Object Library & VBA
Special Cells
Absolute vs Relative Reference
Trigger Macro
Delete Comments
Reference Cells
Most used Properties
use of Range Properties
Copy & Resize Properties
Reference Worksheets
Reference Workbook
Range Test
What is Variables
Object Variables
Saving Workbook with Variables
With Block
For Each Loop Collections
Simple IF
IF and OR Clause
Nested If Clause
VBA Functions & Exit Sub
MsgBox
VBA Input Box
Excel Input Box
Debugging the Code
Error Handling
Calling Procedures
For Loop
For Nested Loop
Do While Loop
Working with DIR & Folders
GetOpenFileName
FileDialog Loop
Workbook Events
Worksheet Event
User Forms
Project Expense Sharing
Student Ratings & Reviews
No Review Yet
