Dive into advanced Excel VBA programming with this comprehensive tutorial designed for Business Analysts, Data Scientists, and Excel power users. Master the art of automating repetitive processes and creating custom tools using Visual Basic for Applications (VBA). Learn to build macros from scratch, starting with simple recorded macros and progressing to complex functions using loops, conditional statements, and advanced VBA concepts. Explore topics such as variables, For Next loops, Do While loops, Exit For statements, Count and Offset functions, message boxes, input boxes, and Select Case statements. Practice your skills with hands-on exercises and discover how to leverage the FIND tool in macros. By the end of this nearly two-hour tutorial, you'll be equipped to write your own rulebook on what's possible in Excel using VBA.
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
