Introduction
Save time with Excel macros and VBA
(00:45)
1. Understand Macros and VBA
What is an Excel macro?
(01:57)
2. Record a Macro
Enabling the Developer tab to expose VBA tools
(01:28)
Recording your first macro
(03:00)
Assign a macro to a button
(01:51)
3. Edit the Macro
Introduction to Visual Basic (VBA)
(02:57)
Reading your recorded code
(03:24)
Testing recorded macros
(04:48)
Adjusting recorded macros
(02:29)
Making recorded macros dynamic
(07:34)
Rules of thumb for testing
(03:30)
How to step through code when testing
(03:25)
Conclusion
Next steps
(00:31)
Ex_Files_Excel_Macros_VBA.zip
(2.0 MB)