Udemy Excel VBA Programming The Complete Guide

/14. Functions/

4. The Is Family of Functions.mp4

1. VBA Functions, Part I.mp4

1.1 Complete Listing of all VBA Functions.html

2. VBA Functions, Part II.mp4

2.1 Complete Listing of all VBA Functions.html

3. The Split Function.mp4

3.1 Tech on the Net Article on the VBA Split Function.html

4.1 Tech on the Net Article on the IsDate Function.html

4.2 Tech on the Net Article on the IsNumeric Function.html

4.3 Tech on the Net Article on the IsError Function.html

4.4 Tech on the Net Article on the IsEmpty Function.html

5. Date and Time Functions.mp4

5.1 Tech on the Net Article on the Date Function.html

5.2 Tech on the Net Article on the DateSerial Function.html

5.3 Tech on the Net Article on the Now Function.html

6. More Date and Time Functions.mp4

6.1 Tech on the Net Article on the Minute Function.html

6.2 Tech on the Net Article on the Month Function.html

6.3 Tech on the Net Article on the MonthName Function.html

6.4 Tech on the Net Article on the Hour Function.html

6.5 Tech on the Net Article on the Year Function.html

6.6 Tech on the Net Article on the Day Function.html

6.7 Tech on the Net Article on the Second Function.html

6.8 Tech on the Net Article on the Weekday Function.html

6.9 Tech on the Net Article on the WeekdayName Function.html

7. Excel Worksheet Functions.mp4

8. Custom Functions.mp4

8.1 Official MSDN Article on Writing A Function Procedure.html

/1. Getting Started/

1.1 What's New for VBA in Office 2016.html

1.2 Getting Started with VBA in Office.html

2. Download Course Materials.html

2.1 vba-course.zip.zip

3. Enable the Developer Tab.mp4

3.1 Office Support - Show the Developer tab.html

4. Excel File Types.mp4

4.1 Office Support - File formats that are supported in Excel.html

4.2 Wikipedia - List of Microsoft Office filename extensions.html

5. Macro Security.mp4

5.1 Office Support - Change macro security settings in Excel.html

6. The Macro Recorder.mp4

6.1 Getting Started with VBA in Office - To record a macro.html

7. Record Macro to Change Worksheet Orientation.html

8. Absolute vs. Relative References I.mp4

8.1 Dummies.com - How to Record Macros in Relative Mode and Absolute Mode in Excel 2016.html

9. Absolute vs. Relative References II.mp4

10. The Visual Basic Editor.mp4

10.1 MSDN - Use the Properties Window.html

10.2 MSDN - Use the Project Explorer.html

10.3 MSDN - Use the Immediate Window.html

11. VBA Basics.html

1. Introduction.mp4

/2. The Fundamentals of the Excel Object Model/

1. Object-Oriented Programming in Real Life.mp4

2. Real Life Objects.html

3. Collection Objects in Real Life.mp4

4. Objects As Properties.mp4

4.1 Dummies.com - An Overview of the Excel Object Model.html

5. The Excel Object Model.mp4

5.1 Dummies.com - An Overview of the Excel Object Model.html

6. Access Object from Collection by Name.mp4

7. Default Properties.mp4

7.1 Stack Overflow - Is “Value” actually the default property of the Range object.html

8. The Name Property on Workbook and Worksheet Objects.mp4

8.1 Official MSDN Documentation for the Worksheet.Name Property.html

8.2 Official MSDN Documentation for the Workbook.Name Property.html

9. Object-Oriented Programming.html

/3. The Visual Basic Editor/

1. Visual Basic Editor Options.mp4

1.1 Official MSDN Article on Configuring Options in the Visual Basic Editor.html

2. Create and Delete a Procedure.mp4

2.1 Official MSDN Article on Writing a Procedure.html

3. Procedures.html

4. The Immediate Window and Debug.Print Method.mp4

4.1 Official MSDN Article on Using the Immediate Window.html

4.2 Official MSDN Article on the Debug Object.html

5. The MsgBox Method.mp4

5.1 Official MSDN Reference Article on the MsgBox Method.html

6. Comments.mp4

6.1 Official MSDN Tutorial on Adding Comments to Code.html

7. Practice with Procedures.html

8. The Visual Basic Editor.html

/4. Objects and Methods/

1. Methods without Arguments.mp4

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

2. Methods without Arguments.html

3. Methods with Arguments.mp4

3.1 Official MSDN Documentation for the Worksheet Object.html

3.2 Official MSDN Documentation for the Worksheet.Protect Method.html

4. Methods with Arguments.html

5. Methods with Multiple Arguments.mp4

6. The Object Browser.mp4

6.1 Official MSDN Article on using the Object Browser.html

7. Ways to Invoke A Procedure.mp4

8. The TypeName Method.mp4

8.1 Official MSDN Documentation for the TypeName Function.html

9. Objects and Methods.html

/5. Variables and Data Types/

1. Syntax Tips.mp4

1.1 Official MSDN Documentation for Writing Visual Basic Statements.html

1.2 Official MSDN Documentation for Understanding Visual Basic Syntax.html

2. Variable Declarations and Assignments.mp4

2.1 Official MSDN Documentation for Declaring Variables.html

2.2 Official MSDN Documentation for Using Data Types Efficiently.html

2.3 Official MSDN Documentation for Writing Assignment Statements.html

2.4 Official MSDN Documentation for Writing Declaration Statements.html

2.5 Official MSDN Documentation for Visual Basic Naming Rules.html

3. Multiple Variable Declarations.mp4

4. The Option Explicit Setting.mp4

4.1 Official MSDN Documentation for the Option Explicit Statement.html

5. The Byte, Integer and Long Data Types.mp4

5.1 Official MSDN Documentation for the Byte Data Type.html

5.2 Official MSDN Documentation for the Integer Data Type.html

5.3 Official MSDN Documentation for the Long Data Type.html

6. Numeric Data Types.html

7. Mathematical Operations.mp4

8. The Single and Double Data Types.mp4

8.1 Official MSDN Documentation for the Single Data Type.html

8.2 Official MSDN Documentation for the Double Data Type.html

9. The String Data Type.mp4

9.1 Official MSDN Documentation for the String Data Type.html

10. String and Double Data Types.html

11. The Boolean Data Type.mp4

11.1 Official MSDN Documentation for the Boolean Data Type.html

12. The Date Data Type.mp4

12.1 Official MSDN Documentation for the Date Data Type.html

13. The Variant Data Type.mp4

13.1 Official MSDN Article on Understanding Variants.html

14. The Object Data Type.mp4

15. Default Values for Declared Variables.mp4

16. Variable Declarations.html

/6. Procedures/

1. Variable Scope.mp4

2. Call A Procedure from Another one.mp4

3. Procedures with Arguments.mp4

4. Procedure Scope (Public vs. Private).mp4

5. The Exit Sub Keywords.mp4

5.1 Official MSDN Documentation on the Exit Statement.html

6. Constants.mp4

6.1 Official MSDN Article on Declaring Constants.html

6.2 Official MSDN Article on Using Constants.html

7. Predefined Constants.mp4

7.1 Official MSDN Documentation for the xlPageOrientation Enumeration.html

7.2 Official MSDN Documentation for the PageSetup Object.html

8. Procedures.html

/7. Object Deep Dive/

1. The Application Object.mp4

1.1 Official MSDN Documentation for the Application.Path Property.html

1.2 Official MSDN Documentation for the Application.Name Property.html

1.3 Official MSDN Documentation for the Application.UserName Property.html

1.4 Official MSDN Documentation for the Application Object.html

1.5 Official MSDN Documentation for the Application.Version Property.html

1.6 Official MSDN Documentation for the Application.Quit Method.html

2. The Application.DisplayAlerts Property.mp4

2.1 Official MSDN Documentation for the Application.DisplayAlerts Property.html

3. The Workbooks.Count and Worksheets.Count Properties.mp4

3.1 Official MSDN Documentation for the Workbooks Object.html

3.2 Official MSDN Documentation for the Workbooks.Count Property.html

3.3 Official MSDN Documentation for the Worksheets.Count Property.html

4. The Workbooks.Open Method and Workbook.Path Property.mp4

4.1 Official MSDN Documentation for the Workbook.Path Property.html

4.2 Official MSDN Documentation for the Workbooks.Open Method.html

5. The Workbooks.Close Method.mp4

5.1 Official MSDN Documentation for the Workbooks.Close Method.html

6. The Workbooks.Add Method.mp4

6.1 Official MSDN Documentation for the Workbooks.Add Method.html

7. The Workbook.SaveAs and Workbook.Save Methods.mp4

7.1 Official MSDN Documentation for the Workbook.SaveAs Method.html

7.2 Official MSDN Documentation for the XlFileFormat Enumeration.html

7.3 Official MSDN Documentation for the Workbook.Save Method.html

7.4 Official MSDN Documentation for the Workbook Object.html

8. The Workbook.Activate Method.mp4

8.1 Official MSDN Documentation for the Workbook.Activate Method.html

9. The Workbook.Close Method.mp4

9.1 Official Documentation for the Workbook.Close Method.html

10. The Application, Workbooks and Workbook Objects.html

11. The Worksheets.Add Method.mp4

11.1 Official MSDN Documentation for the Worksheets.Add Method.html

11.2 Official MSDN Documentation for the Worksheets Object.html

12. Add a New Worksheet to End of Current List of Worksheets.html

13. The Worksheet.Visible Property.mp4

13.1 Official MSDN Documentation for the Worksheet Object.html

13.2 Official MSDN Documentation for the XlSheetVisibility Enumeration.html

13.3 Official MSDN Documentation for the Worksheet.Visible Property.html

14. The Worksheet.Copy Method.mp4

14.1 Official MSDN Documentation for the Worksheet.Copy Method.html

15. The Worksheet.Delete Method.mp4

15.1 Official MSDN Documentation for the Worksheet.Delete Method.html

16. The Worksheet.Move Method.mp4

16.1 Official MSDN Documentation for the Worksheet.Move Method.html

/8. Range References/

1. The Range.Select Method.mp4

1.1 Official MSDN Documentation for the Range Object.html

1.2 Official MSDN Documentation for the Range.Select Method.html

2. The Value vs. Text Properties.mp4

2.1 Official MSDN Documentation for the Range.Value Property.html

2.2 Official MSDN Documentation for the Range.Text Property.html

3. R1C1 Notation, Part I.mp4

4. R1C1 Notation, Part II.mp4

5. The Formula and FormulaR1C1 Properties.mp4

5.1 Official MSDN Documentation for the Range.FormulaR1C1 Property.html

5.2 Official MSDN Documentation for the Range.Formula Property.html

6. The Range.Offset Property.mp4

6.1 Official MSDN Documentation for the Range.Offset Property.html

7. The Range.Resize Property.mp4

7.1 Official MSDN Documentation for the Range.Resize Property.html

8. The Offset and Resize Properties.html

9. The Cells Property.mp4

9.1 Official MSDN Documentation for the Application.Cells Property.html

10. The Range.CurrentRegion Property.mp4

10.1 Official Documentation for the Range.CurrentRegion Property.html

11. The Range.End Property.mp4

11.1 Official Documentation for the Range.End Property.html

11.2 Official Documentation for the XlDirection Enumeration.html

12. The Range.Count and Range.CountLarge Properties.mp4

12.1 Official Documentation for the Range.Count Property.html

13. The Range.Row and Range.Column Properties.mp4

13.1 Official Documentation for the Range.Row Property.html

13.2 Official Documentation for the Range.Column Property.html

14. The Range.Rows and Range.Columns Properties.mp4

14.1 Official Documentation for the Range.Columns Property.html

14.2 Official Documentation for the Range.Rows Property.html

15. The Range.EntireRow and Range.EntireColumn Properties.mp4

15.1 Official Documentation for the Range.EntireRow Property.html

15.2 Official Documentation for the Range.EntireColumn Property.html

16. Get Last Row of Data in Worksheet.mp4

/9. Range Actions/

1. The Range.FillDown Method.mp4

1.1 Official MSDN Documentation for the Range.FillDown Method.html

2. The Range.Replace Method.mp4

2.1 Official MSDN Documentation for the Range.Replace Method.html

3. The Range.TextToColumns Method.mp4

3.1 Official MSDN Documentation for the Range.TextToColumns.html

4. The Range.Worksheet Property.mp4

4.1 Official MSDN Documentation for the Range.Worksheet Property.html

5. The Range.Sort Method.mp4

5.1 Official MSDN Documentation for the Range.Sort Method.html

6. The Range.Font Property.mp4

6.1 Official MSDN Documentation for the Font Object.html

7. The Range.Interior Property.mp4

7.1 Official MSDN Documentation for the Interior Object.html

7.2 Official MSDN Documentation for the Interior.ColorIndex Property.html

7.3 Official MSDN Documentation for the Range.Interior Property.html

8. The Range.ColumnWidth and Range.RowHeight Properties.mp4

8.1 Official MSDN Documentation for the Range.RowHeight Property.html

8.2 Official MSDN Documentation for the Range.ColumnWidth Property.html

9. The Range.AutoFit Method.mp4

9.1 Official MSDN Documentation for the Range.AutoFit Method.html

10. The Range.Clear, Range.ClearContents and Range.ClearFormats Methods.mp4

10.1 Official MSDN Documentation for the Range.ClearFormats Method.html

10.2 Official MSDN Documentation for the Range.Clear Method.html

10.3 Official MSDN Documentation for the Range.ClearContents Method.html

11. The Range.Delete Method.mp4

11.1 Official MSDN Documentation for the Range.Delete Method.html

12. The Range.Copy and Range.Cut Methods.mp4

12.1 Official MSDN Documentation for the Range.Copy Method.html

12.2 Official MSDN Documentation for the Range.Cut Method.html

13. The Paste and PasteSpecial Methods on the Worksheet Object.mp4

13.1 Official MSDN Documentation for the Worksheet.Paste Method.html

13.2 Official MSDN Documentation for the Worksheet.PasteSpecial Method.html

13.3 Official MSDN Documentation for the XlPasteType Enumeration.html

14. The Parent Property on All Objects.mp4

14.1 Official MSDN Documentation for the Range.Parent Property.html

14.2 Official MSDN Documentation for the Workbook.Parent Property.html

14.3 Official MSDN Documentation for the Application.Parent Property.html

14.4 Official MSDN Documentation for the Worksheet.Parent.html

/10. Conditionals/

1. Boolean Expressions.mp4

2. Boolean Expressions.html

3. The If Then Statement.mp4

3.1 Article How to use the IF-THEN-ELSE Statement.html

4. The ElseIf and Else Statements.mp4

4.1 Official MSDN Article on Using If...Then...Else Statements.html

5. Select Case.mp4

5.1 Official MSDN Article on Using Select Case Statements.html

6. The AND & OR Logical Operators.mp4

6.1 Official MSDN Reference on the AND Operator.html

6.2 Official MSDN Reference on the OR Operator.html

7. Logical Operators.html

8. The NOT Operator.mp4

8.1 Official MSDN Reference on the NOT Operator.html

/11. Iteration/

1. The For Next Loop.mp4

1.1 Official MSDN Article on Using For Next Statements.html

2. The Step Keyword.mp4

3. Deleting Rows.mp4

4. Fill Empty Rows.html

5. The For Each-Next Construct.mp4

5.1 Official MSDN Article on Using For Each Next Statements.html

6. Iterating over a Range of Cells with For Each.mp4

7. The With-End With Construct.mp4

7.1 Official MSDN Article on Using With Statements.html

8. Exit For and Review of Exit Sub.mp4

8.1 Official MSDN Reference on the Exit Statement.html

9. Iteration.html

/12. Miscellaneous Features/

1. The MsgBox Method In Depth, Part I.mp4

1.1 Official Visual Basic for Applications Reference for the MsgBox Function.html

2. The MsgBox Method In Depth, Part II.mp4

3. MsgBox Options.html

4. StatusBar.mp4

4.1 Official MSDN Documentation for the Application.StatusBar Property.html

5. The Application.ScreenUpdating Property.mp4

5.1 Official MSDN Documentation for the Application.ScreenUpdating Property.html

6. SpecialCells.mp4

6.1 Official MSDN Documentation for the Range.SpecialCells Method.html

7. The InputBox Function.mp4

8. The Application.InputBox Method.mp4

8.1 Official MSDN Documentation for the Application.InputBox Method.html

/13. Arrays/

1. Intro to Arrays.mp4

1.1 Official MSDN Article on Declaring Arrays.html

1.2 Official MSDN Article on Using Arrays.html

2. Alternate Syntax for Fixed-Size Arrays.mp4

3. The Option Base 1 Syntax and Write Array Values to Cells.mp4

4. Initialize Arrays within a For Loop.mp4

5. The LBound and UBound Methods.mp4

6. Dynamic Arrays.mp4

7. The Range.RemoveDuplicates Method.mp4

7.1 Official MSDN Documentation for the Range.RemoveDuplicates Method.html

/15. Debugging/

1. Intro to Error Handling.mp4

2. The OnError and GoTo Keywords.mp4

3. The OnError Resume Next Keywords.mp4

4. Error and Err.Number.mp4

5. Stepping Through Code.mp4

6. Breakpoints.mp4

/16. Events/

1. Introduction to Events.mp4

2. The Worksheet_SelectionChange Event.mp4

2.1 Official MSDN Documentation for the Worksheet.SelectionChange Event.html

3. Review of Application.EnableEvents.mp4

3.1 Official MSDN Documentation for the Application.EnableEvents Property.html

4. The Worksheet_Change Event.mp4

4.1 Official MSDN Documentation for the Worksheet.Change Event.html

5. The Worksheet_Activate Event.mp4

5.1 Official MSDN Documentation for the Worksheet.Activate Event.html

6. Highlight Row and Column Up to Cell Where Cursor Is Placed.html

7. Workbook Events and The Sh Argument.mp4

7.1 Official MSDN Documentation for the Workbook.SheetChange Event.html

8. The Workbook_Open Event.mp4

8.1 Official MSDN Documentation for the Workbook.Open Event.html

9. Procedures with Boolean Arguments + The Workbook_BeforePrint Event.mp4

9.1 Official MSDN Documentation for the Workbook.BeforePrint Event.html

/17. User Forms/

1. Create UserForm, Toolbox, Properties, Controls.mp4

2. The Label and TextBox Controls.mp4

3. Naming Conventions.mp4

4. Naming Conventions.html

5. Design Aesthetics.mp4

6. The CommandButton Control.mp4

7. Add Event Procedure to Control.mp4

8. Unload and Hide a UserForm.mp4

9. Submit the UserForm.mp4

10. Activate a UserForm from Procedure.mp4

11. The initialize Event.mp4

12. The ListBox Control I - Wire up the Form.mp4

13. The ListBox Control II - React to User Selection.mp4

14. The ListBox Control III - Select Multiple Items.mp4

15. The ComboBox Control I.mp4

16. The ComboBox Control II.mp4

17. The CheckBox Control.mp4

Total files 346