The Ultimate Excel VBA Course

Complete VBA Certification Program with 30+ Hours of Video Training
Start writing VBA code you can use right away at work. No programming knowledge is required for this VBA course!

✅ Automate redundant tasks in Excel.
✅ Build advanced custom reports
✅ Use the power of forms to transform the way you get things done.
10+ Hours of Work Saved Per Week!
The course legit is saving me like four to five hours every couple of weeks whenever I need to run a report. If I didn't have this course, I would have been wasting a ton more time...
Edit: I'm now trying to automate the next big time suck reporting tasks I have bi-weekly. If I'm able to automate this bi-weekly report, not only will I be able to save even more time, but I can run these reports almost daily as I keep refining and it could result in 10+ hours of work saved per week since I'm not doing things manually running things multiple times.

JIYAAD NAEEM

Salesforce Administrator, Snap Inc.
Night and Day from the first class I took!
It was just Night and Day from the first class that I took... Dan was able to answer my questions.

It's been such an incredible sense of accomplishment... It's opened up a whole new world and I don't think that there's any way I could have ever accomplished this without his help. I just can't thank him enough.

JENNIFER DILLON

Excel Specialist & Project Management, Work With Jen, Inc.
I Became The Solution Provider at Work!
People will enter data in the wrong columns. They enter it in the wrong rows. Your scrubbing of that data becomes your biggest headache. Daniel taught me how to avoid those headaches with something called a user form...

If you’re looking to progress your career and be the solution-provider for getting the cleanest, most accurate data you can... I cannot recommend this course highly enough!

HARRISON WELSHIMER

Recruiter, Peace Corps
View More...

Watch How We Make Winners

Learning the hidden secrets of Excel can get you promotions, raises and put you ahead of the curve.

12 Complete Sections, 30 hrs 25 min

The Ultimate Excel VBA Course features 278 video lectures that will take you from beginner to advanced Excel pro. You’ll learn to:

✅ Write Macros from scratch
✅ Make your own Custom Formulas/Functions on the fly
✅ Breeze through IF THEN statements and master Conditional Logic
✅ Take control of forms, buttons, drop-downs, checkboxes, option-buttons AND so much more...
GET STARTED

Code Samples, Workbooks, Projects

✅ Hundreds of ready-to-use VBA code samples
✅ Increase your speed and save time in Excel!
✅ Tons of Excel Projects, Games, and Exercises
✅ Save loads of time and make programming easy!


GET STARTED

Visual Basic in Excel Certification

Get a Certificate of Completion; add it to your resume, your LinkedIn profile or other professional profiles.…

Students enrolled in ExcelVbaIsFun.com courses are eligible to receive course certification after successful completion of all lectures and course practice materials. Course quizzes, practice exercises and mid-lecture challenges are all integrated into the course to solidify learning along the way and help toward the course certification.
GET STARTED

Lifetime Access, Updates & Customer Support

✅ Lifetime access to the course content & updates.
✅ No monthly or annual fees.
✅ Access to Dan & our private Facebook group for extra help.
✅ We're here to stay and we fully support our student base.
GET STARTED

BONUS 1. Excel VBA Master Keyboard Shortcuts Cheat Sheet

✅ Keyboard shortcuts can cut down the time it takes to get stuff done.
✅ Our new cheat sheet now comes with more time-saving keyboard shortcuts than anywhere else!
✅ For both PC and Mac.
✅ Includes hidden shortcuts that aren't listed anywhere else!
GET STARTED

BONUS 2. Images, Backgrounds and Icons Pack

✅ Icons & Background Images.
✅ Make Buttons & Userforms look way better.
✅ Mouse cursors pack for hover effects!
✅ Learn Excel image secrets to shave off loads of learning time.
GET STARTED

BONUS 3. Limited BLACK FRIDAY Discount Offer

Use this link to get our best deal now! 👇
USE AUTO COUPON
"I was able to automate 80% of my tasks at work that I’ve been doing manually for years…"

ROBERT BENDKOWSKI

"Within a week co-workers started to put in requests and calling me the Excel-sheriff."

HELEEN DE WAAL

"It was like a gift from God above!.. Absolute GOLD!.. Dan helped me secure not only a Promotion but a Raise!"

XAVIER GONZALES

Read More...

Full Course Curriculum

01. The Range Object - (14 lectures • 1hr 15 min)

In the first section, we’ll be guiding you through the basics of how to create your first macro from scratch and read and write to cells. We’ll also cover different ways to run your macros, including making a cool looking button to trigger your macro.

Topics Covered:

  • Intro and Course Workbooks download
  • Get the Developer Tab and Intro to Developer Tab
  • Getting started with Range object
  • Quick Tip – Project Explorer and Properties Window!
  • Creating Your First Macro From Scratch
  • Adding a Secondary Command. . .
  • Debugging in Excel VBA
  • Saving a Macro-Enabled Workbook (.xlsm)
  • Before You Begin The Exercises
  • Exercise 01 – Question
  • Exercise 01 – Answer
  • Several Ways to trigger your Macro
  • Affecting Multiple Cells with One Range Command – 2 Methods
  • Adding Strings of Text to a Cell
  • Using a Named Range with the Range Object
  • Range Object Quiz
02. Range Properties - (12 lectures • 53 min)

In the second section, we’ll go in-depth about all the properties and methods you need in order to manipulate one or more cells. You can change the font size, color, bold or italic, but also set formulas or format cells easily using VBA!

Topics Covered:

  • .VALUE Property
  • .TEXT Property
  • .ROW and .COLUMN Properties
  • .SELECT Property
  • .COUNT Property
  • Exercise 02a – Question
  • Exercise 02a – Answer
  • .ADDRESS Property
  • .FORMULA Property
  • .NUMBERFORMAT Property
  • FONT.BOLD, UNDERLINE or ITALIC Properties
  • Exercise 02b – Question
  • Exercise 02b – Answer
03. The Cells Object - (8 lectures • 22 min)

Section three explores the differences and similarities between accessing a cell through the Range object and the new Cells object, which can now access cells using row, column coordinates! This is useful when utilizing numeric loops and variables in the next sections.

Topics Covered:

  • The Cells Object
  • Using Column Letters instead of Numbers
  • Using Cells Positionally within a Range
  • Affecting ALL Cells in a Worksheet
  • Exercise 03 – Question
  • Exercise 03 – Answer
  • Using Range Object with Cells Object
  • Cells Quiz
04. Variables - (19 lectures • 1hr 56 min)

Variables open up the possibilities in any programming language. You don’t have to store information in worksheet cells every time. Sometimes it’s better to store a date, string of text or even numbers inside of ‘nicknames’ called variables to contain or manipulate temporary data. They’re super fun and useful!

Topics Covered:

  • Intro to Variables
  • Declaring Variables – Variable Types
  • Declaring Variables – Types Demo
  • Concatenation – Joining Two Or More Strings!
  • BONUS – Date Math Fun!
  • Exercise 04 – Question
  • Exercise 04 – Answer
  • Calling a Procedure from Another
  • Public and Private Variables
  • Using Constants
  • BONUS! Passing Variables to Another Procedure – ByVal and ByRef
  • Variables Quiz
05. Toolbars and Menus - (6 lectures • 46 min)

You’re no better than your tools, so let’s take a look at the Visual Basic Editor and all the wonderful things you can do once you know how to use it!

Topics Covered:

  • File Menu walkthrough
  • Edit Menu walkthrough
  • View Menu walkthrough
  • View Menu2 – Watch Window, Locals Window and Immediate Window
  • Watch Window Wonders!
  • Insert and Format Menus
  • Debug Menu (Important!)
  • Run and Tools Menus
  • Toolbars Quiz
06. Super Important Tools and Excel Logic - (33 lectures • 2hr 39 min)

This section covers all the tricks you’ll need to begin automating and really setting your programs in motion. Enjoy deliciously exciting experiments into IF/THEN statements, to create a fork in your procedures based on custom conditions. Learn how to determine the last row or column in order to set a cell section OR even to know which is the next row to automatically add new data to. That and much more!

Topics Covered:

  • Determining the Last Row in your Data Set
  • Determining the Last Column in your Data Set
  • Determining the Next Row in your Data Set
  • Recording a Macro
  • BONUS! – Dynamic Sorting!
  • Absolute vs Relative References
  • Using With and End With
  • Comparison Operators in Excel VBA
  • If Then Statement
  • Using Is Not Equal To (<>)
  • Logical Operator, NOT
  • Exercise 06a – Question
  • Exercise 06a – Answer
  • If, Then, Else Statement
  • If, Then, ElseIF Statement. . .
  • Comparitive Operators with Text and Numbers!
  • Use If Then Statements in a One-Liner of code
  • Using GOTO and Labels
  • Select Case as Alternative to IF THEN Statements
  • Message Box with Yes and No Buttons
  • Exercise 06b – Question
  • Exercise 06b – Answer
  • Relative Positioning using Offset
  • BONUS – User Defined Functions 101
  • BONUS – UDF Lesson 2
  • Super Important Info Quiz
07. Loops and Report Writing Basics - (28 lectures • 2hr 58 min)
Learn how to loop through a data set to go way beyond the scope of a simple VLookup type search. How about searching AND making changes, or grabbing several items along the way based on custom criteria? Sound difficult? It’s a breeze. Check it out!Topics Covered:
  • Intro to Loops; the For Next Loop
  • Fun with our For Next Loop
  • Beginning our first Report using Loops
  • Using an InputBox
  • Adding InputBox to Our First Report to make it Dynamic
  • Add a Button to Open Our Report
  • Add a Cool Looking Button or Image to Open Report
  • Our First Printable Report part 1 – Declaring and Setting the Sheets
  • Printable Report Part 2 – Getting Items On Report Sheet
  • Printable Report Part 3 – Clearing Last Report
  • Printable Report Part 4 – Ensuring Visibility and Autoselect Report Sheet
  • Exercise 07a – Question
  • Exercise 07a – Answer
  • Using PrintPreview Automatically
  • Using PrintOut to Send Directly to Default Printer
  • Handling Debug Error When Cancelling InputBox
  • For Loop Going Backwards using STEP
  • The FOR EACH Loop
  • FOR EACH Loop – Practical Examples
  • Exercise 07b – Question
  • Exercise 07b – Answer
  • Intro to DO LOOPS
  • DO Until
  • Loop Until
  • DO While
  • Loop While
  • EXIT DO – Multiple Exits using your own Criteria along the Way!
  • BONUS – Loop Through Multiple Files in a Folder and Scrape Data From Each
  • Loops and Reports Quiz
08. EVENTS: Worksheet Events made Easy - (21 lectures • 1hr 59 min)
Learn all about Worksheet Events – triggers made from within a specific worksheet. You can trigger a macro to run when a certain cell or group of cells are clicked, double clicked, or maybe when a sheet is de-selected, you need it to auto-hide? Need to prevent users from adding a new sheet? This is going to be fun!Topics Covered:
  • Intro to Worksheet Events and Selection_Change
  • Worksheet Activate Event
  • Worksheet Deactivate Event
  • BeforeDelete Event – for Worksheet Deletion
  • BeforeDoubleClick Event – Trigger a Macro when Double Clicking
  • BeforeRightClick Event – Trigger a Macro when Right-Clicking
  • Calculate Event
  • Exercise 08a – Question
  • Exercise 08a – Answer
  • How to Disable Events on the Workbook
  • Intro to Change Event
  • Change Event with EnableEvents toggle – Avoid endless loop!
  • Change Event Triggered with Custom Range Using Intersect
  • FollowHyperlinks Event
  • Final Thoughts on Worksheet Events and Review Other Events
  • Exercise 08b – Question
  • Exercise 08b – Answer
  • Worksheet Events Quiz
09. WorkBook Events - (21 lectures • 1hr 25 min)
Did you know you could set up macros to trigger based on workbook wide events?!Want to invisibly log the user’s name and date/time every time the workbook is opened? Make a special popup messagebox appear on certain or all sheet changes. Workbook events are powerful.Topics Covered:
  • Workbook Open
  • Workbook Activate
  • Before Save
  • After Save
  • Before Close
  • Before Print
  • Deactivate
  • NewChart
  • NewSheet
  • Exercise 09 – Question
  • Exercise 09 – Answer
  • Sheet Activate
  • Delete, DoubleClick, RightClick, Calculate, Change
  • SheetDeactivate
  • Follow Hyperlink
  • SheetSelectionChange
  • WindowActivate
  • WindowDeactivate
  • WindowResize
10. Worksheet Controls - (54 lectures • 7hr 6 min)

Adding CommandButtons, ComboBoxes (dropdown menus), ListBoxes, and many other ActiveX controls can really make your program POP! There’s a lot you can do with these, and each one has many, many triggers you can manipulate. Want to select ALL the text in a textbox when you click into it? Want to automatically Disable and gray out certain controls when conditions are met? Want to set up data entry and calculation on button click (but first to check a few conditions?).

Meet your new best friend. ActiveX Controls.

Topics Covered:

  • Activex Controls vs Forms Controls
  • Button Click – Wage Calculator
  • Keydown Event
  • BONUS: Capturing Shift, Alt, Ctrl or some combination using the Shift variable
  • KeyPress Event
  • MouseMove Event
  • MouseMove Event with Application.Statusbar – fun and useful
  • MouseUp and MouseDown Events – Left, Middle, & Rightclick, Shift, Alt & Ctrl
  • GotFocus and LostFocus Events
  • Use a Checkbox for its VALUE
  • Checkbox Event Without a Button
  • LinkedCell Property with a Checkbox
  • Option Buttons Intro – What is an Option Button and Grouping
  • Grouping, Alignment and Aesthetics for Controls
  • Homemade Quiz using Option Buttons and a Command Button
  • Compliance Checker for your Forms or Quizzes Part 1
  • Compliance check part 2
  • SpinButton with Cell A1
  • SpinButtons with Textboxes and Numbers
  • SpinButton BONUS – Move Textbox Position with SpinButton
  • SpinButton with Dates in a Textbox
  • Activex “Label” Control – Basics
  • ComboBox – Fill with ListFillRange
  • Creating a Dynamic Range
  • ComboBox – How to use Multiple Columns
  • Using .ADDITEM to Get Specific items in your Combobox List
  • Noteworthy Properties of a Combobox
  • Multiple Columns in Combobox with .ADDITEM and List, ListCount etc
  • ListBox Basics using Dynamic Range
  • Listbox Click event and Dynamic Options
  • BONUS – Manipulating and Using Multiselect Items in a Listbox
  • ListBox – Referencing Column 0 and 1 in a cell Dynamically!
  • Dynamic ListBoxes Using .ADDITEM and More
  • Make and Utilize INVISIBLE Columns – Special Trick!
  • Using a Scroll Bar on a worksheet
  • Pictures on a Worksheet, plus using FollowHyperlink Method
  • Toggle Button
  • A Brief Note on Alternate, 3rd Party Controls
11. Userforms - the best thing. EVER. - (57 lectures • 8hr 46 min)

If it sounds like I’m enthusiastic, that’s because I AM! Userforms can take your program to the next level, giving you a new profound amount of control.

Did you know you can make a form popup that can call up other forms, control all procedures and bring up reports, all the while hosting lots of ActiveX controls that help you manage, manipulate, update or append new data. Keeping in mind, you can actually edit or add to sheets that are completely hidden to the end user! WHAT?! Yep. It’s amazing and so much fun.

Topics Covered:

  • Userform – Hide, Show and Unload
  • Sample Database and Creating a Data Entry Form
  • Fill Status combobox with Rowsource when Userform starts – 2 methods
  • New Employee Data Entry Form!
  • Format Textbox Numbers as Numerals, Clearing out Form upon Submission
  • Set the Tab Order for Userform Controls
  • Set Default Values to Make Data Entry Easier
  • Avoid Duplicate Employee ID and other Fun Automation Tricks
  • Edit Mode for Employee Database – Part 1
  • Edit Mode for Employee Database – Part 2
  • Edit Mode Pt 3 – Adding Automation and Save Button
  • BONUS – Refreshing the RowSource After Updating Data!
  • BONUS – Combobox by Last Name Instead of EmpID
  • BONUS – Search Name and ID
  • Userform Report with Filters – Part 1
  • Userform Report with Filters – Part 2
  • Applying the Dynamic Filters to Reports
  • Clear out Last Report
  • Report Generation and Aesthetics, Headers, Footers, Repeat Rows etc.
  • Advanced Exercise – Review of Objectives
  • Advanced Exercise 01 – Solution
  • Advanced Exercise 02 – Solution
  • Advanced Exercise 03 and 04 – Solutions
  • Advanced Exercise BONUS A and B – Solutions
  • Advanced Exercise BONUS C Automate the Workflow for Efficiency – Solutions
  • Concluding Thoughts. . .
12. BONUS Section - VBA Functions - (5 lectures • 19 min)

Here’s where I show you some additional features that are just amazing, but don’t always have a nice place to file away. Or I got asked a random question and it merited a video in the Bonus section. Fun!

Topics Covered:

  • InStr Function – Search for Text Within Other Text
  • The EVALUATE Function – Mac-Daddy of all functions
  • Sum Function in Excel VBA – EASY!
  • Count Function in VBA
  • BONUS LECTURE

Join Today & Put Excel On Auto-Pilot

Click the button and complete your investment on the next page for instant access to all the training you’ll need to make Excel “Do Your Work For You”…

The ExcelVbaIsfun guarantee:

  • 30-day no questions asked money back period
  • Use your new skills immediately as you learn.

Lifetime Access for a one-time fee

$99.00 $59.40

PURCHASE NOW FOR $59.40
All courses come with a 30-day money back guarantee.

After Taking This Course, You’ll…

👉 Automate and Customize data entry forms

👉 Choose the right Loop for each task

👉 Master the CELLS and RANGE objects in multiple scenarios

👉 Create multiple Variable styles to match your need

👉 Customize your VBA Editor and Understand all the Toolbars and options

👉 Debug and Troubleshoot code like a boss!

👉 Record, Modify or Write Macros from scratch

👉 Make Custom Formulas/Functions on the fly

👉 Breeze through IF THEN statements and conquer all the Logical Operators

👉 Batch out inter-active MessageBoxes, InputBoxes and give users CHOICES!

👉 Create Your Own Custom Functions to be used In VBA or in a Cell!
👉 Learn Code Slimming and Efficiency Techniques & Speed Up Your Code Massively with Dan’s “VBA Speed Hacks”

👉 Generate Custom Reports that can be printed, Add filters to report menus to narrow the records

👉 Take control of forms, Buttons, Drop-down menus, Checkboxes and option buttons AND so much more. .

👉 Trigger code from a number of different methods – from Clicking on a cell – to De-Selecting a worksheet.

👉 Set up Special Commands when a workbook: Opens or closes, is selected, any cell or certain cells are selected, right before printing, etc. . .

👉 Manipulate Userforms for data entry, report generation, editing tables/databases – ALL within your control. Restrict the flow of data OR make the Userform(s) responsive, calculating, INTUITIVE.

👉 Streamline your work and the work of others.

👉 Ultimately, we’re going to Put Excel ON AUTOPILOT…
GET THE ULTIMATE EXCEL VBA COURSE

Frequently Asked Questions

How Long Is the Course?

We currently have over 30.5 hours of progressive on-demand video that you can view anytime you want and from any device that can load a website..

I’m a beginner and I’ve never done programming, is this really for me?

YES! We specifically designed the course in a way that complete beginners can follow along and learn everything they need in a progressive, easy to learn style, while at the same time, making it engaging for advanced and ‘guru’ level students as well.

No matter what your level, you’ll learn new tricks as well as get new ideas, fun challenges, exercises, games and new ways to think about things you may already be familiar with.

Do you have support for Excel for Mac?

YES! We’ve recently done a complete overhaul of our course and we now include full support for Mac user who are learning Excel VBA, including specific Mac control lectures, form control lectures (since ActiveX controls won’t work on Mac) and even side-by-side keyboard shortcut overlays for Windows and Mac.

Most of the topics are identical for a Mac user, so don’t worry!
GET THE ULTIMATE EXCEL VBA COURSE
© 2022 – Strong Software Solutions LLC | ExcelVbaIsFun – Privacy PolicyTerms and Conditions
This site is not a part of the Facebook website or Facebook Inc. Additionally, This site is NOT endorsed by Facebook in any way.

FACEBOOK is a trademark of FACEBOOK, Inc.
homemagic-wandcoggraduation-hatkeyboardspell-checkchart-barsrocketselectchevron-downmenu-circle
X

Forgot Password?

Join Us

0
    0
    Your Cart
    Your cart is emptyReturn to Shop