Filename Size 1. Getting Started/1. Introduction.mp4 22.7 MB 1. Getting Started/1. Introduction.srt 21.4 KB 1. Getting Started/1.1 Getting Started with VBA in Office.html 159 B 1. Getting Started/1.2 What's New for VBA in Office 2016.html 158 B 1. Getting Started/10. Absolute vs. Relative References II.mp4 16.5 MB 1. Getting Started/10. Absolute vs. Relative References II.srt 13.3 KB 1. Getting Started/11. The Visual Basic Editor.mp4 15.9 MB 1. Getting Started/11. The Visual Basic Editor.srt 16.1 KB 1. Getting Started/11.1 MSDN - Use the Project Explorer.html 154 B 1. Getting Started/11.2 MSDN - Use the Properties Window.html 155 B 1. Getting Started/11.3 MSDN - Use the Immediate Window.html 154 B 1. Getting Started/12. VBA Basics.html 132 B 1. Getting Started/2. About Me.mp4 21.3 MB 1. Getting Started/2. About Me.srt 1.7 KB 1. Getting Started/3. Download Course Materials.html 1.1 KB 1. Getting Started/3.1 vba-course.zip 1.6 MB 1. Getting Started/4. Enable the Developer Tab.mp4 15.6 MB 1. Getting Started/4. Enable the Developer Tab.srt 15.6 MB 1. Getting Started/4.1 Office Support - Show the Developer tab.html 161 B 1. Getting Started/5. Excel File Types.mp4 8.2 MB 1. Getting Started/5. Excel File Types.srt 6.6 KB 1. Getting Started/5.1 Office Support - File formats that are supported in Excel.html 179 B 1. Getting Started/5.2 Wikipedia - List of Microsoft Office filename extensions.html 135 B 1. Getting Started/6. Macro Security.mp4 17.3 MB 1. Getting Started/6. Macro Security.srt 15.4 KB 1. Getting Started/6.1 Office Support - Change macro security settings in Excel.html 178 B 1. Getting Started/7. The Macro Recorder.mp4 28.5 MB 1. Getting Started/7. The Macro Recorder.srt 27.2 KB 1. Getting Started/7.1 Getting Started with VBA in Office - To record a macro.html 177 B 1. Getting Started/8. Record Macro to Change Worksheet Orientation.html 134 B 1. Getting Started/9. Absolute vs. Relative References I.mp4 15.4 MB 1. Getting Started/9. Absolute vs. Relative References I.srt 13.7 KB 1. Getting Started/9.1 Dummies.com - How to Record Macros in Relative Mode and Absolute Mode in Excel 2016.html 186 B 10. Conditionals/1. Boolean Expressions.mp4 10.4 MB 10. Conditionals/1. Boolean Expressions.srt 11.1 KB 10. Conditionals/2. Boolean Expressions.html 132 B 10. Conditionals/3. The If Then Statement.mp4 6.9 MB 10. Conditionals/3. The If Then Statement.srt 6.9 KB 10. Conditionals/3.1 Article How to use the IF-THEN-ELSE Statement.html 116 B 10. Conditionals/4. The ElseIf and Else Statements.mp4 20.4 MB 10. Conditionals/4. The ElseIf and Else Statements.srt 20.4 MB 10. Conditionals/4.1 Official MSDN Article on Using If...Then...Else Statements.html 157 B 10. Conditionals/5. Select Case.mp4 20.7 MB 10. Conditionals/5. Select Case.srt 17.7 KB 10. Conditionals/5.1 Official MSDN Article on Using Select Case Statements.html 158 B 10. Conditionals/6. The AND & OR Logical Operators.mp4 12.5 MB 10. Conditionals/6. The AND & OR Logical Operators.srt 11.6 KB 10. Conditionals/6.1 Official MSDN Reference on the OR Operator.html 154 B 10. Conditionals/6.2 Official MSDN Reference on the AND Operator.html 155 B 10. Conditionals/7. Logical Operators.html 132 B 10. Conditionals/8. The NOT Operator.mp4 13.9 MB 10. Conditionals/8. The NOT Operator.srt 13.6 KB 10. Conditionals/8.1 Official MSDN Reference on the NOT Operator.html 155 B 11. Iteration/1. The For Next Loop.mp4 25.9 MB 11. Iteration/1. The For Next Loop.srt 22.7 KB 11. Iteration/1.1 Official MSDN Article on Using For Next Statements.html 154 B 11. Iteration/2. The Step Keyword.mp4 13.5 MB 11. Iteration/2. The Step Keyword.srt 12 KB 11. Iteration/3. Deleting Rows.mp4 16.1 MB 11. Iteration/3. Deleting Rows.srt 18.9 KB 11. Iteration/4. Fill Empty Rows.html 134 B 11. Iteration/5. The For Each-Next Construct.mp4 14.8 MB 11. Iteration/5. The For Each-Next Construct.srt 12.7 KB 11. Iteration/5.1 Official MSDN Article on Using For Each Next Statements.html 159 B 11. Iteration/6. Iterating over a Range of Cells with For Each.mp4 10.5 MB 11. Iteration/6. Iterating over a Range of Cells with For Each.srt 11.2 KB 11. Iteration/7. The With-End With Construct.mp4 10.8 MB 11. Iteration/7. The With-End With Construct.srt 12.1 KB 11. Iteration/7.1 Official MSDN Article on Using With Statements.html 151 B 11. Iteration/8. Exit For and Review of Exit Sub.mp4 19.5 MB 11. Iteration/8. Exit For and Review of Exit Sub.srt 21.2 KB 11. Iteration/8.1 Official MSDN Reference on the Exit Statement.html 158 B 11. Iteration/9. Iteration.html 132 B 12. Miscellaneous Features/1. The MsgBox Method In Depth, Part I.mp4 44 MB 12. Miscellaneous Features/1. The MsgBox Method In Depth, Part I.srt 14.9 KB 12. Miscellaneous Features/1.1 Official Visual Basic for Applications Reference for the MsgBox Function.html 157 B 12. Miscellaneous Features/2. The MsgBox Method In Depth, Part II.mp4 49.6 MB 12. Miscellaneous Features/2. The MsgBox Method In Depth, Part II.srt 13.4 KB 12. Miscellaneous Features/3. MsgBox Options.html 1.1 KB 12. Miscellaneous Features/4. StatusBar.mp4 36.6 MB 12. Miscellaneous Features/4. StatusBar.srt 10.9 KB 12. Miscellaneous Features/4.1 Official MSDN Documentation for the Application.StatusBar Property.html 153 B 12. Miscellaneous Features/5. The Application.ScreenUpdating Property.mp4 6.2 MB 12. Miscellaneous Features/5. The Application.ScreenUpdating Property.srt 7.2 KB 12. Miscellaneous Features/5.1 Official MSDN Documentation for the Application.ScreenUpdating Property.html 158 B 12. Miscellaneous Features/6. SpecialCells.mp4 8.3 MB 12. Miscellaneous Features/6. SpecialCells.srt 9.7 KB 12. Miscellaneous Features/6.1 Official MSDN Documentation for the Range.SpecialCells Method.html 148 B 12. Miscellaneous Features/7. The InputBox Function.mp4 12.3 MB 12. Miscellaneous Features/7. The InputBox Function.srt 16 KB 12. Miscellaneous Features/7.1 Official Microsoft documentation for the InputBox Function.html 161 B 12. Miscellaneous Features/8. The Application.InputBox Method.mp4 14.5 MB 12. Miscellaneous Features/8. The Application.InputBox Method.srt 16.2 KB 12. Miscellaneous Features/8.1 Official MSDN Documentation for the Application.InputBox Method.html 150 B 13. Arrays/1. Intro to Arrays.mp4 8 MB 13. Arrays/1. Intro to Arrays.srt 11.3 KB 13. Arrays/1.1 Official MSDN Article on Declaring Arrays.html 146 B 13. Arrays/1.2 Official MSDN Article on Using Arrays.html 142 B 13. Arrays/2. Alternate Syntax for Fixed-Size Arrays.mp4 6.2 MB