Magnet link info for '[Tutorialsplanet.NET] Udemy - Excel VBA Programming - The Complete Guide-c69f060a6064164e281a4e6d9b2396854c13255f',download '[Tutorialsplanet.NET] Udemy - Excel VBA Programming - The Complete Guide'

Files list

1. Getting Started,1. Introduction.mp4 22.75MB

1. Getting Started,1. Introduction.srt 21.44KB

1. Getting Started,1.1 Getting Started with VBA in Office.html 159.00Bytes

1. Getting Started,1.2 What's New for VBA in Office 2016.html 158.00Bytes

1. Getting Started,10. Absolute vs. Relative References II.mp4 16.51MB

1. Getting Started,10. Absolute vs. Relative References II.srt 13.33KB

1. Getting Started,11. The Visual Basic Editor.mp4 15.89MB

1. Getting Started,11. The Visual Basic Editor.srt 16.10KB

1. Getting Started,11.1 MSDN - Use the Project Explorer.html 154.00Bytes

1. Getting Started,11.2 MSDN - Use the Properties Window.html 155.00Bytes

1. Getting Started,11.3 MSDN - Use the Immediate Window.html 154.00Bytes

1. Getting Started,12. VBA Basics.html 132.00Bytes

1. Getting Started,2. About Me.mp4 21.31MB

1. Getting Started,2. About Me.srt 1.72KB

1. Getting Started,3. Download Course Materials.html 1.14KB

1. Getting Started,3.1 vba-course.zip 1.59MB

1. Getting Started,4. Enable the Developer Tab.mp4 15.58MB

1. Getting Started,4. Enable the Developer Tab.srt 15.60MB

1. Getting Started,4.1 Office Support - Show the Developer tab.html 161.00Bytes

1. Getting Started,5. Excel File Types.mp4 8.18MB

1. Getting Started,5. Excel File Types.srt 6.63KB

1. Getting Started,5.1 Office Support - File formats that are supported in Excel.html 179.00Bytes

1. Getting Started,5.2 Wikipedia - List of Microsoft Office filename extensions.html 135.00Bytes

1. Getting Started,6. Macro Security.mp4 17.32MB

1. Getting Started,6. Macro Security.srt 15.44KB

1. Getting Started,6.1 Office Support - Change macro security settings in Excel.html 178.00Bytes

1. Getting Started,7. The Macro Recorder.mp4 28.50MB

1. Getting Started,7. The Macro Recorder.srt 27.16KB

1. Getting Started,7.1 Getting Started with VBA in Office - To record a macro.html 177.00Bytes

1. Getting Started,8. Record Macro to Change Worksheet Orientation.html 134.00Bytes

1. Getting Started,9. Absolute vs. Relative References I.mp4 15.43MB

1. Getting Started,9. Absolute vs. Relative References I.srt 13.71KB

1. Getting Started,9.1 Dummies.com - How to Record Macros in Relative Mode and Absolute Mode in Excel 2016.html 186.00Bytes

10. Conditionals,1. Boolean Expressions.mp4 10.38MB

10. Conditionals,1. Boolean Expressions.srt 11.10KB

10. Conditionals,2. Boolean Expressions.html 132.00Bytes

10. Conditionals,3. The If Then Statement.mp4 6.88MB

10. Conditionals,3. The If Then Statement.srt 6.93KB

10. Conditionals,3.1 Article How to use the IF-THEN-ELSE Statement.html 116.00Bytes

10. Conditionals,4. The ElseIf and Else Statements.mp4 20.41MB

10. Conditionals,4. The ElseIf and Else Statements.srt 20.41MB

10. Conditionals,4.1 Official MSDN Article on Using If...Then...Else Statements.html 157.00Bytes

10. Conditionals,5. Select Case.mp4 20.72MB

10. Conditionals,5. Select Case.srt 17.67KB

10. Conditionals,5.1 Official MSDN Article on Using Select Case Statements.html 158.00Bytes

10. Conditionals,6. The AND & OR Logical Operators.mp4 12.53MB

10. Conditionals,6. The AND & OR Logical Operators.srt 11.65KB

10. Conditionals,6.1 Official MSDN Reference on the OR Operator.html 154.00Bytes

10. Conditionals,6.2 Official MSDN Reference on the AND Operator.html 155.00Bytes

10. Conditionals,7. Logical Operators.html 132.00Bytes

10. Conditionals,8. The NOT Operator.mp4 13.87MB

10. Conditionals,8. The NOT Operator.srt 13.63KB

10. Conditionals,8.1 Official MSDN Reference on the NOT Operator.html 155.00Bytes

11. Iteration,1. The For Next Loop.mp4 25.89MB

11. Iteration,1. The For Next Loop.srt 22.74KB

11. Iteration,1.1 Official MSDN Article on Using For Next Statements.html 154.00Bytes

11. Iteration,2. The Step Keyword.mp4 13.54MB

11. Iteration,2. The Step Keyword.srt 11.97KB

11. Iteration,3. Deleting Rows.mp4 16.06MB

11. Iteration,3. Deleting Rows.srt 18.86KB

11. Iteration,4. Fill Empty Rows.html 134.00Bytes

11. Iteration,5. The For Each-Next Construct.mp4 14.83MB

11. Iteration,5. The For Each-Next Construct.srt 12.67KB

11. Iteration,5.1 Official MSDN Article on Using For Each Next Statements.html 159.00Bytes

11. Iteration,6. Iterating over a Range of Cells with For Each.mp4 10.46MB

11. Iteration,6. Iterating over a Range of Cells with For Each.srt 11.23KB

11. Iteration,7. The With-End With Construct.mp4 10.83MB

11. Iteration,7. The With-End With Construct.srt 12.06KB

11. Iteration,7.1 Official MSDN Article on Using With Statements.html 151.00Bytes

11. Iteration,8. Exit For and Review of Exit Sub.mp4 19.51MB

11. Iteration,8. Exit For and Review of Exit Sub.srt 21.17KB

11. Iteration,8.1 Official MSDN Reference on the Exit Statement.html 158.00Bytes

11. Iteration,9. Iteration.html 132.00Bytes

12. Miscellaneous Features,1. The MsgBox Method In Depth, Part I.mp4 44.01MB

12. Miscellaneous Features,1. The MsgBox Method In Depth, Part I.srt 14.85KB

12. Miscellaneous Features,1.1 Official Visual Basic for Applications Reference for the MsgBox Function.html 157.00Bytes

12. Miscellaneous Features,2. The MsgBox Method In Depth, Part II.mp4 49.55MB

12. Miscellaneous Features,2. The MsgBox Method In Depth, Part II.srt 13.44KB

12. Miscellaneous Features,3. MsgBox Options.html 1.08KB

12. Miscellaneous Features,4. StatusBar.mp4 36.64MB

12. Miscellaneous Features,4. StatusBar.srt 10.92KB

12. Miscellaneous Features,4.1 Official MSDN Documentation for the Application.StatusBar Property.html 153.00Bytes

12. Miscellaneous Features,5. The Application.ScreenUpdating Property.mp4 6.24MB

12. Miscellaneous Features,5. The Application.ScreenUpdating Property.srt 7.20KB

12. Miscellaneous Features,5.1 Official MSDN Documentation for the Application.ScreenUpdating Property.html 158.00Bytes

12. Miscellaneous Features,6. SpecialCells.mp4 8.27MB

12. Miscellaneous Features,6. SpecialCells.srt 9.66KB

12. Miscellaneous Features,6.1 Official MSDN Documentation for the Range.SpecialCells Method.html 148.00Bytes

12. Miscellaneous Features,7. The InputBox Function.mp4 12.29MB

12. Miscellaneous Features,7. The InputBox Function.srt 16.04KB

12. Miscellaneous Features,7.1 Official Microsoft documentation for the InputBox Function.html 161.00Bytes

12. Miscellaneous Features,8. The Application.InputBox Method.mp4 14.47MB

12. Miscellaneous Features,8. The Application.InputBox Method.srt 16.19KB

12. Miscellaneous Features,8.1 Official MSDN Documentation for the Application.InputBox Method.html 150.00Bytes

13. Arrays,1. Intro to Arrays.mp4 8.03MB

13. Arrays,1. Intro to Arrays.srt 11.34KB

13. Arrays,1.1 Official MSDN Article on Declaring Arrays.html 146.00Bytes

13. Arrays,1.2 Official MSDN Article on Using Arrays.html 142.00Bytes

13. Arrays,2. Alternate Syntax for Fixed-Size Arrays.mp4 6.16MB

13. Arrays,2. Alternate Syntax for Fixed-Size Arrays.srt 8.41KB

13. Arrays,3. The Option Base 1 Syntax and Write Array Values to Cells.mp4 6.31MB

13. Arrays,3. The Option Base 1 Syntax and Write Array Values to Cells.srt 7.38KB

13. Arrays,4. Initialize Arrays within a For Loop.mp4 11.17MB

13. Arrays,4. Initialize Arrays within a For Loop.srt 9.94KB

13. Arrays,5. The LBound and UBound Methods.mp4 9.62MB

13. Arrays,5. The LBound and UBound Methods.srt 10.92KB

13. Arrays,6. Dynamic Arrays.mp4 17.87MB

13. Arrays,6. Dynamic Arrays.srt 16.74KB

13. Arrays,7. The Range.RemoveDuplicates Method.mp4 8.17MB

13. Arrays,7. The Range.RemoveDuplicates Method.srt 7.34KB

13. Arrays,7.1 Official MSDN Documentation for the Range.RemoveDuplicates Method.html 146.00Bytes

14. Functions,1. VBA Functions, Part I.mp4 16.15MB

14. Functions,1. VBA Functions, Part I.srt 15.91KB

14. Functions,1.1 Complete Listing of all VBA Functions.html 118.00Bytes

14. Functions,2. VBA Functions, Part II.mp4 9.52MB

14. Functions,2. VBA Functions, Part II.srt 11.58KB

14. Functions,2.1 Complete Listing of all VBA Functions.html 118.00Bytes

14. Functions,3. The Split Function.mp4 8.20MB

14. Functions,3. The Split Function.srt 7.49KB

14. Functions,3.1 Tech on the Net Article on the VBA Split Function.html 114.00Bytes

14. Functions,4. The Is Family of Functions.mp4 78.98MB

14. Functions,4. The Is Family of Functions.srt 18.14KB

14. Functions,4.1 Tech on the Net Article on the IsError Function.html 146.00Bytes

14. Functions,4.2 Tech on the Net Article on the IsNumeric Function.html 148.00Bytes

14. Functions,4.3 Tech on the Net Article on the IsDate Function.html 145.00Bytes

14. Functions,4.4 Tech on the Net Article on the IsEmpty Function.html 146.00Bytes

14. Functions,5. Date and Time Functions.mp4 30.37MB

14. Functions,5. Date and Time Functions.srt 7.91KB

14. Functions,5.1 Tech on the Net Article on the DateSerial Function.html 119.00Bytes

14. Functions,5.2 Tech on the Net Article on the Date Function.html 117.00Bytes

14. Functions,5.3 Tech on the Net Article on the Now Function.html 112.00Bytes

14. Functions,6. More Date and Time Functions.mp4 30.46MB

14. Functions,6. More Date and Time Functions.srt 10.34KB

14. Functions,6.1 Tech on the Net Article on the WeekdayName Function.html 120.00Bytes

14. Functions,6.2 Tech on the Net Article on the Second Function.html 115.00Bytes

14. Functions,6.3 Tech on the Net Article on the Hour Function.html 113.00Bytes

14. Functions,6.4 Tech on the Net Article on the Weekday Function.html 116.00Bytes

14. Functions,6.5 Tech on the Net Article on the Minute Function.html 115.00Bytes

14. Functions,6.6 Tech on the Net Article on the Year Function.html 113.00Bytes

14. Functions,6.7 Tech on the Net Article on the MonthName Function.html 118.00Bytes

14. Functions,6.8 Tech on the Net Article on the Month Function.html 114.00Bytes

14. Functions,6.9 Tech on the Net Article on the Day Function.html 112.00Bytes

14. Functions,7. Excel Worksheet Functions.mp4 12.45MB

14. Functions,7. Excel Worksheet Functions.srt 14.76KB

14. Functions,8. Custom Functions.mp4 15.30MB

14. Functions,8. Custom Functions.srt 19.15KB

14. Functions,8.1 Official MSDN Article on Writing A Function Procedure.html 158.00Bytes

15. Debugging,1. Intro to Error Handling.mp4 12.26MB

15. Debugging,1. Intro to Error Handling.srt 13.02KB

15. Debugging,2. The OnError and GoTo Keywords.mp4 13.14MB

15. Debugging,2. The OnError and GoTo Keywords.srt 11.82KB

15. Debugging,3. The OnError Resume Next Keywords.mp4 10.04MB

15. Debugging,3. The OnError Resume Next Keywords.srt 9.24KB

15. Debugging,4. Error and Err.Number.mp4 16.28MB

15. Debugging,4. Error and Err.Number.srt 13.26KB

15. Debugging,5. Stepping Through Code.mp4 11.76MB

15. Debugging,5. Stepping Through Code.srt 14.82KB

15. Debugging,6. Breakpoints.mp4 8.77MB

15. Debugging,6. Breakpoints.srt 11.03KB

16. Events,1. Introduction to Events.mp4 29.29MB

16. Events,1. Introduction to Events.srt 12.68KB

16. Events,2. The Worksheet_SelectionChange Event.mp4 12.47MB

16. Events,2. The Worksheet_SelectionChange Event.srt 10.80KB

16. Events,2.1 Official MSDN Documentation for the Worksheet.SelectionChange Event.html 154.00Bytes

16. Events,3. Review of Application.EnableEvents.mp4 5.11MB

16. Events,3. Review of Application.EnableEvents.srt 6.26KB

16. Events,3.1 Official MSDN Documentation for the Application.EnableEvents Property.html 156.00Bytes

16. Events,4. The Worksheet_Change Event.mp4 19.19MB

16. Events,4. The Worksheet_Change Event.srt 22.74KB

16. Events,4.1 Official MSDN Documentation for the Worksheet.Change Event.html 145.00Bytes

16. Events,5. The Worksheet_Activate Event.mp4 4.14MB

16. Events,5. The Worksheet_Activate Event.srt 4.88KB

16. Events,5.1 Official MSDN Documentation for the Worksheet.Activate Event.html 147.00Bytes

16. Events,6. Highlight Row and Column Up to Cell Where Cursor Is Placed.html 134.00Bytes

16. Events,7. Workbook Events and The Sh Argument.mp4 13.44MB

16. Events,7. Workbook Events and The Sh Argument.srt 14.17KB

16. Events,7.1 Official MSDN Documentation for the Workbook.SheetChange Event.html 149.00Bytes

16. Events,8. The Workbook_Open Event.mp4 5.62MB

16. Events,8. The Workbook_Open Event.srt 5.08KB

16. Events,8.1 Official MSDN Documentation for the Workbook.Open Event.html 142.00Bytes

16. Events,9. Procedures with Boolean Arguments + The Workbook_BeforePrint Event.mp4 6.02MB

16. Events,9. Procedures with Boolean Arguments + The Workbook_BeforePrint Event.srt 6.60KB

16. Events,9.1 Official MSDN Documentation for the Workbook.BeforePrint Event.html 149.00Bytes

17. User Forms,1. Create UserForm, Toolbox, Properties, Controls.mp4 10.50MB

17. User Forms,1. Create UserForm, Toolbox, Properties, Controls.srt 12.67KB

17. User Forms,10. Activate a UserForm from Procedure.mp4 5.57MB

17. User Forms,10. Activate a UserForm from Procedure.srt 6.31KB

17. User Forms,11. The initialize Event.mp4 11.40MB

17. User Forms,11. The initialize Event.srt 14.46KB

17. User Forms,12. The ListBox Control I - Wire up the Form.mp4 12.82MB

17. User Forms,12. The ListBox Control I - Wire up the Form.srt 14.14KB

17. User Forms,13. The ListBox Control II - React to User Selection.mp4 15.00MB

17. User Forms,13. The ListBox Control II - React to User Selection.srt 12.37KB

17. User Forms,14. The ListBox Control III - Select Multiple Items.mp4 19.49MB

17. User Forms,14. The ListBox Control III - Select Multiple Items.srt 16.43KB

17. User Forms,15. The ComboBox Control I.mp4 9.62MB

17. User Forms,15. The ComboBox Control I.srt 10.38KB

17. User Forms,16. The ComboBox Control II.mp4 17.50MB

17. User Forms,16. The ComboBox Control II.srt 18.03KB

17. User Forms,17. The CheckBox Control.mp4 19.92MB

17. User Forms,17. The CheckBox Control.srt 17.03KB

17. User Forms,2. The Label and TextBox Controls.mp4 9.38MB

17. User Forms,2. The Label and TextBox Controls.srt 8.61KB

17. User Forms,3. Naming Conventions.mp4 4.84MB

17. User Forms,3. Naming Conventions.srt 5.91KB

17. User Forms,4. Naming Conventions.html 686.00Bytes

17. User Forms,5. Design Aesthetics.mp4 9.52MB

17. User Forms,5. Design Aesthetics.srt 9.99KB

17. User Forms,6. The CommandButton Control.mp4 7.36MB

17. User Forms,6. The CommandButton Control.srt 6.47KB

17. User Forms,7. Add Event Procedure to Control.mp4 8.04MB

17. User Forms,7. Add Event Procedure to Control.srt 8.06MB

17. User Forms,8. Unload and Hide a UserForm.mp4 12.58MB

17. User Forms,8. Unload and Hide a UserForm.srt 11.46KB

17. User Forms,9. Submit the UserForm.mp4 17.14MB

17. User Forms,9. Submit the UserForm.srt 14.83KB

2. The Fundamentals of the Excel Object Model,1. Object-Oriented Programming in Real Life.mp4 19.53MB

2. The Fundamentals of the Excel Object Model,1. Object-Oriented Programming in Real Life.srt 19.62KB

2. The Fundamentals of the Excel Object Model,2. Real Life Objects.html 134.00Bytes

2. The Fundamentals of the Excel Object Model,3. Collection Objects in Real Life.mp4 10.42MB

2. The Fundamentals of the Excel Object Model,3. Collection Objects in Real Life.srt 8.74KB

2. The Fundamentals of the Excel Object Model,4. Objects As Properties.mp4 15.84MB

2. The Fundamentals of the Excel Object Model,4. Objects As Properties.srt 13.35KB

2. The Fundamentals of the Excel Object Model,4.1 Dummies.com - An Overview of the Excel Object Model.html 154.00Bytes

2. The Fundamentals of the Excel Object Model,5. The Excel Object Model.mp4 24.24MB

2. The Fundamentals of the Excel Object Model,5. The Excel Object Model.srt 24.96KB

2. The Fundamentals of the Excel Object Model,5.1 Dummies.com - An Overview of the Excel Object Model.html 154.00Bytes

2. The Fundamentals of the Excel Object Model,6. Access Object from Collection by Name.mp4 7.44MB

2. The Fundamentals of the Excel Object Model,6. Access Object from Collection by Name.srt 6.55KB

2. The Fundamentals of the Excel Object Model,7. Default Properties.mp4 6.67MB

2. The Fundamentals of the Excel Object Model,7. Default Properties.srt 5.83KB

2. The Fundamentals of the Excel Object Model,7.1 Stack Overflow - Is “Value” actually the default property of the Range object.html 164.00Bytes

2. The Fundamentals of the Excel Object Model,8. The Name Property on Workbook and Worksheet Objects.mp4 7.42MB

2. The Fundamentals of the Excel Object Model,8. The Name Property on Workbook and Worksheet Objects.srt 6.65KB

2. The Fundamentals of the Excel Object Model,8.1 Official MSDN Documentation for the Worksheet.Name Property.html 146.00Bytes

2. The Fundamentals of the Excel Object Model,8.2 Official MSDN Documentation for the Workbook.Name Property.html 145.00Bytes

2. The Fundamentals of the Excel Object Model,9. Object-Oriented Programming.html 132.00Bytes

3. The Visual Basic Editor,1. Visual Basic Editor Options.mp4 17.21MB

3. The Visual Basic Editor,1. Visual Basic Editor Options.srt 23.40KB

3. The Visual Basic Editor,1.1 Official MSDN Article on Configuring Options in the Visual Basic Editor.html 166.00Bytes

3. The Visual Basic Editor,2. Create and Delete a Procedure.mp4 15.45MB

3. The Visual Basic Editor,2. Create and Delete a Procedure.srt 14.78KB

3. The Visual Basic Editor,2.1 Official MSDN Article on Writing a Procedure.html 153.00Bytes

3. The Visual Basic Editor,3. Procedures.html 132.00Bytes

3. The Visual Basic Editor,4. The Immediate Window and Debug.Print Method.mp4 16.11MB

3. The Visual Basic Editor,4. The Immediate Window and Debug.Print Method.srt 15.02KB

3. The Visual Basic Editor,4.1 Official MSDN Article on the Debug Object.html 142.00Bytes

3. The Visual Basic Editor,4.2 Official MSDN Article on Using the Immediate Window.html 154.00Bytes

3. The Visual Basic Editor,5. The MsgBox Method.mp4 25.91MB

3. The Visual Basic Editor,5. The MsgBox Method.srt 22.65KB

3. The Visual Basic Editor,5.1 Official MSDN Reference Article on the MsgBox Method.html 124.00Bytes

3. The Visual Basic Editor,6. Comments.mp4 10.04MB

3. The Visual Basic Editor,6. Comments.srt 8.80KB

3. The Visual Basic Editor,6.1 Official MSDN Tutorial on Adding Comments to Code.html 125.00Bytes

3. The Visual Basic Editor,7. Practice with Procedures.html 134.00Bytes

3. The Visual Basic Editor,8. The Visual Basic Editor.html 132.00Bytes

4. Objects and Methods,1. Methods without Arguments.mp4 5.09MB

4. Objects and Methods,1. Methods without Arguments.srt 5.68KB

4. Objects and Methods,1.1 Office VBA Reference - Understanding Objects, Properties, Methods, and Events.html 181.00Bytes

4. Objects and Methods,2. Methods without Arguments.html 134.00Bytes

4. Objects and Methods,3. Methods with Arguments.mp4 20.08MB

4. Objects and Methods,3. Methods with Arguments.srt 14.69KB

4. Objects and Methods,3.1 Official MSDN Documentation for the Worksheet Object.html 139.00Bytes

4. Objects and Methods,3.2 Official MSDN Documentation for the Worksheet.Protect Method.html 147.00Bytes

4. Objects and Methods,4. Methods with Arguments.html 134.00Bytes

4. Objects and Methods,5. Methods with Multiple Arguments.mp4 12.59MB

4. Objects and Methods,5. Methods with Multiple Arguments.srt 11.95KB

4. Objects and Methods,6. The Object Browser.mp4 11.63MB

4. Objects and Methods,6. The Object Browser.srt 9.52KB

4. Objects and Methods,6.1 Official MSDN Article on using the Object Browser.html 152.00Bytes

4. Objects and Methods,7. Ways to Invoke A Procedure.mp4 16.39MB

4. Objects and Methods,7. Ways to Invoke A Procedure.srt 13.90KB

4. Objects and Methods,8. The TypeName Method.mp4 10.06MB

4. Objects and Methods,8. The TypeName Method.srt 10.15KB

4. Objects and Methods,8.1 Official MSDN Documentation for the TypeName Function.html 147.00Bytes

4. Objects and Methods,9. Objects and Methods.html 132.00Bytes

5. Variables and Data Types,1. Syntax Tips.mp4 14.56MB

5. Variables and Data Types,1. Syntax Tips.srt 13.15KB

5. Variables and Data Types,1.1 Official MSDN Documentation for Writing Visual Basic Statements.html 161.00Bytes

5. Variables and Data Types,1.2 Official MSDN Documentation for Understanding Visual Basic Syntax.html 163.00Bytes

5. Variables and Data Types,10. String and Double Data Types.html 132.00Bytes

5. Variables and Data Types,11. The Boolean Data Type.mp4 7.30MB

5. Variables and Data Types,11. The Boolean Data Type.srt 7.15KB

5. Variables and Data Types,11.1 Official MSDN Documentation for the Boolean Data Type.html 161.00Bytes

5. Variables and Data Types,12. The Date Data Type.mp4 11.91MB

5. Variables and Data Types,12. The Date Data Type.srt 10.30KB

5. Variables and Data Types,12.1 Official MSDN Documentation for the Date Data Type.html 158.00Bytes

5. Variables and Data Types,13. The Variant Data Type.mp4 10.27MB

5. Variables and Data Types,13. The Variant Data Type.srt 9.16KB

5. Variables and Data Types,13.1 Official MSDN Article on Understanding Variants.html 152.00Bytes

5. Variables and Data Types,14. The Object Data Type.mp4 14.99MB

5. Variables and Data Types,14. The Object Data Type.srt 12.95KB

5. Variables and Data Types,15. Default Values for Declared Variables.mp4 4.89MB

5. Variables and Data Types,15. Default Values for Declared Variables.srt 4.89KB

5. Variables and Data Types,16. Variable Declarations.html 134.00Bytes

5. Variables and Data Types,2. Variable Declarations and Assignments.mp4 18.50MB

5. Variables and Data Types,2. Variable Declarations and Assignments.srt 15.99KB

5. Variables and Data Types,2.1 Official MSDN Documentation for Writing Declaration Statements.html 160.00Bytes

5. Variables and Data Types,2.2 Official MSDN Documentation for Visual Basic Naming Rules.html 155.00Bytes

5. Variables and Data Types,2.3 Official MSDN Documentation for Writing Assignment Statements.html 159.00Bytes

5. Variables and Data Types,2.4 Official MSDN Documentation for Using Data Types Efficiently.html 158.00Bytes

5. Variables and Data Types,2.5 Official MSDN Documentation for Declaring Variables.html 149.00Bytes

5. Variables and Data Types,3. Multiple Variable Declarations.mp4 8.19MB

5. Variables and Data Types,3. Multiple Variable Declarations.srt 6.89KB

5. Variables and Data Types,4. The Option Explicit Setting.mp4 7.42MB

5. Variables and Data Types,4. The Option Explicit Setting.srt 10.48KB

5. Variables and Data Types,4.1 Official MSDN Documentation for the Option Explicit Statement.html 169.00Bytes

5. Variables and Data Types,5. The Byte, Integer and Long Data Types.mp4 13.17MB

5. Variables and Data Types,5. The Byte, Integer and Long Data Types.srt 13.44KB

5. Variables and Data Types,5.1 Official MSDN Documentation for the Long Data Type.html 158.00Bytes

5. Variables and Data Types,5.2 Official MSDN Documentation for the Byte Data Type.html 158.00Bytes

5. Variables and Data Types,5.3 Official MSDN Documentation for the Integer Data Type.html 161.00Bytes

5. Variables and Data Types,6. Numeric Data Types.html 134.00Bytes

5. Variables and Data Types,7. Mathematical Operations.mp4 10.25MB

5. Variables and Data Types,7. Mathematical Operations.srt 10.33KB

5. Variables and Data Types,8. The Single and Double Data Types.mp4 10.27MB

5. Variables and Data Types,8. The Single and Double Data Types.srt 10.29KB

5. Variables and Data Types,8.1 Official MSDN Documentation for the Double Data Type.html 160.00Bytes

5. Variables and Data Types,8.2 Official MSDN Documentation for the Single Data Type.html 160.00Bytes

5. Variables and Data Types,9. The String Data Type.mp4 8.47MB

5. Variables and Data Types,9. The String Data Type.srt 8.48MB

5. Variables and Data Types,9.1 Official MSDN Documentation for the String Data Type.html 160.00Bytes

6. Procedures,1. Variable Scope.mp4 13.25MB

6. Procedures,1. Variable Scope.srt 16.78KB

6. Procedures,2. Call A Procedure from Another one.mp4 6.67MB

6. Procedures,2. Call A Procedure from Another one.srt 6.76KB

6. Procedures,3. Procedures with Arguments.mp4 14.06MB

6. Procedures,3. Procedures with Arguments.srt 12.27KB

6. Procedures,4. Procedure Scope (Public vs. Private).mp4 13.23MB

6. Procedures,4. Procedure Scope (Public vs. Private).srt 11.61KB

6. Procedures,5. The Exit Sub Keywords.mp4 3.01MB

6. Procedures,5. The Exit Sub Keywords.srt 3.39KB

6. Procedures,5.1 Official MSDN Documentation on the Exit Statement.html 158.00Bytes

6. Procedures,6. Constants.mp4 11.44MB

6. Procedures,6. Constants.srt 11.47KB

6. Procedures,6.1 Official MSDN Article on Using Constants.html 145.00Bytes

6. Procedures,6.2 Official MSDN Article on Declaring Constants.html 149.00Bytes

6. Procedures,7. Predefined Constants.mp4 22.50MB

6. Procedures,7. Predefined Constants.srt 18.53KB

6. Procedures,7.1 Official MSDN Documentation for the xlPageOrientation Enumeration.html 152.00Bytes

6. Procedures,7.2 Official MSDN Documentation for the PageSetup Object.html 139.00Bytes

6. Procedures,8. Procedures.html 132.00Bytes

7. Object Deep Dive,1. The Application Object.mp4 24.87MB

7. Object Deep Dive,1. The Application Object.srt 7.24KB

7. Object Deep Dive,1.1 Official MSDN Documentation for the Application.UserName Property.html 152.00Bytes

7. Object Deep Dive,1.2 Official MSDN Documentation for the Application Object.html 141.00Bytes

7. Object Deep Dive,1.3 Official MSDN Documentation for the Application.Version Property.html 151.00Bytes

7. Object Deep Dive,1.4 Official MSDN Documentation for the Application.Path Property.html 148.00Bytes

7. Object Deep Dive,1.5 Official MSDN Documentation for the Application.Quit Method.html 146.00Bytes

7. Object Deep Dive,1.6 Official MSDN Documentation for the Application.Name Property.html 148.00Bytes

7. Object Deep Dive,10. The Application, Workbooks and Workbook Objects.html 132.00Bytes

7. Object Deep Dive,11. The Worksheets.Add Method.mp4 40.13MB

7. Object Deep Dive,11. The Worksheets.Add Method.srt 8.80KB

7. Object Deep Dive,11.1 Official MSDN Documentation for the Worksheets.Add Method.html 144.00Bytes

7. Object Deep Dive,11.2 Official MSDN Documentation for the Worksheets Object.html 140.00Bytes

7. Object Deep Dive,12. Add a New Worksheet to End of Current List of Worksheets.html 134.00Bytes

7. Object Deep Dive,13. The Worksheet.Visible Property.mp4 35.08MB

7. Object Deep Dive,13. The Worksheet.Visible Property.srt 8.84KB

7. Object Deep Dive,13.1 Official MSDN Documentation for the Worksheet Object.html 139.00Bytes

7. Object Deep Dive,13.2 Official MSDN Documentation for the Worksheet.Visible Property.html 149.00Bytes

7. Object Deep Dive,13.3 Official MSDN Documentation for the XlSheetVisibility Enumeration.html 152.00Bytes

7. Object Deep Dive,14. The Worksheet.Copy Method.mp4 28.70MB

7. Object Deep Dive,14. The Worksheet.Copy Method.srt 6.50KB

7. Object Deep Dive,14.1 Official MSDN Documentation for the Worksheet.Copy Method.html 144.00Bytes

7. Object Deep Dive,15. The Worksheet.Delete Method.mp4 22.35MB

7. Object Deep Dive,15. The Worksheet.Delete Method.srt 4.48KB

7. Object Deep Dive,15.1 Official MSDN Documentation for the Worksheet.Delete Method.html 146.00Bytes

7. Object Deep Dive,16. The Worksheet.Move Method.mp4 24.43MB

7. Object Deep Dive,16. The Worksheet.Move Method.srt 5.12KB

7. Object Deep Dive,16.1 Official MSDN Documentation for the Worksheet.Move Method.html 144.00Bytes

7. Object Deep Dive,2. The Application.DisplayAlerts Property.mp4 47.26MB

7. Object Deep Dive,2. The Application.DisplayAlerts Property.srt 11.72KB

7. Object Deep Dive,2.1 Official MSDN Documentation for the Application.DisplayAlerts Property.html 157.00Bytes

7. Object Deep Dive,3. The Workbooks.Count and Worksheets.Count Properties.mp4 14.27MB

7. Object Deep Dive,3. The Workbooks.Count and Worksheets.Count Properties.srt 3.70KB

7. Object Deep Dive,3.1 Official MSDN Documentation for the Worksheets.Count Property.html 148.00Bytes

7. Object Deep Dive,3.2 Official MSDN Documentation for the Workbooks.Count Property.html 147.00Bytes

7. Object Deep Dive,3.3 Official MSDN Documentation for the Workbooks Object.html 139.00Bytes

7. Object Deep Dive,4. The Workbooks.Open Method and Workbook.Path Property.mp4 37.12MB

7. Object Deep Dive,4. The Workbooks.Open Method and Workbook.Path Property.srt 11.95KB

7. Object Deep Dive,4.1 Official MSDN Documentation for the Workbook.Path Property.html 145.00Bytes

7. Object Deep Dive,4.2 Official MSDN Documentation for the Workbooks.Open Method.html 144.00Bytes

7. Object Deep Dive,5. The Workbooks.Close Method.mp4 9.56MB

7. Object Deep Dive,5. The Workbooks.Close Method.srt 3.15KB

7. Object Deep Dive,5.1 Official MSDN Documentation for the Workbooks.Close Method.html 145.00Bytes

7. Object Deep Dive,6. The Workbooks.Add Method.mp4 34.52MB

7. Object Deep Dive,6. The Workbooks.Add Method.srt 10.34KB

7. Object Deep Dive,6.1 Official MSDN Documentation for the Workbooks.Add Method.html 143.00Bytes

7. Object Deep Dive,7. The Workbook.SaveAs and Workbook.Save Methods.mp4 55.98MB

7. Object Deep Dive,7. The Workbook.SaveAs and Workbook.Save Methods.srt 17.34KB

7. Object Deep Dive,7.1 Official MSDN Documentation for the Workbook Object.html 138.00Bytes

7. Object Deep Dive,7.2 Official MSDN Documentation for the Workbook.SaveAs Method.html 145.00Bytes

7. Object Deep Dive,7.3 Official MSDN Documentation for the XlFileFormat Enumeration.html 147.00Bytes

7. Object Deep Dive,7.4 Official MSDN Documentation for the Workbook.Save Method.html 143.00Bytes

7. Object Deep Dive,8. The Workbook.Activate Method.mp4 42.07MB

7. Object Deep Dive,8. The Workbook.Activate Method.srt 11.58KB

7. Object Deep Dive,8.1 Official MSDN Documentation for the Workbook.Activate Method.html 147.00Bytes

7. Object Deep Dive,9. The Workbook.Close Method.mp4 33.03MB

7. Object Deep Dive,9. The Workbook.Close Method.srt 7.63KB

7. Object Deep Dive,9.1 Official Documentation for the Workbook.Close Method.html 144.00Bytes

8. Range References,1. The Range.Select Method.mp4 16.01MB

8. Range References,1. The Range.Select Method.srt 14.50KB

8. Range References,1.1 Official MSDN Documentation for the Range Object.html 135.00Bytes

8. Range References,1.2 Official MSDN Documentation for the Range.Select Method.html 136.00Bytes

8. Range References,10. The Range.CurrentRegion Property.mp4 9.83MB

8. Range References,10. The Range.CurrentRegion Property.srt 8.08KB

8. Range References,10.1 Official Documentation for the Range.CurrentRegion Property.html 151.00Bytes

8. Range References,11. The Range.End Property.mp4 12.29MB

8. Range References,11. The Range.End Property.srt 14.59KB

8. Range References,11.1 Official Documentation for the XlDirection Enumeration.html 146.00Bytes

8. Range References,11.2 Official Documentation for the Range.End Property.html 141.00Bytes

8. Range References,12. The Range.Count and Range.CountLarge Properties.mp4 6.37MB

8. Range References,12. The Range.Count and Range.CountLarge Properties.srt 5.33KB

8. Range References,12.1 Official Documentation for the Range.Count Property.html 143.00Bytes

8. Range References,13. The Range.Row and Range.Column Properties.mp4 4.49MB

8. Range References,13. The Range.Row and Range.Column Properties.srt 3.72KB

8. Range References,13.1 Official Documentation for the Range.Row Property.html 141.00Bytes

8. Range References,13.2 Official Documentation for the Range.Column Property.html 144.00Bytes

8. Range References,14. The Range.Rows and Range.Columns Properties.mp4 45.44MB

8. Range References,14. The Range.Rows and Range.Columns Properties.srt 11.72KB

8. Range References,14.1 Official Documentation for the Range.Rows Property.html 142.00Bytes

8. Range References,14.2 Official Documentation for the Range.Columns Property.html 145.00Bytes

8. Range References,15. The Range.EntireRow and Range.EntireColumn Properties.mp4 5.55MB

8. Range References,15. The Range.EntireRow and Range.EntireColumn Properties.srt 4.73KB

8. Range References,15.1 Official Documentation for the Range.EntireColumn Property.html 150.00Bytes

8. Range References,15.2 Official Documentation for the Range.EntireRow Property.html 147.00Bytes

8. Range References,16. Get Last Row of Data in Worksheet.mp4 11.79MB

8. Range References,16. Get Last Row of Data in Worksheet.srt 10.69KB

8. Range References,2. The Value vs. Text Properties.mp4 7.10MB

8. Range References,2. The Value vs. Text Properties.srt 6.24KB

8. Range References,2.1 Official MSDN Documentation for the Range.Text Property.html 142.00Bytes

8. Range References,2.2 Official MSDN Documentation for the Range.Value Property.html 143.00Bytes

8. Range References,3. R1C1 Notation, Part I.mp4 18.30MB

8. Range References,3. R1C1 Notation, Part I.srt 16.60KB

8. Range References,4. R1C1 Notation, Part II.mp4 14.73MB

8. Range References,4. R1C1 Notation, Part II.srt 13.91KB

8. Range References,5. The Formula and FormulaR1C1 Properties.mp4 12.66MB

8. Range References,5. The Formula and FormulaR1C1 Properties.srt 11.09KB

8. Range References,5.1 Official MSDN Documentation for the Range.Formula Property.html 145.00Bytes

8. Range References,5.2 Official MSDN Documentation for the Range.FormulaR1C1 Property.html 149.00Bytes

8. Range References,6. The Range.Offset Property.mp4 9.37MB

8. Range References,6. The Range.Offset Property.srt 8.03KB

8. Range References,6.1 Official MSDN Documentation for the Range.Offset Property.html 144.00Bytes

8. Range References,7. The Range.Resize Property.mp4 5.46MB

8. Range References,7. The Range.Resize Property.srt 6.12KB

8. Range References,7.1 Official MSDN Documentation for the Range.Resize Property.html 144.00Bytes

8. Range References,8. The Offset and Resize Properties.html 132.00Bytes

8. Range References,9. The Cells Property.mp4 8.64MB

8. Range References,9. The Cells Property.srt 7.81KB

8. Range References,9.1 Official MSDN Documentation for the Application.Cells Property.html 143.00Bytes

9. Range Actions,1. The Range.FillDown Method.mp4 9.48MB

9. Range Actions,1. The Range.FillDown Method.srt 8.68KB

9. Range Actions,1.1 Official MSDN Documentation for the Range.FillDown Method.html 144.00Bytes

9. Range Actions,10. The Range.Clear, Range.ClearContents and Range.ClearFormats Methods.mp4 7.77MB

9. Range Actions,10. The Range.Clear, Range.ClearContents and Range.ClearFormats Methods.srt 6.91KB

9. Range Actions,10.1 Official MSDN Documentation for the Range.Clear Method.html 141.00Bytes

9. Range Actions,10.2 Official MSDN Documentation for the Range.ClearFormats Method.html 148.00Bytes

9. Range Actions,10.3 Official MSDN Documentation for the Range.ClearContents Method.html 149.00Bytes

9. Range Actions,11. The Range.Delete Method.mp4 10.97MB

9. Range Actions,11. The Range.Delete Method.srt 10.73KB

9. Range Actions,11.1 Official MSDN Documentation for the Range.Delete Method.html 142.00Bytes

9. Range Actions,12. The Range.Copy and Range.Cut Methods.mp4 27.84MB

9. Range Actions,12. The Range.Copy and Range.Cut Methods.srt 6.59KB

9. Range Actions,12.1 Official MSDN Documentation for the Range.Cut Method.html 139.00Bytes

9. Range Actions,12.2 Official MSDN Documentation for the Range.Copy Method.html 140.00Bytes

9. Range Actions,13. The Paste and PasteSpecial Methods on the Worksheet Object.mp4 9.17MB

9. Range Actions,13. The Paste and PasteSpecial Methods on the Worksheet Object.srt 8.58KB

9. Range Actions,13.1 Official MSDN Documentation for the XlPasteType Enumeration.html 146.00Bytes

9. Range Actions,13.2 Official MSDN Documentation for the Worksheet.Paste Method.html 145.00Bytes

9. Range Actions,13.3 Official MSDN Documentation for the Worksheet.PasteSpecial Method.html 152.00Bytes

9. Range Actions,14. The Parent Property on All Objects.mp4 7.37MB

9. Range Actions,14. The Parent Property on All Objects.srt 7.38KB

9. Range Actions,14.1 Official MSDN Documentation for the Application.Parent Property.html 150.00Bytes

9. Range Actions,14.2 Official MSDN Documentation for the Workbook.Parent Property.html 147.00Bytes

9. Range Actions,14.3 Official MSDN Documentation for the Worksheet.Parent.html 148.00Bytes

9. Range Actions,14.4 Official MSDN Documentation for the Range.Parent Property.html 144.00Bytes

9. Range Actions,2. The Range.Replace Method.mp4 8.96MB

9. Range Actions,2. The Range.Replace Method.srt 8.28KB

9. Range Actions,2.1 Official MSDN Documentation for the Range.Replace Method.html 137.00Bytes

9. Range Actions,3. The Range.TextToColumns Method.mp4 18.86MB

9. Range Actions,3. The Range.TextToColumns Method.srt 15.72KB

9. Range Actions,3.1 Official MSDN Documentation for the Range.TextToColumns.html 143.00Bytes

9. Range Actions,4. The Range.Worksheet Property.mp4 3.93MB

9. Range Actions,4. The Range.Worksheet Property.srt 3.57KB

9. Range Actions,4.1 Official MSDN Documentation for the Range.Worksheet Property.html 141.00Bytes

9. Range Actions,5. The Range.Sort Method.mp4 24.14MB

9. Range Actions,5. The Range.Sort Method.srt 21.75KB

9. Range Actions,5.1 Official MSDN Documentation for the Range.Sort Method.html 134.00Bytes

9. Range Actions,6. The Range.Font Property.mp4 17.31MB

9. Range Actions,6. The Range.Font Property.srt 15.58KB

9. Range Actions,6.1 Official MSDN Documentation for the Font Object.html 134.00Bytes

9. Range Actions,7. The Range.Interior Property.mp4 12.80MB

9. Range Actions,7. The Range.Interior Property.srt 11.73KB

9. Range Actions,7.1 Official MSDN Documentation for the Interior Object.html 138.00Bytes

9. Range Actions,7.2 Official MSDN Documentation for the Interior.ColorIndex Property.html 151.00Bytes

9. Range Actions,7.3 Official MSDN Documentation for the Range.Interior Property.html 146.00Bytes

9. Range Actions,8. The Range.ColumnWidth and Range.RowHeight Properties.mp4 12.20MB

9. Range Actions,8. The Range.ColumnWidth and Range.RowHeight Properties.srt 11.30KB

9. Range Actions,8.1 Official MSDN Documentation for the Range.ColumnWidth Property.html 149.00Bytes

9. Range Actions,8.2 Official MSDN Documentation for the Range.RowHeight Property.html 147.00Bytes

9. Range Actions,9. The Range.AutoFit Method.mp4 5.69MB

9. Range Actions,9. The Range.AutoFit Method.srt 5.11KB

9. Range Actions,9.1 Official MSDN Documentation for the Range.AutoFit Method.html 143.00Bytes

[Tutorialsplanet.NET].url 128.00Bytes