Dive into an intermediate-level Excel VBA tutorial designed for Business Analysts, Data Scientists, and Excel enthusiasts looking to expand their automation capabilities. Learn to build macros from scratch, starting with simple recorded macros and progressing to complex functions using VBA concepts such as loops, conditional statements, and advanced Excel features. Master variables, For Next loops, Do While loops, Exit For statements, and the FIND tool in macros. Explore message boxes, input boxes, code continuation characters, and multiple variable handling. Practice your skills with hands-on exercises throughout the course, culminating in a final project to solidify your understanding of intermediate Excel VBA programming.
Overview
Syllabus
Start
Variables
Variable Rules
For Next Loop Basics
For Next Loop Doubled
For Next Loop Triple
For Each Loop
Exit For Statement
Do While Loop
Do While Not Empty Loop
Do Until Loop
Do Loop UNTIL
Count and Offset
End, Address, Call Statement
Practice
Using the FIND Tool in a Macro
Message Boxes
Input Boxes
Code Continuation Character and vbCrLf Constant
If Then, ElseIF, and Else
Select Case
Multiple Variables
Practice
Taught by
Learnit Training
