-
Getting Started 15
-
Introduction to Excel Macros and VBALecture1.1
-
What is VBA?Lecture1.2
-
What VBA is not!Lecture1.3
-
Essential VBA terminologyLecture1.4
-
What is a macro (aka sub procedure)?Lecture1.5
-
How are macros created?Lecture1.6
-
Where is VBA coding done?Lecture1.7
-
Where are macros stored?Lecture1.8
-
Macro-enabled workbooksLecture1.9
-
Accessing macrosLecture1.10
-
The PERSONAL.XLSB workbookLecture1.11
-
Not all macros are “good”Lecture1.12
-
Macro security settingsLecture1.13
-
Setting up a trusted locationLecture1.14
-
Getting started – ReviewLecture1.15
-
-
Creating a Macro 22
-
Introduction to creating a macroLecture2.1
-
Displaying the Developer tabLecture2.2
-
Saving as a macro-enabled workbookLecture2.3
-
Launching the Visual Basic Editor (VBE)Lecture2.4
-
Setting up the VBE interfaceLecture2.5
-
Project Explorer window – Part 1Lecture2.6
-
Project Explorer window – Part 2Lecture2.7
-
Inserting a moduleLecture2.8
-
Renaming and deleting a moduleLecture2.9
-
Basic syntax to start and end a macroLecture2.10
-
Naming your macroLecture2.11
-
Declaring the start and end of a macroLecture2.12
-
Writing the instructions – Part 1Lecture2.13
-
Writing the instructions – Part 2Lecture2.14
-
Writing the instructions – Part 3Lecture2.15
-
Automatic formattingLecture2.16
-
The line continuation characterLecture2.17
-
Inserting commentsLecture2.18
-
Converting multiple lines into commentsLecture2.19
-
Inserting blank linesLecture2.20
-
Auto syntax checkLecture2.21
-
Creating a macro – ReviewLecture2.22
-
-
Running a Macro 11
-
Introduction to running a macroLecture3.1
-
Before you run a macroLecture3.2
-
Using the Run Sub/User Form commandLecture3.3
-
Using the Macros list – Part 1Lecture3.4
-
Using the Macros list – Part 2Lecture3.5
-
Using a keyboard shortcutLecture3.6
-
Creating a command button to run a macroLecture3.7
-
Creating a graphical object or button control to run a macroLecture3.8
-
Compile errorsLecture3.9
-
Run time errorsLecture3.10
-
Running a macro – ReviewLecture3.11
-
-
Using the Macro Recorder 37
-
Introduction to using the macro recorderLecture4.1
-
Practicing before you use the Macro RecorderLecture4.2
-
Absolute vs relative modeLecture4.3
-
Recording the macroLecture4.4
-
Running the macroLecture4.5
-
Viewing the VBA codeLecture4.6
-
Editing the VBA codeLecture4.7
-
Deleting the macroLecture4.8
-
Avoiding a common mistake – Part 1Lecture4.9
-
Avoiding a common mistake – Part 2Lecture4.10
-
Avoiding a common mistake – Part 3Lecture4.11
-
Avoiding a common mistake – Part 4Lecture4.12
-
Viewing VBA statements generated in real timeLecture4.13
-
Selecting a range of any sizeLecture4.14
-
Creating a macro that formats a range of any sizeLecture4.15
-
Using CTRL + A in relative modeLecture4.16
-
Using CTRL + A in absolute modeLecture4.17
-
Navigating to the end of a range of any sizeLecture4.18
-
Inserting SUM at the end of a column of any sizeLecture4.19
-
Another way to navigate to the end of a column of any sizeLecture4.20
-
When does a new module get created?Lecture4.21
-
Generating the PERSONAL.XLSB workbookLecture4.22
-
Storing a macro in the PERSONAL.XLSB workbookLecture4.23
-
Unhiding or hiding the PERSONAL.XLSB workbookLecture4.24
-
Deleting the PERSONAL.XLSB workbookLecture4.25
-
A super useful tip!Lecture4.26
-
Using AutoSum during a recordingLecture4.27
-
AutoSum in absolute referencing mode – Part 1Lecture4.28
-
AutoSum in absolute referencing mode – Part 2Lecture4.29
-
AutoSum in relative referencing modeLecture4.30
-
The verdict on using AutoSumLecture4.31
-
Creating a macro that imports data – Part 1Lecture4.32
-
Creating a macro that imports data – Part 2Lecture4.33
-
Creating a macro that imports data – Part 3Lecture4.34
-
Creating a macro that imports data – Part 4Lecture4.35
-
Creating a macro that imports data – Part 5Lecture4.36
-
Using the Macro Recorder – ReviewLecture4.37
-
-
Debugging a Macro 12
-
Creating a macro for debugging purposesLecture5.1
-
Testing the macroLecture5.2
-
Stepping into the VBA codeLecture5.3
-
What is a breakpoint?Lecture5.4
-
Inserting and removing breakpointsLecture5.5
-
Using Step Into and breakpointsLecture5.6
-
Using Run to CursorLecture5.7
-
What is compiling?Lecture5.8
-
What happens when a compile error occurs?Lecture5.9
-
Using the Compile VBAProject commandLecture5.10
-
Changing the Editor Format optionsLecture5.11
-
Final wordsLecture5.12
-
