1. The Range Object

  1. Intro and Course Workbooks download.vtt

  1.2 Workbooks Download.zip

  10. Exercise 01 - Question.mp4

  10.1 Exercise 01 - Question.xlsm.xlsm

  11. Exercise 01 - Answer.vtt

  12. Several Ways to trigger your Macro.mp4

  13. Affecting Multiple Cells with One Range Command - 2 Methods.mp4

  14. Adding Strings of Text to a Cell.mp4

  15. Using a Named Range with the Range Object.mp4

  16. Range Object Quiz.html

  2. Get the Developer Tab and Intro to Developer Tab.vtt

  3. Getting started with Range object.vtt

  4. Quick Tip - Project Explorer and Properties Window!.vtt

  5. Creating Your First Macro From Scratch.vtt

  6. Adding a Secondary Command. . ..vtt

  7. Debugging in Excel VBA.vtt

  8. Saving a Macro-Enabled Workbook (.xlsm).vtt

  9. Before You Begin The Exercises....vtt

 10. Activex Controls on Worksheets

  1. Activex Controls vs Forms Controls.vtt

  10. Use a Checkbox for its VALUE.vtt

  11. Checkbox Event Without a Button.vtt

  12. LinkedCell Property with a Checkbox.vtt

  13. Option Buttons Intro - What is an Option Button and Grouping.vtt

  14. Grouping, Alignment and Aesthetics for Controls.vtt

  15. Homemade Quiz using Option Buttons and a Command Button.vtt

  16. Compliance Checker for your Forms or Quizzes Part 1.vtt

  17. Compliance check part 2.vtt

  18. SpinButton with Cell A1.vtt

  19. SpinButtons with Textboxes and Numbers.vtt

  2. Button Click - Wage Calculator.vtt

  20. SpinButton BONUS - Move Textbox Position with SpinButton.vtt

  21. SpinButton with Dates in a Textbox.vtt

  22. Activex Label Control - Basics.vtt

  23. ComboBox - Fill with ListFillRange.vtt

  24. Creating a Dynamic Range.vtt

  25. ComboBox - How to use Multiple Columns.vtt

  26. Using .ADDITEM to Get Specific items in your Combobox List.vtt

  27. Noteworthy Properties of a Combobox.vtt

  28. Multiple Columns in Combobox with .ADDITEM and List, ListCount etc.vtt

  29. ListBox Basics using Dynamic Range.mp4

  3. Keydown Event.mp4

  3.1 Key Code Constants Used With Key Down Events.pdf

  30. Listbox Click event and Dynamic Options.vtt

  31. BONUS - Manipulating and Using Multiselect Items in a Listbox.vtt

  32. ListBox - Referencing Column 0 and 1 in a cell Dynamically!.vtt

  33. Dynamic ListBoxes Using .ADDITEM and More.mp4

  34. Make and Utilize INVISIBLE Columns - Special Trick!.mp4

  35. Using a Scroll Bar on a worksheet.mp4

  36. Pictures on a Worksheet, plus using FollowHyperlink Method.mp4

  37. Toggle Button.mp4

  38. A Brief Note on Alternate, 3rd Party Controls.mp4

  4. BONUS Capturing Shift, Alt, Ctrl or some combination using the Shift variable.mp4

  4.1 KeyDown, KeyUp Events.html

  5. KeyPress Event.vtt

  6. MouseMove Event.mp4

  7. MouseMove Event with Application.Statusbar - fun and useful.mp4

  8. MouseUp and MouseDown Events - Left, Middle, & Rightclick, Shift, Alt & Ctrl.mp4

  8.1 Mouse Down Event [ Excel VBA Language Reference ].pdf

  9. GotFocus and LostFocus Events.vtt

 11. Userforms - the best thing. EVER

  1. Userform - Hide, Show and Unload.vtt

  10. Edit Mode for Employee Database - Part 2.vtt

  11. Edit Mode Pt 3 - Adding Automation and Save Button.vtt

  12. BONUS - Refreshing the RowSource After Updating Data!.vtt

  13. BONUS - Combobox by Last Name Instead of EmpID.vtt

  14. BONUS - Search Name and ID.vtt

  15. Userform Report with Filters - Part 1.vtt

  16. Userform Report with Filters - Part 2.vtt

  17. Applying the Dynamic Filters to Reports.vtt

  18. Clear out Last Report.vtt

  19. Report Generation and Aesthetics, Headers, Footers, Repeat Rows etc..vtt

  2. Sample Database and Creating a Data Entry Form.vtt

  20. Advanced Exercise - Review of Objectives.vtt

  20.2 Events Exercise1 - Practice Version.xlsm.xlsm

  21. Advanced Exercise 01 - Solution.vtt

  21.2 Advanced Exercise 01 - Solution.xlsm.xlsm

  22. Advanced Exercise 02 - Solution.vtt

  22.2 Advanced Exercise 02 - Solution.xlsm.xlsm

  23. Advanced Exercise 03 and 04 - Solutions.vtt

  23.2 Advanced Exercise 03 and 04 - Solution.xlsm.xlsm

  24. Advanced Exercise BONUS A and B - Solutions.vtt

  24.2 Advanced Exercise BONUS A and B - Practice.xlsm.xlsm

  25. Advanced Exercise BONUS C Automate the Workflow for Efficiency - Solutions.vtt

  25.2 Advanced Exercise BONUS C Automate Workflow for Efficiency - Solutions.xlsm.xlsm

  26. Concluding Thoughts. . ..vtt

  3. Fill Status combobox with Rowsource when Userform starts - 2 methods.vtt

  4. New Employee Data Entry Form!.vtt

  5. Format Textbox Numbers as Numerals, Clearing out Form upon Submission.vtt

  6. Set the Tab Order for Userform Controls.vtt

  7. Set Default Values to Make Data Entry Easier.vtt

  8. Avoid Duplicate Employee ID and other Fun Automation Tricks.vtt

  9. Edit Mode for Employee Database - Part 1.vtt

 12. BONUS Section - VBA Functions

  1. InStr Function - Search for Text Within Other Text.vtt

  2. The EVALUATE Function - Mac-Daddy of all functions.vtt

  3. Sum Function in Excel VBA - EASY!.vtt

  4. Count Function in VBA.vtt

  5.1 bonus-lecture.pdf.pdf

 2. Range Properties

  1. .VALUE Property.vtt

  10. .NUMBERFORMAT Property.vtt

  11. FONT.BOLD, UNDERLINE or ITALIC Properties.vtt

  12. Exercise 02b - Question.vtt

  13. Exercise 02b - Answer.mp4

  13.1 Exercise 02b - Answer.xlsm.xlsm

  2. .TEXT Property.mp4

  3. .ROW and .COLUMN Properties.mp4

  4. .SELECT Property.mp4

  5. .COUNT Property.mp4

  6. Exercise 02a - Question.mp4

  6.1 Exercise 02a - Question.xlsm.xlsm

  7. Exercise 02a - Answer.vtt

  8. .ADDRESS Property.mp4

  9. .FORMULA Property.mp4

 3. The Cells Object

  1. The Cells Object.vtt

  2. Using Column Letters instead of Numbers.vtt

  3. Using Cells Positionally within a Range.vtt

  4. Affecting ALL Cells in a Worksheet.vtt

  5. Exercise 03 - Question.vtt

  6. Exercise 03 - Answer.mp4

  6.1 Exercise 03 - Answer.xlsm.xlsm

  7. Using Range Object with Cells Object.vtt

 4. Variables

  1. Intro to Variables.vtt

  10. Using Constants.mp4

  11. BONUS! Passing Variables to Another Procedure - ByVal and ByRef.mp4

  11.1 Passing Variables ByRef and ByVal.xlsm.xlsm

  2. Declaring Variables - Variable Types.mp4

  3. Declaring Variables - Types Demo.mp4

  4. Concatenation - Joining Two Or More Strings!.mp4

  5. BONUS - Date Math Fun!.mp4

  6. Exercise 04 - Question.mp4

  6.1 Exercise 04 - Question.xlsm.xlsm

  7. Exercise 04 - Answer.vtt

  8. Calling a Procedure from Another.mp4

  9. Public and Private Variables.mp4

 5. Toolbars and Menus

  1. File Menu walkthrough.vtt

  2. Edit Menu walkthrough.vtt

  3. View Menu walkthrough.vtt

  4. View Menu2 - Watch Window, Locals Window and Immediate Window.vtt

  5. Watch Window Wonders!.vtt

  6. Insert and Format Menus.vtt

  7. Debug Menu (Important!).vtt

  8. Run and Tools Menus.vtt

 6. Super Important Tools and Excel Logic

  1. Determining the Last Row in your Data Set.vtt

  10. Using Is Not Equal To ().vtt

  11. Logical Operator, NOT.vtt

  12. Exercise 06a - Question.vtt

  13. Exercise 06a - Answer.mp4

  13.1 Exercise 06a - Answer.xlsm.xlsm

  14. If, Then, Else Statement.vtt

  15. If, Then, ElseIF Statement. . ..vtt

  16. Comparitive Operators with Text and Numbers!.vtt

  17. Use If Then Statements in a One-Liner of code.vtt

  18. Using GOTO and Labels.vtt

  19. Select Case as Alternative to IF THEN Statements.vtt

  2. Determining the Last Column in your Data Set.vtt

  20. Message Box with Yes and No Buttons.vtt

  21. Exercise 06b - Question.vtt

  22. Exercise 06b - Answer.mp4

  22.1 Exercise 06b - Answer.xlsm.xlsm

  23. Relative Positioning using Offset.vtt

  24. BONUS - User Defined Functions 101.vtt

  25. BONUS - UDF Lesson 2.mp4

  26. Super Important Info Quiz.html

  3. Determining the Next Row in your Data Set.vtt

  4. Recording a Macro.vtt

  5. BONUS! - Dynamic Sorting!.vtt

  6. Absolute vs Relative References.mp4

  7. Using With and End With.mp4

  8. Comparison Operators in Excel VBA.mp4

  8.1 Comparison Operators In Excel VBA.pdf

  9. If Then Statement.vtt

 7. Loops and Report Writing Basics

  1. Intro to Loops; the For Next Loop.vtt

  10. Printable Report Part 3 - Clearing Last Report.vtt

  11. Printable Report Part 4 - Ensuring Visibility and Autoselect Report Sheet.vtt

  12. Exercise 07a - Question.vtt

  13. Exercise 07a - Answer.mp4

  13.1 Exercise 07a - Answer to BONUS Question.xlsm.xlsm

  14. Using PrintPreview Automatically.mp4

  15. Using PrintOut to Send Directly to Default Printer.mp4

  16. Handling Debug Error When Cancelling InputBox.mp4

  17. For Loop Going Backwards using STEP.mp4

  18. The FOR EACH Loop.mp4

  19. FOR EACH Loop - Practical Examples.mp4

  2. Fun with our For Next Loop.mp4

  20. Exercise 07b - Question.mp4

  20.1 Exercise 07b - Question.xlsm.xlsm

  21. Exercise 07b - Answer.vtt

  22. Intro to DO LOOPS.mp4

  23. DO Until.mp4

  24. Loop Until.mp4

  25. DO While.mp4

  26. Loop While.mp4

  27. EXIT DO - Multiple Exits using your own Criteria along the Way!.mp4

  28. BONUS - Loop Through Multiple Files in a Folder and Scrape Data From Each.mp4

  28.1 Temp.zip.zip

  3. Beginning our first Report using Loops.mp4

  4. Using an InputBox.mp4

  5. Adding InputBox to Our First Report to make it Dynamic.mp4

  6. Add a Button to Open Our Report.mp4

  7. Add a Cool Looking Button or Image to Open Report.mp4

  8. Our First Printable Report part 1 - Declaring and Setting the Sheets.mp4

  9. Printable Report Part 2 - Getting Items On Report Sheet.mp4

 8. EVENTS Worksheet Events made Easy

  1. Intro to Worksheet Events and Selection_Change.vtt

  10. How to Disable Events on the Workbook.vtt

  11. Intro to Change Event.vtt

  12. Change Event with EnableEvents toggle - Avoid endless loop!.vtt

  13. Change Event Triggered with Custom Range Using Intersect.vtt

  14. FollowHyperlinks Event.vtt

  15. Final Thoughts on Worksheet Events and Review Other Events.vtt

  16. Exercise 08b - Question.vtt

  17. Exercise 08b - Answer.mp4

  17.1 Exercise 08b - Answer.xlsm.xlsm

  2. Worksheet Activate Event.mp4

  3. Worksheet Deactivate Event.mp4

  4. BeforeDelete Event - for Worksheet Deletion.mp4

  5. BeforeDoubleClick Event - Trigger a Macro when Double Clicking.mp4

  6. BeforeRightClick Event - Trigger a Macro when Right-Clicking.mp4

  7. Calculate Event.mp4

  8. Exercise 08a - Question.mp4

  8.1 Exercise 08a - Question.xlsm.xlsm

  9. Exercise 08a - Answer.vtt

 9. WorkBook Events

  1. Workbook Open.vtt

  10. Exercise 09 - Question.vtt

  11. Exercise 09 - Answer.mp4

  11.1 Exercise 09 - Answer.xlsm.xlsm

  12. Sheet Activate.vtt

  13. Delete, DoubleClick, RightClick, Calculate, Change.vtt

  14. SheetDeactivate.vtt

  15. Follow Hyperlink.vtt

  16. SheetSelectionChange.vtt

  17. WindowActivate.vtt

  18. WindowDeactivate.vtt

  19. WindowResize.vtt

  2. Workbook Activate.vtt

  3. Before Save.vtt

  4. After Save.vtt

  5. Before Close.vtt

  6. Before Print.vtt

  7. Deactivate.vtt

  8. NewChart.vtt

  9. NewSheet.vtt