Excel VBA Complete Guide
BEST SELLER
175 Lectures
10h 15m
Prepare for your examination with our training course. The course contains a complete batch of videos that will provide you with profound and thorough knowledge related to certification exam. Pass the test with flying colors.
$14.99
$19.49
Curriculum For This Course
-
1. Intro and Course Workbooks download4m
-
2. Get the Developer Tab and Intro to Developer Tab1m
-
3. Getting started with Range object1m
-
4. Quick Tip - Project Explorer and Properties Window!1m
-
5. Creating Your First Macro From Scratch2m
-
6. Adding a Secondary Command1m
-
7. Debugging in Excel VBA1m
-
8. Saving a Macro-Enabled Workbook (.xlsm)1m
-
9. Before You Begin The Exercises...3m
-
10. Several Ways to trigger your Macro1m
-
11. Affecting Multiple Cells with One Range Command - 2 Methods2m
-
12. Adding Strings of Text to a Cell2m
-
13. Using a Named Range with the Range Object2m
-
1. .VALUE Property2m
-
2. .TEXT Property1m
-
3. .ROW and .COLUMN Properties1m
-
4. .SELECT Property1m
-
5. .COUNT Property2m
-
6. .ADDRESS Property2m
-
7. .FORMULA Property4m
-
8. .NUMBERFORMAT Property2m
-
9. FONT.BOLD, UNDERLINE or ITALIC Properties3m
-
1. The Cells Object2m
-
2. Using Column Letters instead of Numbers1m
-
3. Using Cells Positionally within a Range2m
-
4. Affecting ALL Cells in a Worksheet2m
-
5. Using Range Object with Cells Object3m
-
1. Intro to Variables2m
-
2. Declaring Variables - Variable Types3m
-
3. Declaring Variables - Types Demo4m
-
4. Calling a Procedure from Another2m
-
5. Public and Private Variables3m
-
6. Using Constants2m
-
7. BONUS! Passing Variables to Another Procedure - ByVal and ByRef7m
-
1. File Menu walkthrough2m
-
2. Edit Menu walkthrough5m
-
3. View Menu walkthrough2m
-
4. View Menu2 - Watch Window, Locals Window and Immediate Window8m
-
5. Watch Window Wonders!3m
-
6. Insert and Format Menus1m
-
7. Debug Menu (Important!)5m
-
8. Run and Tools Menus2m
-
1. Determining the Last Row in your Data Set3m
-
2. Determining the Last Column in your Data Set2m
-
3. Determining the Next Row in your Data Set1m
-
4. Recording a Macro4m
-
5. BONUS! - Dynamic Sorting!6m
-
6. Absolute vs Relative References4m
-
7. Using With and End With4m
-
8. Comparison Operators in Excel VBA1m
-
9. If Then Statement2m
-
10. Using Is Not Equal To (<>)1m
-
11. Logical Operator, NOT1m
-
12. If, Then, Else Statement1m
-
13. If, Then, ElseIF Statement2m
-
14. Comparitive Operators with Text and Numbers!3m
-
15. Use If Then Statements in a One-Liner of code2m
-
16. Using GOTO and Labels2m
-
17. Select Case as Alternative to IF THEN Statements2m
-
18. Message Box with Yes and No Buttons6m
-
19. Relative Positioning using Offset4m
-
20. BONUS - User Defined Functions 1015m
-
21. BONUS - UDF Lesson 24m
-
1. Intro to Loops; the For Next Loop3m
-
2. Fun with our For Next Loop4m
-
3. Beginning our first Report using Loops6m
-
4. Using an InputBox3m
-
5. Adding InputBox to Our First Report to make it Dynamic3m
-
6. Add a Button to Open Our Report2m
-
7. Add a Cool Looking Button or Image to Open Report2m
-
8. Our First Printable Report part 1 - Declaring and Setting the Sheets5m
-
9. Printable Report Part 2 - Getting Items On Report Sheet7m
-
10. Printable Report Part 3 - Clearing Last Report3m
-
11. Printable Report Part 4 - Ensuring Visibility and Autoselect Report Sheet4m
-
12. Exercise 07a - Question1m
-
13. Exercise 07a - Answer11m
-
14. Using PrintPreview Automatically1m
-
15. Using PrintOut to Send Directly to Default Printer2m
-
16. Handling Debug Error When Cancelling InputBox2m
-
17. For Loop Going Backwards using STEP3m
-
18. The FOR EACH Loop5m
-
19. FOR EACH Loop - Practical Examples4m
-
20. Exercise 07b - Question1m
-
21. Exercise 07b - Answer8m
-
22. Intro to DO LOOPS3m
-
23. DO Until2m
-
1. Intro to Worksheet Events and Selection_Change4m
-
2. Worksheet Activate Event1m
-
3. Worksheet Deactivate Event2m
-
4. BeforeDelete Event - for Worksheet Deletion1m
-
5. BeforeDoubleClick Event - Trigger a Macro when Double Clicking3m
-
6. BeforeRightClick Event - Trigger a Macro when Right-Clicking2m
-
7. Calculate Event3m
-
8. How to Disable Events on the Workbook2m
-
9. Intro to Change Event1m
-
10. Change Event with EnableEvents toggle - Avoid endless loop!5m
-
11. Change Event Triggered with Custom Range Using Intersect3m
-
12. FollowHyperlinks Event3m
-
13. Final Thoughts on Worksheet Events and Review Other Events2m
-
1. Workbook Open5m
-
2. Workbook Activate2m
-
3. Before Save2m
-
4. After Save2m
-
5. Before Close4m
-
6. Before Print1m
-
7. Deactivate1m
-
8. NewChart3m
-
9. NewSheet2m
-
10. Exercise 09 - Question1m
-
11. Exercise 09 - Answer5m
-
12. Sheet Activate2m
-
13. Delete, DoubleClick, RightClick, Calculate, Change5m
-
14. SheetDeactivate3m
-
15. Follow Hyperlink1m
-
16. SheetSelectionChange1m
-
17. WindowActivate1m
-
1. Activex Controls vs Forms Controls4m
-
2. Button Click - Wage Calculator4m
-
3. Keydown Event4m
-
4. BONUS: Capturing Shift, Alt, Ctrl or some combination using the Shift variable3m
-
5. KeyPress Event3m
-
6. MouseMove Event2m
-
7. MouseMove Event with Application.Statusbar - fun and useful4m
-
8. MouseUp and MouseDown Events - Left, Middle, & Rightclick, Shift, Alt & Ctrl6m
-
9. GotFocus and LostFocus Events1m
-
10. Use a Checkbox for its VALUE3m
-
11. Checkbox Event Without a Button2m
-
12. LinkedCell Property with a Checkbox2m
-
13. Option Buttons Intro - What is an Option Button and Grouping3m
-
14. Grouping, Alignment and Aesthetics for Controls3m
-
15. Homemade Quiz using Option Buttons and a Command Button5m
-
16. Compliance Checker for your Forms or Quizzes Part 14m
-
17. Compliance check part 210m
-
18. SpinButton with Cell A14m
-
19. SpinButtons with Textboxes and Numbers6m
-
20. SpinButton BONUS - Move Textbox Position with SpinButton4m
-
21. SpinButton with Dates in a Textbox4m
-
22. Activex "Label" Control - Basics4m
-
23. ComboBox - Fill with ListFillRange4m
-
24. Creating a Dynamic Range5m
-
25. ComboBox - How to use Multiple Columns3m
-
26. Using .ADDITEM to Get Specific items in your Combobox List9m
-
27. Noteworthy Properties of a Combobox6m
-
28. Multiple Columns in Combobox with.ADDITEM and List, ListCount etc7m
-
29. ListBox Basics using Dynamic Range8m
-
30. Listbox Click event and Dynamic Options3m
-
31. BONUS - Manipulating and Using Multiselect Items in a Listbox6m
-
32. ListBox - Referencing Column 0 and 1 in a cell Dynamically!4m
-
33. Dynamic ListBoxes Using .ADDITEM and More10m
-
34. Make and Utilize INVISIBLE Columns - Special Trick!4m
-
35. Using a Scroll Bar on a worksheet3m
-
36. Pictures on a Worksheet, plus using FollowHyperlink Method6m
-
37. Toggle Button2m
-
38. A Brief Note on Alternate, 3rd Party Controls2m
-
1. Userform - Hide, Show and Unload5m
-
2. Sample Database and Creating a Data Entry Form6m
-
3. Fill Status combobox with Rowsource when Userform starts - 2 methods4m
-
4. New Employee Data Entry Form!9m
-
5. Format Textbox Numbers as Numerals, Clearing out Form upon Submission3m
-
6. Set the Tab Order for Userform Controls2m
-
7. Set Default Values to Make Data Entry Easier2m
-
8. Avoid Duplicate Employee ID and other Fun Automation Tricks13m
-
9. Edit Mode for Employee Database - Part 111m
-
10. Edit Mode for Employee Database - Part 28m
-
11. Edit Mode Pt 3 - Adding Automation and Save Button16m
-
12. Userform Report with Filters - Part 111m
-
13. Userform Report with Filters - Part 26m
-
14. Applying the Dynamic Filters to Reports3m
-
15. Clear out Last Report3m
-
16. Report Generation and Aesthetics, Headers, Footers, Repeat Rows etc.6m
-
17. Concluding Thoughts3m
-
1. InStr Function - Search for Text Within Other Text7m
-
2. The EVALUATE Function - Mac-Daddy of all functions6m
-
3. Sum Function in Excel VBA - EASY!3m
-
4. Count Function in VBA2m
