[FreeCourseLab.com] Udemy - Excel VBA Programming - The Complete Guide
1. Getting Started/1. Introduction.mp4 22.7 MB 1. Getting Started/1. Introduction.vtt 18.8 KB 1. Getting Started/1.1 What's New for VBA in Office 2016.html 158 B 1. Getting Started/1.2 Getting Started with VBA in Office.html 159 B 1. Getting Started/10. The Visual Basic Editor.mp4 15.9 MB 1. Getting Started/10. The Visual Basic Editor.vtt 14.2 KB 1. Getting Started/10.1 MSDN - Use the Properties Window.html 155 B 1. Getting Started/10.2 MSDN - Use the Project Explorer.html 154 B 1. Getting Started/10.3 MSDN - Use the Immediate Window.html 154 B 1. Getting Started/11. VBA Basics.html 128 B 1. Getting Started/2. Download Course Materials.html 1.1 KB 1. Getting Started/2.1 vba-course.zip.zip 1.6 MB 1. Getting Started/3. Enable the Developer Tab.mp4 15.6 MB 1. Getting Started/3. Enable the Developer Tab.vtt 10.5 KB 1. Getting Started/3.1 Office Support - Show the Developer tab.html 161 B 1. Getting Started/4. Excel File Types.mp4 8.2 MB 1. Getting Started/4. Excel File Types.vtt 5.9 KB 1. Getting Started/4.1 Office Support - File formats that are supported in Excel.html 179 B 1. Getting Started/4.2 Wikipedia - List of Microsoft Office filename extensions.html 135 B 1. Getting Started/5. Macro Security.mp4 17.3 MB 1. Getting Started/5. Macro Security.vtt 13.6 KB 1. Getting Started/5.1 Office Support - Change macro security settings in Excel.html 178 B 1. Getting Started/6. The Macro Recorder.mp4 28.5 MB 1. Getting Started/6. The Macro Recorder.vtt 23.8 KB 1. Getting Started/6.1 Getting Started with VBA in Office - To record a macro.html 177 B 1. Getting Started/7. Record Macro to Change Worksheet Orientation.html 130 B 1. Getting Started/8. Absolute vs. Relative References I.mp4 15.4 MB 1. Getting Started/8. Absolute vs. Relative References I.vtt 11.9 KB 1. Getting Started/8.1 Dummies.com - How to Record Macros in Relative Mode and Absolute Mode in Excel 2016.html 186 B 1. Getting Started/9. Absolute vs. Relative References II.mp4 16.5 MB 1. Getting Started/9. Absolute vs. Relative References II.vtt 11.6 KB 10. Conditionals/1. Boolean Expressions.mp4 10.4 MB 10. Conditionals/1. Boolean Expressions.vtt 9.6 KB 10. Conditionals/2. Boolean Expressions.html 128 B 10. Conditionals/3. The If Then Statement.mp4 6.9 MB 10. Conditionals/3. The If Then Statement.vtt 6.1 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.vtt 16.1 KB 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.vtt 15.4 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.vtt 10.2 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 128 B 10. Conditionals/8. The NOT Operator.mp4 13.9 MB 10. Conditionals/8. The NOT Operator.vtt 11.9 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.vtt 19.9 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.vtt 10.5 KB 11. Iteration/3. Deleting Rows.mp4 16.1 MB 11. Iteration/3. Deleting Rows.vtt 16.5 KB 11. Iteration/4. Fill Empty Rows.html 130 B 11. Iteration/5. The For Each-Next Construct.mp4 14.8 MB 11. Iteration/5. The For Each-Next Construct.vtt 11.1 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.vtt 9.9 KB 11. Iteration/7. The With-End With Construct.mp4 10.8 MB 11. Iteration/7. The With-End With Construct.vtt 10.5 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.vtt 18.5 KB 11. Iteration/8.1 Official MSDN Reference on the Exit Statement.html 158 B 11. Iteration/9. Iteration.html 128 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.vtt 13 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.5 MB 12. Miscellaneous Features/2. The MsgBox Method In Depth, Part II.vtt 11.6 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.vtt 9.7 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.vtt 6.4 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.vtt 8.5 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.vtt 14.1 KB 12. Miscellaneous Features/8. The Application.InputBox Method.mp4 14.5 MB 12. Miscellaneous Features/8. The Application.InputBox Method.vtt 14.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.vtt 10 KB 13. Arrays/1.1 Official MSDN Article on Using Arrays.html 142 B 13. Arrays/1.2 Official MSDN Article on Declaring Arrays.html 146 B 13. Arrays/2. Alternate Syntax for Fixed-Size Arrays.mp4 6.1 MB 13. Arrays/2. Alternate Syntax for Fixed-Size Arrays.vtt 7.4 KB 13. Arrays/3. The Option Base 1 Syntax and Write Array Values to Cells.mp4 6.3 MB 13. Arrays/3. The Option Base 1 Syntax and Write Array Values to Cells.vtt 6.5 KB