/1. Getting Started/
|
1. Introduction.mp4
|
23.8 MB
|
1. Introduction.srt
|
22.0 KB
|
1.1 What's New for VBA in Office 2016.html
|
0.2 KB
|
1.2 Getting Started with VBA in Office.html
|
0.2 KB
|
10. The Visual Basic Editor.mp4
|
16.7 MB
|
10. The Visual Basic Editor.srt
|
16.5 KB
|
10.1 MSDN - Use the Immediate Window.html
|
0.2 KB
|
10.2 MSDN - Use the Properties Window.html
|
0.2 KB
|
10.3 MSDN - Use the Project Explorer.html
|
0.2 KB
|
11. VBA Basics.html
|
0.1 KB
|
2. Download Course Materials.html
|
1.2 KB
|
2.1 vba-course.zip.zip
|
1.7 MB
|
3. Enable the Developer Tab.mp4
|
16.3 MB
|
3. Enable the Developer Tab.srt
|
12.2 KB
|
3.1 Office Support - Show the Developer tab.html
|
0.2 KB
|
4. Excel File Types.mp4
|
8.6 MB
|
4. Excel File Types.srt
|
6.8 KB
|
4.1 Office Support - File formats that are supported in Excel.html
|
0.2 KB
|
4.2 Wikipedia - List of Microsoft Office filename extensions.html
|
0.1 KB
|
5. Macro Security.mp4
|
18.2 MB
|
5. Macro Security.srt
|
15.8 KB
|
5.1 Office Support - Change macro security settings in Excel.html
|
0.2 KB
|
6. The Macro Recorder.mp4
|
29.9 MB
|
6. The Macro Recorder.srt
|
27.8 KB
|
6.1 Getting Started with VBA in Office - To record a macro.html
|
0.2 KB
|
7. Record Macro to Change Worksheet Orientation.html
|
0.1 KB
|
8. Absolute vs. Relative References I.mp4
|
16.2 MB
|
8. Absolute vs. Relative References I.srt
|
14.0 KB
|
8.1 Dummies.com - How to Record Macros in Relative Mode and Absolute Mode in Excel 2016.html
|
0.2 KB
|
9. Absolute vs. Relative References II.mp4
|
17.3 MB
|
9. Absolute vs. Relative References II.srt
|
13.6 KB
|
/10. Conditionals/
|
1. Boolean Expressions.mp4
|
10.9 MB
|
1. Boolean Expressions.srt
|
11.4 KB
|
2. Boolean Expressions.html
|
0.1 KB
|
3. The If Then Statement.mp4
|
7.2 MB
|
3. The If Then Statement.srt
|
7.1 KB
|
3.1 Article How to use the IF-THEN-ELSE Statement.html
|
0.1 KB
|
4. The ElseIf and Else Statements.mp4
|
21.4 MB
|
4. The ElseIf and Else Statements.srt
|
19.0 KB
|
4.1 Official MSDN Article on Using If...Then...Else Statements.html
|
0.2 KB
|
5. Select Case.mp4
|
21.7 MB
|
5. Select Case.srt
|
18.1 KB
|
5.1 Official MSDN Article on Using Select Case Statements.html
|
0.2 KB
|
6. The AND & OR Logical Operators.mp4
|
13.1 MB
|
6. The AND & OR Logical Operators.srt
|
11.9 KB
|
6.1 Official MSDN Reference on the OR Operator.html
|
0.2 KB
|
6.2 Official MSDN Reference on the AND Operator.html
|
0.2 KB
|
7. Logical Operators.html
|
0.1 KB
|
8. The NOT Operator.mp4
|
14.5 MB
|
8. The NOT Operator.srt
|
14.0 KB
|
8.1 Official MSDN Reference on the NOT Operator.html
|
0.2 KB
|
/11. Iteration/
|
1. The For Next Loop.mp4
|
27.1 MB
|
1. The For Next Loop.srt
|
23.3 KB
|
1.1 Official MSDN Article on Using For Next Statements.html
|
0.2 KB
|
2. The Step Keyword.mp4
|
14.2 MB
|
2. The Step Keyword.srt
|
12.3 KB
|
3. Deleting Rows.mp4
|
16.8 MB
|
3. Deleting Rows.srt
|
19.3 KB
|
4. Fill Empty Rows.html
|
0.1 KB
|
5. The For Each-Next Construct.mp4
|
15.5 MB
|
5. The For Each-Next Construct.srt
|
13.0 KB
|
5.1 Official MSDN Article on Using For Each Next Statements.html
|
0.2 KB
|
6. Iterating over a Range of Cells with For Each.mp4
|
11.0 MB
|
6. Iterating over a Range of Cells with For Each.srt
|
11.5 KB
|
7. The With-End With Construct.mp4
|
11.3 MB
|
7. The With-End With Construct.srt
|
12.3 KB
|
7.1 Official MSDN Article on Using With Statements.html
|
0.2 KB
|
8. Exit For and Review of Exit Sub.mp4
|
20.5 MB
|
8. Exit For and Review of Exit Sub.srt
|
21.7 KB
|
8.1 Official MSDN Reference on the Exit Statement.html
|
0.2 KB
|
9. Iteration.html
|
0.1 KB
|
/12. Miscellaneous Features/
|
1. The MsgBox Method In Depth, Part I.mp4
|
46.1 MB
|
1. The MsgBox Method In Depth, Part I.srt
|
15.2 KB
|
1.1 Official Visual Basic for Applications Reference for the MsgBox Function.html
|
0.2 KB
|
2. The MsgBox Method In Depth, Part II.mp4
|
51.9 MB
|
2. The MsgBox Method In Depth, Part II.srt
|
13.8 KB
|
3. MsgBox Options.html
|
1.1 KB
|
4. StatusBar.mp4
|
38.4 MB
|
4. StatusBar.srt
|
11.2 KB
|
4.1 Official MSDN Documentation for the Application.StatusBar Property.html
|
0.2 KB
|
5. The Application.ScreenUpdating Property.mp4
|
6.5 MB
|
5. The Application.ScreenUpdating Property.srt
|
7.4 KB
|
5.1 Official MSDN Documentation for the Application.ScreenUpdating Property.html
|
0.2 KB
|
6. SpecialCells.mp4
|
8.7 MB
|
6. SpecialCells.srt
|
9.9 KB
|
6.1 Official MSDN Documentation for the Range.SpecialCells Method.html
|
0.1 KB
|
7. The InputBox Function.mp4
|
12.9 MB
|
7. The InputBox Function.srt
|
16.4 KB
|
7.1 Official Microsoft documentation for the InputBox Function.html
|
0.2 KB
|
8. The Application.InputBox Method.mp4
|
15.2 MB
|
8. The Application.InputBox Method.srt
|
16.6 KB
|
8.1 Official MSDN Documentation for the Application.InputBox Method.html
|
0.2 KB
|
/13. Arrays/
|
1. Intro to Arrays.mp4
|
8.4 MB
|
1. Intro to Arrays.srt
|
11.6 KB
|
1.1 Official MSDN Article on Declaring Arrays.html
|
0.1 KB
|
1.2 Official MSDN Article on Using Arrays.html
|
0.1 KB
|
2. Alternate Syntax for Fixed-Size Arrays.mp4
|
6.5 MB
|
2. Alternate Syntax for Fixed-Size Arrays.srt
|
8.6 KB
|
3. The Option Base 1 Syntax and Write Array Values to Cells.mp4
|
6.6 MB
|
3. The Option Base 1 Syntax and Write Array Values to Cells.srt
|
7.6 KB
|
4. Initialize Arrays within a For Loop.mp4
|
11.7 MB
|
4. Initialize Arrays within a For Loop.srt
|
10.2 KB
|
5. The LBound and UBound Methods.mp4
|
10.1 MB
|
5. The LBound and UBound Methods.srt
|
11.2 KB
|
6. Dynamic Arrays.mp4
|
18.7 MB
|
6. Dynamic Arrays.srt
|
17.1 KB
|
7. The Range.RemoveDuplicates Method.mp4
|
8.6 MB
|
7. The Range.RemoveDuplicates Method.srt
|
7.5 KB
|
7.1 Official MSDN Documentation for the Range.RemoveDuplicates Method.html
|
0.1 KB
|
/14. Functions/
|
1. VBA Functions, Part I.mp4
|
16.9 MB
|
1. VBA Functions, Part I.srt
|
16.3 KB
|
1.1 Complete Listing of all VBA Functions.html
|
0.1 KB
|
2. VBA Functions, Part II.mp4
|
10.0 MB
|
2. VBA Functions, Part II.srt
|
11.9 KB
|
2.1 Complete Listing of all VBA Functions.html
|
0.1 KB
|
3. The Split Function.mp4
|
8.6 MB
|
3. The Split Function.srt
|
7.7 KB
|
3.1 Tech on the Net Article on the VBA Split Function.html
|
0.1 KB
|
4. The Is Family of Functions.mp4
|
82.8 MB
|
4. The Is Family of Functions.srt
|
18.6 KB
|
4.1 Tech on the Net Article on the IsError Function.html
|
0.1 KB
|
4.2 Tech on the Net Article on the IsDate Function.html
|
0.1 KB
|
4.3 Tech on the Net Article on the IsEmpty Function.html
|
0.1 KB
|
4.4 Tech on the Net Article on the IsNumeric Function.html
|
0.1 KB
|
5. Date and Time Functions.mp4
|
31.8 MB
|
5. Date and Time Functions.srt
|
8.1 KB
|
5.1 Tech on the Net Article on the DateSerial Function.html
|
0.1 KB
|
5.2 Tech on the Net Article on the Date Function.html
|
0.1 KB
|
5.3 Tech on the Net Article on the Now Function.html
|
0.1 KB
|
6. More Date and Time Functions.mp4
|
31.9 MB
|
6. More Date and Time Functions.srt
|
10.6 KB
|
6.1 Tech on the Net Article on the Weekday Function.html
|
0.1 KB
|
6.2 Tech on the Net Article on the Minute Function.html
|
0.1 KB
|
6.3 Tech on the Net Article on the Year Function.html
|
0.1 KB
|
6.4 Tech on the Net Article on the MonthName Function.html
|
0.1 KB
|
6.5 Tech on the Net Article on the Month Function.html
|
0.1 KB
|
6.6 Tech on the Net Article on the Hour Function.html
|
0.1 KB
|
6.7 Tech on the Net Article on the Day Function.html
|
0.1 KB
|
6.8 Tech on the Net Article on the Second Function.html
|
0.1 KB
|
6.9 Tech on the Net Article on the WeekdayName Function.html
|
0.1 KB
|
7. Excel Worksheet Functions.mp4
|
13.1 MB
|
7. Excel Worksheet Functions.srt
|
15.1 KB
|
8. Custom Functions.mp4
|
16.0 MB
|
8. Custom Functions.srt
|
19.6 KB
|
8.1 Official MSDN Article on Writing A Function Procedure.html
|
0.2 KB
|
/15. Debugging/
|
1. Intro to Error Handling.mp4
|
12.9 MB
|
1. Intro to Error Handling.srt
|
13.3 KB
|
2. The OnError and GoTo Keywords.mp4
|
13.8 MB
|
2. The OnError and GoTo Keywords.srt
|
12.1 KB
|
3. The OnError Resume Next Keywords.mp4
|
10.5 MB
|
3. The OnError Resume Next Keywords.srt
|
9.5 KB
|
4. Error and Err.Number.mp4
|
17.1 MB
|
4. Error and Err.Number.srt
|
13.6 KB
|
5. Stepping Through Code.mp4
|
12.3 MB
|
5. Stepping Through Code.srt
|
15.2 KB
|
6. Breakpoints.mp4
|
9.2 MB
|
6. Breakpoints.srt
|
11.3 KB
|
/16. Events/
|
1. Introduction to Events.mp4
|
30.7 MB
|
1. Introduction to Events.srt
|
13.0 KB
|
2. The Worksheet_SelectionChange Event.mp4
|
13.1 MB
|
2. The Worksheet_SelectionChange Event.srt
|
11.1 KB
|
2.1 Official MSDN Documentation for the Worksheet.SelectionChange Event.html
|
0.2 KB
|
3. Review of Application.EnableEvents.mp4
|
5.4 MB
|
3. Review of Application.EnableEvents.srt
|
6.4 KB
|
3.1 Official MSDN Documentation for the Application.EnableEvents Property.html
|
0.2 KB
|
4. The Worksheet_Change Event.mp4
|
20.1 MB
|
4. The Worksheet_Change Event.srt
|
23.3 KB
|
4.1 Official MSDN Documentation for the Worksheet.Change Event.html
|
0.1 KB
|
5. The Worksheet_Activate Event.mp4
|
4.3 MB
|
5. The Worksheet_Activate Event.srt
|
5.0 KB
|
5.1 Official MSDN Documentation for the Worksheet.Activate Event.html
|
0.1 KB
|
6. Highlight Row and Column Up to Cell Where Cursor Is Placed.html
|
0.1 KB
|
7. Workbook Events and The Sh Argument.mp4
|
14.1 MB
|
7. Workbook Events and The Sh Argument.srt
|
14.5 KB
|
7.1 Official MSDN Documentation for the Workbook.SheetChange Event.html
|
0.1 KB
|
8. The Workbook_Open Event.mp4
|
5.9 MB
|
8. The Workbook_Open Event.srt
|
5.2 KB
|
8.1 Official MSDN Documentation for the Workbook.Open Event.html
|
0.1 KB
|
9. Procedures with Boolean Arguments + The Workbook_BeforePrint Event.mp4
|
6.3 MB
|
9. Procedures with Boolean Arguments + The Workbook_BeforePrint Event.srt
|
6.8 KB
|
9.1 Official MSDN Documentation for the Workbook.BeforePrint Event.html
|
0.1 KB
|
/17. User Forms/
|
1. Create UserForm, Toolbox, Properties, Controls.mp4
|
11.0 MB
|
1. Create UserForm, Toolbox, Properties, Controls.srt
|
13.0 KB
|
10. Activate a UserForm from Procedure.mp4
|
5.8 MB
|
10. Activate a UserForm from Procedure.srt
|
6.5 KB
|
11. The initialize Event.mp4
|
12.0 MB
|
11. The initialize Event.srt
|
14.8 KB
|
12. The ListBox Control I - Wire up the Form.mp4
|
13.4 MB
|
12. The ListBox Control I - Wire up the Form.srt
|
14.5 KB
|
13. The ListBox Control II - React to User Selection.mp4
|
15.7 MB
|
13. The ListBox Control II - React to User Selection.srt
|
12.7 KB
|
14. The ListBox Control III - Select Multiple Items.mp4
|
20.4 MB
|
14. The ListBox Control III - Select Multiple Items.srt
|
16.8 KB
|
15. The ComboBox Control I.mp4
|
10.1 MB
|
15. The ComboBox Control I.srt
|
10.6 KB
|
16. The ComboBox Control II.mp4
|
18.4 MB
|
16. The ComboBox Control II.srt
|
18.5 KB
|
17. The CheckBox Control.mp4
|
20.9 MB
|
17. The CheckBox Control.srt
|
17.4 KB
|
2. The Label and TextBox Controls.mp4
|
9.8 MB
|
2. The Label and TextBox Controls.srt
|
8.8 KB
|
3. Naming Conventions.mp4
|
5.1 MB
|
3. Naming Conventions.srt
|
6.1 KB
|
4. Naming Conventions.html
|
0.7 KB
|
5. Design Aesthetics.mp4
|
10.0 MB
|
5. Design Aesthetics.srt
|
10.2 KB
|
6. The CommandButton Control.mp4
|
7.7 MB
|
6. The CommandButton Control.srt
|
6.6 KB
|
7. Add Event Procedure to Control.mp4
|
8.4 MB
|
7. Add Event Procedure to Control.srt
|
8.9 KB
|
8. Unload and Hide a UserForm.mp4
|
13.2 MB
|
8. Unload and Hide a UserForm.srt
|
11.7 KB
|
9. Submit the UserForm.mp4
|
18.0 MB
|
9. Submit the UserForm.srt
|
15.2 KB
|
/2. The Fundamentals of the Excel Object Model/
|
1. Object-Oriented Programming in Real Life.mp4
|
20.5 MB
|
1. Object-Oriented Programming in Real Life.srt
|
20.1 KB
|
2. Real Life Objects.html
|
0.1 KB
|
3. Collection Objects in Real Life.mp4
|
10.9 MB
|
3. Collection Objects in Real Life.srt
|
8.9 KB
|
4. Objects As Properties.mp4
|
16.6 MB
|
4. Objects As Properties.srt
|
13.7 KB
|
4.1 Dummies.com - An Overview of the Excel Object Model.html
|
0.2 KB
|
5. The Excel Object Model.mp4
|
25.4 MB
|
5. The Excel Object Model.srt
|
25.6 KB
|
5.1 Dummies.com - An Overview of the Excel Object Model.html
|
0.2 KB
|
6. Access Object from Collection by Name.mp4
|
7.8 MB
|
6. Access Object from Collection by Name.srt
|
6.7 KB
|
7. Default Properties.mp4
|
7.0 MB
|
7. Default Properties.srt
|
6.0 KB
|
7.1 Stack Overflow - Is “Value” actually the default property of the Range object.html
|
0.2 KB
|
8. The Name Property on Workbook and Worksheet Objects.mp4
|
7.8 MB
|
8. The Name Property on Workbook and Worksheet Objects.srt
|
6.8 KB
|
8.1 Official MSDN Documentation for the Workbook.Name Property.html
|
0.1 KB
|
8.2 Official MSDN Documentation for the Worksheet.Name Property.html
|
0.1 KB
|
9. Object-Oriented Programming.html
|
0.1 KB
|
/3. The Visual Basic Editor/
|
1. Visual Basic Editor Options.mp4
|
18.0 MB
|
1. Visual Basic Editor Options.srt
|
24.0 KB
|
1.1 Official MSDN Article on Configuring Options in the Visual Basic Editor.html
|
0.2 KB
|
2. Create and Delete a Procedure.mp4
|
16.2 MB
|
2. Create and Delete a Procedure.srt
|
15.1 KB
|
2.1 Official MSDN Article on Writing a Procedure.html
|
0.2 KB
|
3. Procedures.html
|
0.1 KB
|
4. The Immediate Window and Debug.Print Method.mp4
|
16.9 MB
|
4. The Immediate Window and Debug.Print Method.srt
|
15.4 KB
|
4.1 Official MSDN Article on the Debug Object.html
|
0.1 KB
|
4.2 Official MSDN Article on Using the Immediate Window.html
|
0.2 KB
|
5. The MsgBox Method.mp4
|
27.2 MB
|
5. The MsgBox Method.srt
|
23.2 KB
|
5.1 Official MSDN Reference Article on the MsgBox Method.html
|
0.1 KB
|
6. Comments.mp4
|
10.5 MB
|
6. Comments.srt
|
9.0 KB
|
6.1 Official MSDN Tutorial on Adding Comments to Code.html
|
0.1 KB
|
7. Practice with Procedures.html
|
0.1 KB
|
8. The Visual Basic Editor.html
|
0.1 KB
|
/4. Objects and Methods/
|
1. Methods without Arguments.mp4
|
5.3 MB
|
1. Methods without Arguments.srt
|
5.8 KB
|
1.1 Office VBA Reference - Understanding Objects, Properties, Methods, and Events.html
|
0.2 KB
|
2. Methods without Arguments.html
|
0.1 KB
|
3. Methods with Arguments.mp4
|
21.0 MB
|
3. Methods with Arguments.srt
|
15.0 KB
|
3.1 Official MSDN Documentation for the Worksheet Object.html
|
0.1 KB
|
3.2 Official MSDN Documentation for the Worksheet.Protect Method.html
|
0.1 KB
|
4. Methods with Arguments.html
|
0.1 KB
|
5. Methods with Multiple Arguments.mp4
|
13.2 MB
|
5. Methods with Multiple Arguments.srt
|
12.2 KB
|
6. The Object Browser.mp4
|
12.2 MB
|
6. The Object Browser.srt
|
9.8 KB
|
6.1 Official MSDN Article on using the Object Browser.html
|
0.2 KB
|
7. Ways to Invoke A Procedure.mp4
|
17.2 MB
|
7. Ways to Invoke A Procedure.srt
|
14.2 KB
|
8. The TypeName Method.mp4
|
10.6 MB
|
8. The TypeName Method.srt
|
10.4 KB
|
8.1 Official MSDN Documentation for the TypeName Function.html
|
0.1 KB
|
9. Objects and Methods.html
|
0.1 KB
|
/5. Variables and Data Types/
|
1. Syntax Tips.mp4
|
15.3 MB
|
1. Syntax Tips.srt
|
13.5 KB
|
1.1 Official MSDN Documentation for Understanding Visual Basic Syntax.html
|
0.2 KB
|
1.2 Official MSDN Documentation for Writing Visual Basic Statements.html
|
0.2 KB
|
10. String and Double Data Types.html
|
0.1 KB
|
11. The Boolean Data Type.mp4
|
7.6 MB
|
11. The Boolean Data Type.srt
|
7.3 KB
|
11.1 Official MSDN Documentation for the Boolean Data Type.html
|
0.2 KB
|
12. The Date Data Type.mp4
|
12.5 MB
|
12. The Date Data Type.srt
|
10.5 KB
|
12.1 Official MSDN Documentation for the Date Data Type.html
|
0.2 KB
|
13. The Variant Data Type.mp4
|
10.8 MB
|
13. The Variant Data Type.srt
|
9.4 KB
|
13.1 Official MSDN Article on Understanding Variants.html
|
0.2 KB
|
14. The Object Data Type.mp4
|
15.7 MB
|
14. The Object Data Type.srt
|
13.3 KB
|
15. Default Values for Declared Variables.mp4
|
5.1 MB
|
15. Default Values for Declared Variables.srt
|
5.0 KB
|
16. Variable Declarations.html
|
0.1 KB
|
2. Variable Declarations and Assignments.mp4
|
19.4 MB
|
2. Variable Declarations and Assignments.srt
|
16.4 KB
|
2.1 Official MSDN Documentation for Declaring Variables.html
|
0.1 KB
|
2.2 Official MSDN Documentation for Writing Declaration Statements.html
|
0.2 KB
|
2.3 Official MSDN Documentation for Visual Basic Naming Rules.html
|
0.2 KB
|
2.4 Official MSDN Documentation for Writing Assignment Statements.html
|
0.2 KB
|
2.5 Official MSDN Documentation for Using Data Types Efficiently.html
|
0.2 KB
|
3. Multiple Variable Declarations.mp4
|
8.6 MB
|
3. Multiple Variable Declarations.srt
|
7.1 KB
|
4. The Option Explicit Setting.mp4
|
7.8 MB
|
4. The Option Explicit Setting.srt
|
10.7 KB
|
4.1 Official MSDN Documentation for the Option Explicit Statement.html
|
0.2 KB
|
5. The Byte, Integer and Long Data Types.mp4
|
13.8 MB
|
5. The Byte, Integer and Long Data Types.srt
|
13.8 KB
|
5.1 Official MSDN Documentation for the Byte Data Type.html
|
0.2 KB
|
5.2 Official MSDN Documentation for the Integer Data Type.html
|
0.2 KB
|
5.3 Official MSDN Documentation for the Long Data Type.html
|
0.2 KB
|
6. Numeric Data Types.html
|
0.1 KB
|
7. Mathematical Operations.mp4
|
10.7 MB
|
7. Mathematical Operations.srt
|
10.6 KB
|
8. The Single and Double Data Types.mp4
|
10.8 MB
|
8. The Single and Double Data Types.srt
|
10.5 KB
|
8.1 Official MSDN Documentation for the Single Data Type.html
|
0.2 KB
|
8.2 Official MSDN Documentation for the Double Data Type.html
|
0.2 KB
|
9. The String Data Type.mp4
|
8.9 MB
|
9. The String Data Type.srt
|
8.9 KB
|
9.1 Official MSDN Documentation for the String Data Type.html
|
0.2 KB
|
/6. Procedures/
|
1. Variable Scope.mp4
|
13.9 MB
|
1. Variable Scope.srt
|
17.2 KB
|
2. Call A Procedure from Another one.mp4
|
7.0 MB
|
2. Call A Procedure from Another one.srt
|
6.9 KB
|
3. Procedures with Arguments.mp4
|
14.7 MB
|
3. Procedures with Arguments.srt
|
12.6 KB
|
4. Procedure Scope (Public vs. Private).mp4
|
13.9 MB
|
4. Procedure Scope (Public vs. Private).srt
|
11.9 KB
|
5. The Exit Sub Keywords.mp4
|
3.1 MB
|
5. The Exit Sub Keywords.srt
|
3.5 KB
|
5.1 Official MSDN Documentation on the Exit Statement.html
|
0.2 KB
|
6. Constants.mp4
|
12.0 MB
|
6. Constants.srt
|
11.7 KB
|
6.1 Official MSDN Article on Using Constants.html
|
0.1 KB
|
6.2 Official MSDN Article on Declaring Constants.html
|
0.1 KB
|
7. Predefined Constants.mp4
|
23.6 MB
|
7. Predefined Constants.srt
|
19.0 KB
|
7.1 Official MSDN Documentation for the PageSetup Object.html
|
0.1 KB
|
7.2 Official MSDN Documentation for the xlPageOrientation Enumeration.html
|
0.2 KB
|
8. Procedures.html
|
0.1 KB
|
/7. Object Deep Dive/
|
1. The Application Object.mp4
|
26.1 MB
|
1. The Application Object.srt
|
7.4 KB
|
1.1 Official MSDN Documentation for the Application.Name Property.html
|
0.1 KB
|
1.2 Official MSDN Documentation for the Application.Path Property.html
|
0.1 KB
|
1.3 Official MSDN Documentation for the Application Object.html
|
0.1 KB
|
1.4 Official MSDN Documentation for the Application.UserName Property.html
|
0.2 KB
|
1.5 Official MSDN Documentation for the Application.Quit Method.html
|
0.1 KB
|
1.6 Official MSDN Documentation for the Application.Version Property.html
|
0.2 KB
|
10. The Application, Workbooks and Workbook Objects.html
|
0.1 KB
|
11. The Worksheets.Add Method.mp4
|
42.1 MB
|
11. The Worksheets.Add Method.srt
|
9.0 KB
|
11.1 Official MSDN Documentation for the Worksheets Object.html
|
0.1 KB
|
11.2 Official MSDN Documentation for the Worksheets.Add Method.html
|
0.1 KB
|
12. Add a New Worksheet to End of Current List of Worksheets.html
|
0.1 KB
|
13. The Worksheet.Visible Property.mp4
|
36.8 MB
|
13. The Worksheet.Visible Property.srt
|
9.1 KB
|
13.1 Official MSDN Documentation for the XlSheetVisibility Enumeration.html
|
0.2 KB
|
13.2 Official MSDN Documentation for the Worksheet.Visible Property.html
|
0.1 KB
|
13.3 Official MSDN Documentation for the Worksheet Object.html
|
0.1 KB
|
14. The Worksheet.Copy Method.mp4
|
30.1 MB
|
14. The Worksheet.Copy Method.srt
|
6.7 KB
|
14.1 Official MSDN Documentation for the Worksheet.Copy Method.html
|
0.1 KB
|
15. The Worksheet.Delete Method.mp4
|
23.4 MB
|
15. The Worksheet.Delete Method.srt
|
4.6 KB
|
15.1 Official MSDN Documentation for the Worksheet.Delete Method.html
|
0.1 KB
|
16. The Worksheet.Move Method.mp4
|
25.6 MB
|
16. The Worksheet.Move Method.srt
|
5.2 KB
|
16.1 Official MSDN Documentation for the Worksheet.Move Method.html
|
0.1 KB
|
2. The Application.DisplayAlerts Property.mp4
|
49.6 MB
|
2. The Application.DisplayAlerts Property.srt
|
12.0 KB
|
2.1 Official MSDN Documentation for the Application.DisplayAlerts Property.html
|
0.2 KB
|
3. The Workbooks.Count and Worksheets.Count Properties.mp4
|
15.0 MB
|
3. The Workbooks.Count and Worksheets.Count Properties.srt
|
3.8 KB
|
3.1 Official MSDN Documentation for the Worksheets.Count Property.html
|
0.1 KB
|
3.2 Official MSDN Documentation for the Workbooks.Count Property.html
|
0.1 KB
|
3.3 Official MSDN Documentation for the Workbooks Object.html
|
0.1 KB
|
4. The Workbooks.Open Method and Workbook.Path Property.mp4
|
38.9 MB
|
4. The Workbooks.Open Method and Workbook.Path Property.srt
|
12.2 KB
|
4.1 Official MSDN Documentation for the Workbooks.Open Method.html
|
0.1 KB
|
4.2 Official MSDN Documentation for the Workbook.Path Property.html
|
0.1 KB
|
5. The Workbooks.Close Method.mp4
|
10.0 MB
|
5. The Workbooks.Close Method.srt
|
3.2 KB
|
5.1 Official MSDN Documentation for the Workbooks.Close Method.html
|
0.1 KB
|
6. The Workbooks.Add Method.mp4
|
36.2 MB
|
6. The Workbooks.Add Method.srt
|
10.6 KB
|
6.1 Official MSDN Documentation for the Workbooks.Add Method.html
|
0.1 KB
|
7. The Workbook.SaveAs and Workbook.Save Methods.mp4
|
58.7 MB
|
7. The Workbook.SaveAs and Workbook.Save Methods.srt
|
17.8 KB
|
7.1 Official MSDN Documentation for the Workbook.SaveAs Method.html
|
0.1 KB
|
7.2 Official MSDN Documentation for the XlFileFormat Enumeration.html
|
0.1 KB
|
7.3 Official MSDN Documentation for the Workbook Object.html
|
0.1 KB
|
7.4 Official MSDN Documentation for the Workbook.Save Method.html
|
0.1 KB
|
8. The Workbook.Activate Method.mp4
|
44.1 MB
|
8. The Workbook.Activate Method.srt
|
11.9 KB
|
8.1 Official MSDN Documentation for the Workbook.Activate Method.html
|
0.1 KB
|
9. The Workbook.Close Method.mp4
|
34.6 MB
|
9. The Workbook.Close Method.srt
|
7.8 KB
|
9.1 Official Documentation for the Workbook.Close Method.html
|
0.1 KB
|
/8. Range References/
|
1. The Range.Select Method.mp4
|
16.8 MB
|
1. The Range.Select Method.srt
|
14.9 KB
|
1.1 Official MSDN Documentation for the Range Object.html
|
0.1 KB
|
1.2 Official MSDN Documentation for the Range.Select Method.html
|
0.1 KB
|
10. The Range.CurrentRegion Property.mp4
|
10.3 MB
|
10. The Range.CurrentRegion Property.srt
|
8.3 KB
|
10.1 Official Documentation for the Range.CurrentRegion Property.html
|
0.2 KB
|
11. The Range.End Property.mp4
|
12.9 MB
|
11. The Range.End Property.srt
|
14.9 KB
|
11.1 Official Documentation for the XlDirection Enumeration.html
|
0.1 KB
|
11.2 Official Documentation for the Range.End Property.html
|
0.1 KB
|
12. The Range.Count and Range.CountLarge Properties.mp4
|
6.7 MB
|
12. The Range.Count and Range.CountLarge Properties.srt
|
5.5 KB
|
12.1 Official Documentation for the Range.Count Property.html
|
0.1 KB
|
13. The Range.Row and Range.Column Properties.mp4
|
4.7 MB
|
13. The Range.Row and Range.Column Properties.srt
|
3.8 KB
|
13.1 Official Documentation for the Range.Column Property.html
|
0.1 KB
|
13.2 Official Documentation for the Range.Row Property.html
|
0.1 KB
|
14. The Range.Rows and Range.Columns Properties.mp4
|
47.6 MB
|
14. The Range.Rows and Range.Columns Properties.srt
|
12.0 KB
|
14.1 Official Documentation for the Range.Rows Property.html
|
0.1 KB
|
14.2 Official Documentation for the Range.Columns Property.html
|
0.1 KB
|
15. The Range.EntireRow and Range.EntireColumn Properties.mp4
|
5.8 MB
|
15. The Range.EntireRow and Range.EntireColumn Properties.srt
|
4.8 KB
|
15.1 Official Documentation for the Range.EntireRow Property.html
|
0.1 KB
|
15.2 Official Documentation for the Range.EntireColumn Property.html
|
0.2 KB
|
16. Get Last Row of Data in Worksheet.mp4
|
12.4 MB
|
16. Get Last Row of Data in Worksheet.srt
|
11.0 KB
|
2. The Value vs. Text Properties.mp4
|
7.4 MB
|
2. The Value vs. Text Properties.srt
|
6.4 KB
|
2.1 Official MSDN Documentation for the Range.Text Property.html
|
0.1 KB
|
2.2 Official MSDN Documentation for the Range.Value Property.html
|
0.1 KB
|
3. R1C1 Notation, Part I.mp4
|
19.2 MB
|
3. R1C1 Notation, Part I.srt
|
17.0 KB
|
4. R1C1 Notation, Part II.mp4
|
15.4 MB
|
4. R1C1 Notation, Part II.srt
|
14.2 KB
|
5. The Formula and FormulaR1C1 Properties.mp4
|
13.3 MB
|
5. The Formula and FormulaR1C1 Properties.srt
|
11.4 KB
|
5.1 Official MSDN Documentation for the Range.FormulaR1C1 Property.html
|
0.1 KB
|
5.2 Official MSDN Documentation for the Range.Formula Property.html
|
0.1 KB
|
6. The Range.Offset Property.mp4
|
9.8 MB
|
6. The Range.Offset Property.srt
|
8.2 KB
|
6.1 Official MSDN Documentation for the Range.Offset Property.html
|
0.1 KB
|
7. The Range.Resize Property.mp4
|
5.7 MB
|
7. The Range.Resize Property.srt
|
6.3 KB
|
7.1 Official MSDN Documentation for the Range.Resize Property.html
|
0.1 KB
|
8. The Offset and Resize Properties.html
|
0.1 KB
|
9. The Cells Property.mp4
|
9.1 MB
|
9. The Cells Property.srt
|
8.0 KB
|
9.1 Official MSDN Documentation for the Application.Cells Property.html
|
0.1 KB
|
/9. Range Actions/
|
1. The Range.FillDown Method.mp4
|
9.9 MB
|
1. The Range.FillDown Method.srt
|
8.9 KB
|
1.1 Official MSDN Documentation for the Range.FillDown Method.html
|
0.1 KB
|
10. The Range.Clear, Range.ClearContents and Range.ClearFormats Methods.mp4
|
8.1 MB
|
10. The Range.Clear, Range.ClearContents and Range.ClearFormats Methods.srt
|
7.1 KB
|
10.1 Official MSDN Documentation for the Range.ClearFormats Method.html
|
0.1 KB
|
10.2 Official MSDN Documentation for the Range.Clear Method.html
|
0.1 KB
|
10.3 Official MSDN Documentation for the Range.ClearContents Method.html
|
0.1 KB
|
11. The Range.Delete Method.mp4
|
11.5 MB
|
11. The Range.Delete Method.srt
|
11.0 KB
|
11.1 Official MSDN Documentation for the Range.Delete Method.html
|
0.1 KB
|
12. The Range.Copy and Range.Cut Methods.mp4
|
29.2 MB
|
12. The Range.Copy and Range.Cut Methods.srt
|
6.7 KB
|
12.1 Official MSDN Documentation for the Range.Copy Method.html
|
0.1 KB
|
12.2 Official MSDN Documentation for the Range.Cut Method.html
|
0.1 KB
|
13. The Paste and PasteSpecial Methods on the Worksheet Object.mp4
|
9.6 MB
|
13. The Paste and PasteSpecial Methods on the Worksheet Object.srt
|
8.8 KB
|
13.1 Official MSDN Documentation for the Worksheet.Paste Method.html
|
0.1 KB
|
13.2 Official MSDN Documentation for the Worksheet.PasteSpecial Method.html
|
0.2 KB
|
13.3 Official MSDN Documentation for the XlPasteType Enumeration.html
|
0.1 KB
|
14. The Parent Property on All Objects.mp4
|
7.7 MB
|
14. The Parent Property on All Objects.srt
|
7.6 KB
|
14.1 Official MSDN Documentation for the Workbook.Parent Property.html
|
0.1 KB
|
14.2 Official MSDN Documentation for the Worksheet.Parent.html
|
0.1 KB
|
14.3 Official MSDN Documentation for the Range.Parent Property.html
|
0.1 KB
|
14.4 Official MSDN Documentation for the Application.Parent Property.html
|
0.2 KB
|
2. The Range.Replace Method.mp4
|
9.4 MB
|
2. The Range.Replace Method.srt
|
8.5 KB
|
2.1 Official MSDN Documentation for the Range.Replace Method.html
|
0.1 KB
|
3. The Range.TextToColumns Method.mp4
|
19.8 MB
|
3. The Range.TextToColumns Method.srt
|
16.1 KB
|
3.1 Official MSDN Documentation for the Range.TextToColumns.html
|
0.1 KB
|
4. The Range.Worksheet Property.mp4
|
4.1 MB
|
4. The Range.Worksheet Property.srt
|
3.7 KB
|
4.1 Official MSDN Documentation for the Range.Worksheet Property.html
|
0.1 KB
|
5. The Range.Sort Method.mp4
|
25.3 MB
|
5. The Range.Sort Method.srt
|
22.3 KB
|
5.1 Official MSDN Documentation for the Range.Sort Method.html
|
0.1 KB
|
6. The Range.Font Property.mp4
|
18.1 MB
|
6. The Range.Font Property.srt
|
15.9 KB
|
6.1 Official MSDN Documentation for the Font Object.html
|
0.1 KB
|
7. The Range.Interior Property.mp4
|
13.4 MB
|
7. The Range.Interior Property.srt
|
12.0 KB
|
7.1 Official MSDN Documentation for the Interior.ColorIndex Property.html
|
0.2 KB
|
7.2 Official MSDN Documentation for the Range.Interior Property.html
|
0.1 KB
|
7.3 Official MSDN Documentation for the Interior Object.html
|
0.1 KB
|
8. The Range.ColumnWidth and Range.RowHeight Properties.mp4
|
12.8 MB
|
8. The Range.ColumnWidth and Range.RowHeight Properties.srt
|
11.6 KB
|
8.1 Official MSDN Documentation for the Range.ColumnWidth Property.html
|
0.1 KB
|
8.2 Official MSDN Documentation for the Range.RowHeight Property.html
|
0.1 KB
|
9. The Range.AutoFit Method.mp4
|
6.0 MB
|
9. The Range.AutoFit Method.srt
|
5.2 KB
|
9.1 Official MSDN Documentation for the Range.AutoFit Method.html
|
0.1 KB
|
/
|
[CourseClub.Me].url
|
0.0 KB
|
[DesireCourse.Net].url
|
0.1 KB
|
Total files 503
|