Excel VBA Complete Guide

2m 1. .VALUE Property 1m 2. .TEXT Property 1m 3. .ROW and .COLUMN Properties 1m 4. .SELECT Property 2m 5. .COUNT Property 2m 6. .ADDRESS Property 4m 7. .FORMULA Property 2m 8. .NUMBERFORMAT Property 3m 9. FONT.BOLD, UNDERLINE or ITALIC Properties

2m 1. The Cells Object 1m 2. Using Column Letters instead of Numbers 2m 3. Using Cells Positionally within a Range 2m 4. Affecting ALL Cells in a Worksheet 3m 5. Using Range Object with Cells Object

2m 1. Intro to Variables 3m 2. Declaring Variables - Variable Types 4m 3. Declaring Variables - Types Demo 2m 4. Calling a Procedure from Another 3m 5. Public and Private Variables 2m 6. Using Constants 7m 7. BONUS! Passing Variables to Another Procedure - ByVal and ByRef

2m 1. File Menu walkthrough 5m 2. Edit Menu walkthrough 2m 3. View Menu walkthrough 8m 4. View Menu2 - Watch Window, Locals Window and Immediate Window 3m 5. Watch Window Wonders! 1m 6. Insert and Format Menus 5m 7. Debug Menu (Important!) 2m 8. Run and Tools Menus

3m 1. Determining the Last Row in your Data Set 2m 2. Determining the Last Column in your Data Set 1m 3. Determining the Next Row in your Data Set 4m 4. Recording a Macro 6m 5. BONUS! - Dynamic Sorting! 4m 6. Absolute vs Relative References 4m 7. Using With and End With 1m 8. Comparison Operators in Excel VBA 2m 9. If Then Statement 1m 10. Using Is Not Equal To (<>) 1m 11. Logical Operator, NOT 1m 12. If, Then, Else Statement 2m 13. If, Then, ElseIF Statement 3m 14. Comparitive Operators with Text and Numbers! 2m 15. Use If Then Statements in a One-Liner of code 2m 16. Using GOTO and Labels 2m 17. Select Case as Alternative to IF THEN Statements 6m 18. Message Box with Yes and No Buttons 4m 19. Relative Positioning using Offset 5m 20. BONUS - User Defined Functions 101 4m 21. BONUS - UDF Lesson 2

3m 1. Intro to Loops; the For Next Loop 4m 2. Fun with our For Next Loop 6m 3. Beginning our first Report using Loops 3m 4. Using an InputBox 3m 5. Adding InputBox to Our First Report to make it Dynamic 2m 6. Add a Button to Open Our Report 2m 7. Add a Cool Looking Button or Image to Open Report 5m 8. Our First Printable Report part 1 - Declaring and Setting the Sheets 7m 9. Printable Report Part 2 - Getting Items On Report Sheet 3m 10. Printable Report Part 3 - Clearing Last Report 4m 11. Printable Report Part 4 - Ensuring Visibility and Autoselect Report Sheet 1m 12. Exercise 07a - Question 11m 13. Exercise 07a - Answer 1m 14. Using PrintPreview Automatically 2m 15. Using PrintOut to Send Directly to Default Printer 2m 16. Handling Debug Error When Cancelling InputBox 3m 17. For Loop Going Backwards using STEP 5m 18. The FOR EACH Loop 4m 19. FOR EACH Loop - Practical Examples 1m 20. Exercise 07b - Question 8m 21. Exercise 07b - Answer 3m 22. Intro to DO LOOPS 2m 23. DO Until

4m 1. Intro to Worksheet Events and Selection_Change 1m 2. Worksheet Activate Event 2m 3. Worksheet Deactivate Event 1m 4. BeforeDelete Event - for Worksheet Deletion 3m 5. BeforeDoubleClick Event - Trigger a Macro when Double Clicking 2m 6. BeforeRightClick Event - Trigger a Macro when Right-Clicking 3m 7. Calculate Event 2m 8. How to Disable Events on the Workbook 1m 9. Intro to Change Event 5m 10. Change Event with EnableEvents toggle - Avoid endless loop! 3m 11. Change Event Triggered with Custom Range Using Intersect 3m 12. FollowHyperlinks Event 2m 13. Final Thoughts on Worksheet Events and Review Other Events

5m 1. Workbook Open 2m 2. Workbook Activate 2m 3. Before Save 2m 4. After Save 4m 5. Before Close 1m 6. Before Print 1m 7. Deactivate 3m 8. NewChart 2m 9. NewSheet 1m 10. Exercise 09 - Question 5m 11. Exercise 09 - Answer 2m 12. Sheet Activate 5m 13. Delete, DoubleClick, RightClick, Calculate, Change 3m 14. SheetDeactivate 1m 15. Follow Hyperlink 1m 16. SheetSelectionChange 1m 17. WindowActivate

4m 1. Activex Controls vs Forms Controls 4m 2. Button Click - Wage Calculator 4m 3. Keydown Event 3m 4. BONUS: Capturing Shift, Alt, Ctrl or some combination using the Shift variable 3m 5. KeyPress Event 2m 6. MouseMove Event 4m 7. MouseMove Event with Application.Statusbar - fun and useful 6m 8. MouseUp and MouseDown Events - Left, Middle, & Rightclick, Shift, Alt & Ctrl 1m 9. GotFocus and LostFocus Events 3m 10. Use a Checkbox for its VALUE 2m 11. Checkbox Event Without a Button 2m 12. LinkedCell Property with a Checkbox 3m 13. Option Buttons Intro - What is an Option Button and Grouping 3m 14. Grouping, Alignment and Aesthetics for Controls 5m 15. Homemade Quiz using Option Buttons and a Command Button 4m 16. Compliance Checker for your Forms or Quizzes Part 1 10m 17. Compliance check part 2 4m 18. SpinButton with Cell A1 6m 19. SpinButtons with Textboxes and Numbers 4m 20. SpinButton BONUS - Move Textbox Position with SpinButton 4m 21. SpinButton with Dates in a Textbox 4m 22. Activex "Label" Control - Basics 4m 23. ComboBox - Fill with ListFillRange 5m 24. Creating a Dynamic Range 3m 25. ComboBox - How to use Multiple Columns 9m 26. Using .ADDITEM to Get Specific items in your Combobox List 6m 27. Noteworthy Properties of a Combobox 7m 28. Multiple Columns in Combobox with.ADDITEM and List, ListCount etc 8m 29. ListBox Basics using Dynamic Range 3m 30. Listbox Click event and Dynamic Options 6m 31. BONUS - Manipulating and Using Multiselect Items in a Listbox 4m 32. ListBox - Referencing Column 0 and 1 in a cell Dynamically! 10m 33. Dynamic ListBoxes Using .ADDITEM and More 4m 34. Make and Utilize INVISIBLE Columns - Special Trick! 3m 35. Using a Scroll Bar on a worksheet 6m 36. Pictures on a Worksheet, plus using FollowHyperlink Method 2m 37. Toggle Button 2m 38. A Brief Note on Alternate, 3rd Party Controls

5m 1. Userform - Hide, Show and Unload 6m 2. Sample Database and Creating a Data Entry Form 4m 3. Fill Status combobox with Rowsource when Userform starts - 2 methods 9m 4. New Employee Data Entry Form! 3m 5. Format Textbox Numbers as Numerals, Clearing out Form upon Submission 2m 6. Set the Tab Order for Userform Controls 2m 7. Set Default Values to Make Data Entry Easier 13m 8. Avoid Duplicate Employee ID and other Fun Automation Tricks 11m 9. Edit Mode for Employee Database - Part 1 8m 10. Edit Mode for Employee Database - Part 2 16m 11. Edit Mode Pt 3 - Adding Automation and Save Button 11m 12. Userform Report with Filters - Part 1 6m 13. Userform Report with Filters - Part 2 3m 14. Applying the Dynamic Filters to Reports 3m 15. Clear out Last Report 6m 16. Report Generation and Aesthetics, Headers, Footers, Repeat Rows etc. 3m 17. Concluding Thoughts

7m 1. InStr Function - Search for Text Within Other Text 6m 2. The EVALUATE Function - Mac-Daddy of all functions 3m 3. Sum Function in Excel VBA - EASY! 2m 4. Count Function in VBA