Excel VBA Complete Guide

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.

$13.99 $24.99

Curriculum For This Course

13 lectures 22m
  • 1. Intro and Course Workbooks download
    4m
  • 2. Get the Developer Tab and Intro to Developer Tab
    1m
  • 3. Getting started with Range object
    1m
  • 4. Quick Tip - Project Explorer and Properties Window!
    1m
  • 5. Creating Your First Macro From Scratch
    2m
  • 6. Adding a Secondary Command
    1m
  • 7. Debugging in Excel VBA
    1m
  • 8. Saving a Macro-Enabled Workbook (.xlsm)
    1m
  • 9. Before You Begin The Exercises...
    3m
  • 10. Several Ways to trigger your Macro
    1m
  • 11. Affecting Multiple Cells with One Range Command - 2 Methods
    2m
  • 12. Adding Strings of Text to a Cell
    2m
  • 13. Using a Named Range with the Range Object
    2m

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

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

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

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

21 lectures 1h
  • 1. Determining the Last Row in your Data Set
    3m
  • 2. Determining the Last Column in your Data Set
    2m
  • 3. Determining the Next Row in your Data Set
    1m
  • 4. Recording a Macro
    4m
  • 5. BONUS! - Dynamic Sorting!
    6m
  • 6. Absolute vs Relative References
    4m
  • 7. Using With and End With
    4m
  • 8. Comparison Operators in Excel VBA
    1m
  • 9. If Then Statement
    2m
  • 10. Using Is Not Equal To (<>)
    1m
  • 11. Logical Operator, NOT
    1m
  • 12. If, Then, Else Statement
    1m
  • 13. If, Then, ElseIF Statement
    2m
  • 14. Comparitive Operators with Text and Numbers!
    3m
  • 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
    2m
  • 18. Message Box with Yes and No Buttons
    6m
  • 19. Relative Positioning using Offset
    4m
  • 20. BONUS - User Defined Functions 101
    5m
  • 21. BONUS - UDF Lesson 2
    4m

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

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

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

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

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

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

Free Test Engine Player

How to open .dumpsarena Files

Use FREE DumpsArena Test Engine player to open .dumpsarena files

Our test engine player will always be free.

DumpsArena Test Engine

Windows
Satisfaction Guaranteed

98.4% DumpsArena users pass

Our team is dedicated to delivering top-quality exam practice questions. We proudly offer a hassle-free satisfaction guarantee.

Why choose DumpsArena?

23,812+

Satisfied Customers Since 2018

  • Always Up-to-Date
  • Accurate and Verified
  • Free Regular Updates
  • 24/7 Customer Support
  • Instant Access to Downloads
Secure Experience

Guaranteed safe checkout.

At DumpsArena, your shopping security is our priority. We utilize high-security SSL encryption, ensuring that every purchase is 100% secure.

SECURED CHECKOUT
Need Help?

Feel free to contact us anytime!

Contact Support