Introduction
Dive into using VBA in Excel
(00:26)
What you should know
(01:26)
1. Visual Basic for Applications
Introduce object-oriented programming
(02:28)
Examine the Excel object model
(04:44)
Work in the Visual Basic Editor
(05:55)
Set VBA project properties
(03:55)
Create, export, and delete code modules
(04:48)
Create a subroutine
(04:44)
Create a function
(04:57)
Add comments to your code
(03:00)
Run a VBA routine
(06:08)
Add code to a recorded macro
(03:41)
2. Defining Variables, Constants, and Calculations
Introduce Excel VBA data types
(05:18)
Declare variables and require declaration before use
(05:00)
Manage variable scope
(03:54)
Define static variables and constants
(04:26)
Create a calculation using mathematical operators
(04:32)
Define arrays
(06:00)
Define and use object variables
(03:29)
Streamline code references using With…End With statements
(04:06)
3. Adding Logic to Your VBA Code
Repeat a task using a For...Next loop
(03:37)
Step through all items of a collection using a For...Each loop
(03:27)
Repeat a task using a Do loop
(05:04)
Perform a task when conditions are met using an If...Then statement
(05:12)
Select which action to take using a Case statement
(03:09)
4. Debugging Your VBA Code
Manage errors using On Error statements
(06:10)
Step through a subroutine or function
(06:03)
Set breakpoints in your code
(03:32)
Verify output using the Immediate window
(05:41)
Watch a value in a routine
(03:30)
5. Managing Workbook Elements and Data in VBA
Write a value to a cell
(04:09)
Cut, copy, and paste cell data
(05:06)
Find values in cells
(04:35)
Refer to cells using the OFFSET function
(03:31)
Concatenate text strings
(05:07)
Return part of a string
(03:57)
Manage worksheets with VBA
(07:00)
Manage workbooks with VBA
(05:07)
6. Adding Advanced Elements to Your Workbook
Turn off screen updating when you run a macro
(03:08)
Use worksheet functions in a macro
(02:48)
Acquire values using an input box or message box
(05:48)
Call a subroutine from another subroutine
(02:57)
7. Using Excel Events in Your VBA Code
Run a procedure when you open, close, or save a workbook
(05:28)
Run a procedure when a cell range changes
(04:28)
Trigger a procedure using a specific key sequence
(02:41)
8. Putting It All Together
Apply techniques in a capstone project
(05:01)
Conclusion
Further information
(01:19)
Ex_Files_Learning_VBA_Excel.zip
(1.0 MB)
Glossary_LearningVBAExcel.zip
(100 KB)