Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

The Ultimate Excel Programmer Course

Name: The Ultimate Excel Programmer Course
Rating: 4.6 (17271 reviews)

Learn Excel VBA from Scratch with Dan Strong, Bestselling Excel Expert with Over 180K Students Worldwide!

Bestseller

Highest Rated

Created byDaniel Strong

Last updated 1/2023

English

What you'll learn

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!
Generate Basic 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.
Put Excel ON AUTOPILOT. . .
Trigger Macros using Worksheet and UserForm Controls (Buttons, Shapes, DropDowns, ListBoxes, Click Actions, Loads of Fun Controls)
Change Cell Properties using code - Cell Color, Font Properties (Bold, Italic, Underline, etc), Borders and more!
Master Beginning to Advanced Math with Variables and Learn Proper Use, Declaration and Scope
Learn String Functions, Concatenation and How to Control Case-Sensitivity with VBA Functions
Create Your Own Functions to be used In VBA or in a Cell!
Uncover Advanced Search Functions Only Available in VBA
Fun with Date and Time Math to Calculate Duration, Length and Intervals
PROJECTS: Create Full Games, Learn From Coding Exercises and Enjoy Mid-Lecture Challenges!
Discover and Master the VBE (Visual Basic Editor) and All the Mysterious Buttons and Features Within!
Deal With Errors and Learn How To Prevent Them
Feed Information from One Macro to Another using ByRef and ByVal Methods
Utilize Variable Types: Constants, Static, Module-Level, Public, Private, 'Option Private Module', etc
BONUS #1: Free e-book "Excel VBA Master Keyboard Shortcuts" - Now with more shortcuts (for PC and Mac) than anywhere else
BONUS #2: Free Image Tools For Better Looking Buttons, Images and Form Backgrounds
BONUS #3: Free Mouse Icons Packs To Customize MouseOver Effect on Many Controls Including a UserForm Background!
Three Methods of Accessing a Worksheet using Code
Get the Boundaries of a Range of Cells the way Pros do (Better LastRow and LastCol Techniques)
Dynamically Sort or Filter Data. You can have multiple sort options, each assigned to different buttons!
Utilize User-Input (MessageBoxes, InputBoxes, UserForms) and Use Conditional Logic (IF THEN, CASE STATEMENTS, AND, OR, NOT) to Control Direction
Insert Worksheet Functions into Cells Programmatically Using Regular or R1C1 Notation
Practice Code Slimming and Efficiency Techniques, such as WITH/ END WITH statements
Speed Up Your Code Massively with Dan's "VBA Speed Hacks"
Get Random Numbers to Generate Passwords, Create FileNames, Produce Random Actions In Games/Projects, Speed Tests
Search Cells and Strings with Advanced Pattern Matching & Comparison, LIKE Operator and InStr Functions
Advanced MessageBox Features (Including Special Icons, Direction, Buttons: Yes/No, Yes/No/Cancel, Abort/Retry and many more...)
Create Optional UDF Parameters and choose Volatile or Non-Volatile Functionality

Course content

12 sections • 279 lectures • 30h 28m total length

Course Intro and Download Kit8:55
An introduction to the course
Getting FAST Help and Other Freebies with Excel Ninjas Group2:05
Get the Developer Ribbon (PC and Mac)4:00
What Is The Range Object and Your First Macro From Scratch6:43
In this lesson, will learn about the range object and how to use it as if you're typing into cells yourself.
Adding Secondary or Subsequent Commands2:59
Now let's add a little spice to our macro!
Debugging in Excel VBA and Stepping Through Code5:58
How to go line-by-line when you want to analyze your code more thoroughly.
Three Easy Ways To Test Or Store A Value4:18
How and When To Record a Macro (Plus Clean Up Tips)5:14
Three Main Data Type Notations For Entering Into Cells2:41
Several Ways of Triggering Macros (Intro To Buttons and Fun Controls)7:10
There's more than one way to skin that cat! Macros are designed to be triggered a number of ways. In this video we'll discuss this.
Exercise 01 - Objectives Overview2:32
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.

This will be located in the "01 The Range Object\Exercises" folder. Please open "Exercise 01 - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.

Happy Coding!

Dan
Exercise 01 - Solution5:44
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
Affecting Multiple Cells With One Range Command3:01
Using a Named Range with the Range Object4:18
You don't only have to use the cells names, you can also use named ranges. Check it out!
Tips and Best Practices For Better Development Skills11:28
Range Object Quiz

VALUE, TEXT and FORMULA Properties - Reading and Writing Functions To a Cell14:06
Value returns the actual value of a cell, not it's formatting, eg: 12.5 instead of $12.50
Row and Column Properties1:42
Gleaming the row or column of a range you're working with can be very valuable. Learn how to wield this tool now!
SELECT Method1:13
If you click on a cell or highlight several cells, you've just selected them. Turns out, Excel can automatically select things - like a ghost clicking around for you!!
COUNT Property1:42
This isn't the same as the worksheet function COUNT, this simply counts how many cells you have in the range, not how many aren't blank.
Exercise 02a - Objectives Overview1:31
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.
This will be located in the "02 Range Properties\Exercises" folder. Please open "Exercise 02a - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.
Happy Coding!
Dan
Exercise 02a - Solution5:22
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
ADDRESS Property5:01
Address brings the exact location of the cell or range you're referring to, such as $A$2 or A1:B3.
NUMBERFORMAT Property3:26
Change the formatting of your ranges on the fly with this handy dandy tool.
FONT Collection - BOLD, ITALIC, UNDERLINE Properties2:44
Everybody needs to know how to automatically make ranges Bold, Italic or Underline!!
Exercise 02b - Objectives Overview2:01
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.

This will be located in the "02 Range Properties\Exercises" folder. Please open "Exercise 02b - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.

Happy Coding!

Dan
Exercise 02b - Solution11:08
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
Add Color To Cells, Inside and Out (4 Ways)5:39
Properties Quiz

Intro To The Cells Object1:47
Pinpointing which cells you want using rows and columns, almost like latitude and longitude for coordinates. Very useful when we use loops in the lessons to come!
Using The Cells Object and Practical Applications2:44
Using Column Letters instead of Numbers1:11
You don't have to use column 2, there's a way to use B instead when using the cells object.
Using Cells Positionally within a Range2:51
More on the cells object. . .
Affecting ALL Cells in a Worksheet2:26
Quick tip on making changes to all cells in a sheet - easy.
Exercise 03 - Objectives Overview1:41
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.

This will be located in the "03 The Cells Object\Exercises" folder. Please open "Exercise 03 - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.

Happy Coding!

Dan
Exercise 03 - Solution6:34
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
Using Range Object With Cells Object (To Affect Multiple Cells)2:16
Sandwich these two concepts, the range object used with the cells object. Cool!
Cells Quiz

Intro to Variables5:52
Using variables is important and fun! They make calculations way easy!
Math With Variables8:41
Variable Declaration and Different Variable Types10:44
Sometimes you have to let Excel know what to expect when using variables.
Variable Type Demonstration5:04
Here, let me give you some cool examples.
String Manipulation - Concatenation Examples8:17
Concatenation is just a fancy word - it's easy.
String Manipulation - Len, Left, Right Functions4:13
String Manipulation - Mid Function (2 Methods)5:53
String Manipulation - Replace Function3:08
String Manipulation - Format Function4:32
String Manipulation - InStr Function and Practice Projects12:31
Date and Time Functions and Fun DateTime Math Tricks6:05
In this short lecture, we learn about Date and Time built in variables that assist us in making calculations based on the time or date the user interacts with our program! Fun!!!
CDate and DateDiff Functions5:54
Exercise 04 - Objectives Overview2:17
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.

This will be located in the "04 Variables\Exercises" folder. Please open "Exercise 04 - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.

Happy Coding!

Dan
Exercise 04 - Solution5:29
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
Scope and Heirarchy of Variables and Procedures3:16
VARIABLE SCOPES - Public, Private and other Variables6:18
Procedural Scopes - Public Versus Private Subs, Option Private Module6:11
Using Constants5:46
These special variables shouldn't change, so lets tell excel what they are, and we can use them anytime, anywhere!!
Passing Values to Another Procedure - ByRef vs ByVal5:36
Sometimes you want to use your current variables in another procedure. Sometimes you just need to throw the value in there but don't want it affected in the original procedure, other times you want to manipulate the original so it's different when you get back to the originating procedure. Here's how to do all of that!
Variables Quiz

File Menu Walkthrough3:00
All the cool things you can do from the file menu, including importing and exporting modules or userforms. neat
Edit Menu Walkthrough12:31
Now the Edit menu.
View Menu Walkthrough Pt 17:45
View Menu has some neat things and perspectives for your macro and/or variables. . .
View Menu Pt 2 - Watch Window, Locals Window and Immediate Window5:31
really useful things. Watch this now!
Insert, Format and Debug Menu Walkthrough8:17
All about the insert and format menus
Run and Tools Menu Walkthrough8:47
Last but not least on the Menus. . .
Toolbars Quiz

Three Ways To Access Other Sheets - Sheet Name, Index and CodeName7:35
Get the Last Row of Your Data Set5:34
You'll need to memorize this one-liner, but it's easy once you know what it means.
Get the Last (Rightmost) Column of Your Data Set2:42
Very similar to last row.
Get the Next Row in Your Data Set - Data Entry Basics3:44
Really really easy to grab the Next row in your set. Great for auto-data entry.
Recording a Macro 1013:35
How to record a macro and use it to LEARN!!
Dynamically Sorting The Employee Data3:09
How to Sort dynamically, even when more rows are added. No more hard-coding!
Absolute vs Relative References and OFFSET() Function3:34
More on the recording tool.
R1C1 Notation and How To Use In Formulas3:46
Using Worksheet Functions in the VBE6:29
Random Password Generator - Objectives Overview3:05
Random Password Generator - Solution5:20
Using With and End With3:20
Want to save a lot of keystrokes? Listen to this lesson.
If Then Statement4:41
Here's where the fun begins. . . If Then statements are super fun and help you arrive at the logical conclusions you need to pretty easily.
Using Is Not Equal To And The NOT Operator1:29
Another logical tool.
AND, OR and NOT Operators4:38
Using the word NOT to negate a statement.
Exercise 06a - Objectives Overview3:35
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.

This will be located in the "06 Super Important Tools and Excel Logic\Exercises" folder. Please open "Exercise 06a - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.

Happy Coding!

Dan
Exercise 06a - Solution3:13
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
Using ELSE and ELSEIF Commands3:53
Adding the "Else" aka otherwise part of the IF THEN statement.
Rock, Paper, Scissors Game - Objectives Overview1:45
Rock, Paper, Scissors Game - Solution9:41
The LIKE Operator7:07
Compare Strings With Case Insensitivity Using UCase and LCase3:17
Comparitive Operators With Text and Numbers (IsNumeric Function)4:14
Don't let text mess you up when comparing to numbers.
Two Ways to Use If Then Statements in a One-Liner of Code3:33
Save space and use a one-liner of code for your basic If Then statements! Easy!
Using GOTO and Labels, Common Uses, Error Routing5:39
Jump to different areas of code like a teleportation device!
Select Case as Alternative to IF THEN Statements10:40
Try this on for size to save keystrokes when using If Then statements. It's nice once you get used to it.
Advanced MessageBox Features5:33
User Interaction - Message Box with Yes, No Buttons7:09
"Do you like Excel VBA? Click Yes or No"

In this lecture, you'll learn how to let the user select yes or no and navigate the macro depending on their choices. Very powerful and yet simple to utilize.
Exercise 06b - Objectives Overview2:36
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.

This will be located in the "06 Super Important Tools and Excel Logic\Exercises" folder. Please open "Exercise 06b - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.

Happy Coding!

Dan
Exercise 06b - Solution6:41
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
User Defined Functions 10110:19
Learn how to create your own functions that work within cells with the equals sign just like =SUM, or use them within macros to simplify code!
User Defined Functions - Optional Parameters3:54
Volatile vs Non-Volatile Functions3:37
Super Important Info Quiz

Intro To Loops4:37
The FOR NEXT Loop12:11
Loops help us analyze data, as well as write data. Every VLOOKUP you've every used has a built in loop to go from one row to the next and find you the answer. We're going to make our own loops and tell it when to start and stop. It's super fun and easy once you learn the basics. Check it out!
Fun With The FOR NEXT Loop4:38
Now let's make it interesting. . . add some spice to our first loop.
Beginning Our First Report Using Loops9:11
We'll start with a basic loop to analyze all the rows in our data set.
How To Loop Through Each Character In A String Or Phrase4:28
Morse Code Generator - Objectives Overview1:04
Morse Code Generator - Solution9:26
Increment Columns And Rows - Loops Within A Loop3:09
How and When To Exit A Loop, Sub Or Function5:37
Intro To User Interaction With An InputBox7:12
An InputBox is a tool to get insight or data entry from a user.
Specialized InputBox Method to Prompt for Numbers, Ranges, Etc11:34
More User Interaction Demos To Follow Along5:48
Name Definition Game - Objectives Overview1:34
Name Definition Game - Solution11:17
Printable Report Part 1 - Getting Items On Report Sheet11:56
Everyone wants reports that can go to the printer and look good on paper. Learn the basics to this valuable skill.
Printable Report Part 2 - Clearing Last Report3:14
Get the data you need on the correct sheet in the correct row and column!
Printable Report Part 3 - Ensuring Visibility and Autoselect Report Sheet3:41
You need to clear out the last report you wrote onto the report sheet.
Seven Hacks To Massively Speed Up Your Code12:06
Exercise 07a - Objectives Overview2:32
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.

This will be located in the "07 Loops and Report Writing Basics\Exercises" folder. Please open "Exercise 07a - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.

Happy Coding!

Dan
Exercise 07a - Solution7:40
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
Sending Reports To the Printer or Using Automatic Print Preview4:00
Add an Auto-Print Preview. It's fun and useful!
The FOR EACH Loop8:26
This will loop through each item in a group, like objects or cells in a named range or shapes/buttons on a page or userform!
Intro To DO LOOPS5:27
DO Loops are a bit different as you don't define the start and end points so clearly. Very interesting though!
Help With Infinite Loops - INTERRUPTING A MACRO AND PHANTOM BREAKS3:58
Do Loop - While and Until Operators4:35
BONUS - Loop Through Multiple Files in a Folder and Scrape Data From Each12:09
Fun BONUS Lecture! - Learn to scrape data from files in a folder and plug them into a central 'Master' workbook.
Exercise 07b - Objectives Overview1:26
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.

This will be located in the "07 Loops and Report Writing Basics\Exercises" folder. Please open "Exercise 07b - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.

Happy Coding!

Dan
Exercise 07b - Solution5:30
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
Loops and Reports Quiz

Intro To Events3:27
Trigger a macro on a worksheet through various means. Change event is when anything changes on a sheet, your macro is triggered. Cool!
Selection Change - Macros When You Change The Active Cell8:11
Running Events Manually and Break Points2:30
Worksheet Activate Event and Intro to Me Keyword2:52
When the worksheet is opened, this macro can be triggered.
Worksheet Deactivate Event6:38
This is triggered when de-selecting a sheet.
BeforeDelete Event - for Worksheet Deletion5:06
Only used with sheet deletion, but interesting. .
BeforeDoubleClick Event - Trigger a Macro When You Double Click6:21
Trigger a macro by double-clicking either on a specific cell or cells OR anywhere on the sheet.
Excel Dialog Boxes4:08
The Intersect Function - Test Whether Target Is Within a Range Of Cells1:56
BeforeRightClick Event and Customizing Right Click Context Menu Pt 15:23
Right-click triggers!
Customizing the Right Click Context Menu Pt 2 - Adding Custom Buttons11:19
Exercise 08a - Objectives Overview1:50
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.

This will be located in the "08 Worksheet Events\Exercises" folder. Please open "Exercise 08a - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.

Happy Coding!

Dan
Exercise 08a - Solution4:06
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
Worksheet Calculate Event4:54
Triggered whenever calculations occur.
Worksheet Change Event and Preventing Endless Loops7:35
This is pretty neat. The worksheet listens until something changes on that particular sheet, then you can customize where it's listening and what it DOES!!
Exercise 08b - Objectives Overview1:37
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.

This will be located in the "08 Worksheet Events\Exercises" folder. Please open "Exercise 08b - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.

Happy Coding!

Dan
Exercise 08b - Solution5:07
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
FollowHyperlink Event7:07
a Hyperlink Trigger.
Final Thoughts on Worksheet Events and Review Other Events3:01
A few lesser known, lesser used Events and my final thoughts on the matter.
Tic Tac Toe Game - Objectives Overview2:55
Tic Tac Toe Game - Solution23:03
Worksheet Events Quiz

Workbook Events Intro1:51
Workbook Open and Environ Function12:44
This event occurs when the workbook is opened.
Useful Workbook-Level Commands - Opening, Saving and Closing8:14
Login Program - Objectives Overview1:33
Login Program - Solution8:01
Workbook Activate Event2:28
When any chart, worksheet or the workbook itself is activated/selected.
Workbook BeforeSave Event6:05
Right before the actual Save occurs, you get a chance to run this macro automatically.
Workbook AfterSave Event - Make Backup Copy Upon Successful Save5:05
After Save event occurs, you get to recap with this macro. Even can tell you is save was successful or not!
BeforeClose and BeforePrint Events3:57
Occurs before the workbook closes. If the workbook has been changed, this event occurs before the user is asked to save changes.
Workbook Deactivate Event2:10
Occurs when the chart, worksheet, or workbook is deactivated.
NewChart Event4:30
Occurs when a new chart is created in the workbook.

UPDATE: In Excel 2010 or earlier, you need to Use the Ch.HasTitle = True in order to create a Title that can then be edited. In 2013 the title came with it automatically. Sorry bout that. Here's the sample code:

Private Sub Workbook_NewChart(ByVal Ch As Chart)

Ch.HasTitle = True

Ch.ChartTitle.Text = "My Custom Chart"
End Sub
NewSheet Event2:37
Occurs when a new sheet is created in the workbook.
Exercise 09 - Objectives Overview0:50
Please download this exercise from the "Course Files Download" zip file, or Download the single Question file here.

This will be located in the "09 Workbook Events\Exercises" folder. Please open "Exercise 09 - Question.xlsm" and click on the "Objective" tab to view your tasks. The following video will show the solution step-by-step. If you need help, you may refer to the "Answer" version of this workbook with full source code to look at.

Happy Coding!

Dan
Exercise 09 - Solution4:11
Solution video for this Exercise. Solution workbook is also attached to this Lecture as well as found in the "Course Files Download" folder!
SheetActivate Event - 3 Ways to Specify Which Sheets To Trigger Macro3:30
Occurs when any sheet is activated.
SheetDeactivate Event2:15
Occurs when any sheet is deactivated.
Comparing Workbook to Worksheet Events, Delete, Double-click, Right-click, Calcu1:36
PivotTable Auto Update Exercise - Objectives Overview1:49
PivotTable Auto Update Exercise - Solution2:41
WindowActivate and WindowDeactivate - Windows vs Workbooks vs Sheets3:55
Occurs when any workbook window is activated.
WindowResize Event - Force A Minimum Width For Your App4:48
Occurs when any workbook window is resized.

Intro To Controls9:42
CommandButtons on Windows and Mac - Wage Calculator17:08
Finally - how to use a simple Button on a worksheet!
Adding An Image and Formatting Button (ActiveX and Form)5:37
CommandButton Properties Overview (ActiveX and Form)14:09
Populate Calendar Project - Objectives Overview5:29
Populate Calendar Project - Solution Pt 113:56
Populate Calendar Project - Solution Pt 213:06
Intro to ActiveX Key-Press Listeners4:56
KeyDown Event4:52
KeyDown is triggered when someone has pressed a keyboard key. Find out how to harness this toll in this video.
Capturing Shift, Alt, Ctrl (or some combination) Using the Shift Variable3:08
When using Keydown event, you can check to see whether Ctrl, Alt, Shift or any combination of them was pressed in addition to using the Keycode checker. This is awesome!
KeyPress Event on a CommandButton3:13
KeyPress is similar to Keydown. check it out.
MouseMove Event and Using Statusbar for Notifications8:16
When you hover the mouse over something. . . fun control.
Manipulate Worksheet Form Control Label Text (PC,Mac)5:05
Simulating a MouseLeave Like Event with an Invisible Label3:35
MouseUp and MouseDown Events - Left, Middle, and Rightclick, Shift, Alt and Ctrl4:40
Learn all the fun subtleties with MouseUp
TextBox Properties Overview (ActiveX)19:10
TextBox Shapes as Form Controls6:08
TextBox Change() Event and Tips7:46
TextBox Change() Event Pt 211:03
Controlling Tab Order With Worksheet ActiveX Controls5:30
Restrict User Input With KeyDown Event8:19
GotFocus and LostFocus Events2:16
Learn about these events, triggered based on when they are in focus, such as tab, enter or clicked.
Selecting All Text When Receiving Focus5:31
Ensure User Input Exercise (Overview)3:50
Ensure User Input Exercise (ActiveX Solution for PC)6:43
Ensure User Input Exercise (Form Control Solution for Mac,PC)7:49
Automating Report Options With A Checkbox8:20
TripleState and LinkedCell Properties with a Checkbox5:44
LinkedCell joins a cell on a worksheet to the value of a control.
OptionButton Overview, Grouping and Alignment5:50
Option button, either this or that but not both!
Homemade Quiz using Option Buttons, CommandButton and Compliance Checking6:24
More on option buttons with this stimulating quiz!
Compliance Checking With Dynamic Button Visibility and Bonus OB Exercise8:58
Make sure people make a choice - or the macro will let them know they need to still do some things.
Intro to SpinButtons (ActiveX and Form Control)8:05
Use cell A1 with a spinbutton
SpinButtons with Textboxes and Numbers4:07
Spinbuttons with textboxes and what to watch out for when using numerals as opposed to text.
SpinButton - Changing Size, Position and Other Properties, Not Just Value2:33
A little more fun before we leave the SpinButton. . .
SpinButton with Dates in a Textbox5:01
Using dates with a textbox is tricky. Watch this for some tips that are sure to save you time!
Four Neat Uses for ActiveX Labels4:13
ActiveX Labels Pt 24:16
How to use the control called "Label". fun!
Intro To ComboBoxes, Dropdowns and Properties - Updating a List12:45
One popular way to fill a combobox, but with this method you can't be choosey. You need to know this, but later we'll address a more customizable method.
Intro To Form Control ComboBoxes, Index Function5:39
Two Methods For Dynamic Ranges For Your Lists (ActiveX and Form ComboBox)8:16
YOU NEED TO LEARN THIS! Now!! :)
Get Specific Items in Your Combobox List, Clear All (ActiveX and Form Control)15:27
Adding Customized Multiple Columns Using .AddItem Method (ActiveX)6:10
Comboboxes don't have to just be one single column of information!
ListBox Basics and Properties Overview (ActiveX and Form Control)8:00
Learn what a ListBox is and how to kick butt with one.
ListBox Practice: Dynamic Cell Manipulation, ListIndex, List (ActiveX & Form)17:22
Here's how to use a Listbox on a worksheet
Additional Ways To Fill A List Quickly, Remove & Change Entries (ActiveX & Form)9:16
Using and Manipulating MultiSelect Items in a Listbox (ActiveX and Form)10:59
How to handle a multiselect listbox, where users can select more than one item!
Dynamic ListBoxes Using .ADDITEM and More (ActiveX and Form Controls)16:00
Now we get really choosey with dynamic filtering and manipulation using .ADDITEM. Awesome!!
Creating Headers For Your ListBox Creatively3:56
Make and Utilize INVISIBLE Columns - Special Trick (ActiveX)2:34
Did you know you can have data that's invisible, but you can still use it in your listbox? This is an awesome trick
ScrollBar Control On A Worksheet And Lookup Practice12:30
Scrollbar examples.
Image Control - 2 Ways to Assign a Picture (ActiveX)10:27
Add a picture and click event to lead to a website.
Toggle Button Basics and Load Webpage On Image Banner Ad Click6:17
Toggle buttons and the joy therein
Inserting a Shape Object as Picture and Why Not To Use Pictures.Insert10:30
A Note On Third Party Enhanced Amazing ActiveX Controls5:44
There are other controls you can download and mess with. May be glitchy, may be awesome. Use at own risk, read up by googling them

Requirements

You should already have Microsoft Excel (version 2003 and up). Obviously the newer the better, but VBA works the same in all versions. It's just that newer versions have more options, thus more VBA Commands to control those options.
Very very basic Excel skills needed for this course (like opening the program, how to click on cells and type things.) You really don't need any Excel experience, because I'll take you from Start to Finish in this course. I was just trying to be funny.

Description

Teach Excel to Do Your Work FOR YOU. . .

Microsoft Office is everywhere, installed on over 750 million computers, but most users only know how to set up a basic table or maybe even do a few formulas here and there.

In my course, I teach you how to take Excel by the horns and make it do whatever you want, whenever you want. It can go through loads of information and create a printable report for you. You can make custom forms so that you can access, analyze, edit, or add new information quickly to your data tables/ worksheets.

Excel programming utilizes a simple but effective tool called "VBA" - the hidden programming language that runs quietly in the background while you work. It’s very easy and straight-forward to use.

I'll show you the easiest tricks to learn this basic language in a fun, progressive method. Learn at your own pace. With each of my short, info-packed lectures, you'll learn another essential skill that you can immediately use. You'll find yourself handling these Automation tools instantly and in any spreadsheet you already use every day. If there's one thing I'm good at - and my students are good at - it's AUTOMATION.

My motto is, "If I'm not making everybody's job easier, quicker and more enjoyable, I don't deserve to have this job" - and that's what I live by.

Take this course and access your true potential.

Oh, and I want to be the first to hear about your New Raise you get once you're making Excel Programs and running everything on autopilot for your co-workers!

-Dan

Here's what some of the students are saying:

“I love this course. Extremely easy to follow along. If you are looking to learn more about Excel this is it!” - Jim C.

“Loving this course! The information is presented quite clear and concise, and it is a really great way of learning VB really fast, yesterday I was a total ignorant of the subject. Today I programmed my first macro and cannot wait to learn more.” - Marcela T.

“I had experimented with VBA previously, but I really feel like this course is exactly what I needed to take my Excel knowledge to the next level. In only 2 weeks I've improved my reporting exponentially and it's all thanks to this course!" - Ryan S.

“You can't go wrong with Daniel Strong!” - Steven S.

“The presenter explains in detail and demonstrates what he's covering, easy to follow along and learn!” - David B.

“Teaches you the fundamental of VBA programming without any prior experience. Shows with easy to follow Example!. thanks for the video!” - Sean C.

"I've taken several different VBA courses here on Udemy and this one from Daniel is by far the most interesting and easy to understand. I've done exactly 107 lectures so far and already was able to automate 80% of my tasks at work that I've been doing manually for years... I'm angry with myself because of the time I wasted by not buying this course earlier. I can't even imagine what I will be able to do after finishing the entire course :)" - Robert

“Well explained, easy to understand lectures. Enjoyable and informative videos.” - Marlena

“Very clear explanations broken down in short videos. Daniel goes at a slow pace that is easy to follow and understand, even for people with no programming experience.” - Gustavo P.

“Best course on VBA ever taken. Thanks a lot!” - Nikita L.

“This is an excellent course!!! There's a lot of good, useful "stuff" here. The examples are practical and real-world!” - Todd W.

“Wow, I thought I knew a little bit about Excel but clearly I had only seen the tip of the iceberg. This course has opened my eyes to the true power of VBA within excel. Great course, fantastic instructor.” - Scott K.

“By large and far, one of the best step by step guide to VBA programming I have ever seen. I have been playing around with VBA for over a year now, have watched countless videos and have read numerous articles and "How-to" guides, but I have never seen something this complete, this throughout. I am amazed at how little I actually new about the VBA world. Thanks a million!” - Alex B.

“Everything I have been looking for, you would have to buy multiple books for this level of instruction!” - Luke S.

"Excellent VBA basic to advance tutorial." – Sandeep G.

“This course is good for beginners and for experienced programmers. Experienced programmers may want to skip through some sections on basics, but it is good to see how the basics work in the context of and excell worksheet. He goes over different events and triggers (like buttons) to execute code. This is a really good course if you plan to do some pretty complex vba code with forms and reports.” - Christian H.

“Very helpful if you do any type of data analysis.” – Jonathan D.

“I think this is an excellent gateway to the tools we need to use going forward. I like the
hands on nature.” – Andre C.

“Much better than other classes and seminars. Great course.” – Mark S.

“The instructor made VBA easy and straight forward to use.” – Min Z.

“Very thorough and practical.” – Juan S.

***Now Available for Offline Viewing!***

Who this course is for:

This Excel course is for anyone who wants to learn Automation secrets in Excel VBA. It’s for complete newbies and/or students looking for a refresher or Reference tool, to pick and choose relevant lessons for their projects. No prior programming knowledge is needed.
This course is probably not for you if you’re looking to learn super advanced report authoring, which will be covered in a future course specifically on this topic. We will, however, make sure you know how to make good solid reports from your data and many tricks to make them look good.
Beginning to Advanced Excel users who are ready to Automate their projects and use extremely customizable macros, build their own UserForms and learn the fundamentals of programming in a safe, easy, progressive way

The Ultimate Excel Programmer Course

What you'll learn

Explore related topics

Course content

The Range Object15 lectures • 1hr 17min

Range Properties12 lectures • 56min

The Cells Object8 lectures • 22min

Variables19 lectures • 1hr 56min

Toolbars and Menus6 lectures • 46min

Super Important Tools and Excel Logic33 lectures • 2hr 39min

Loops and Report Writing Basics28 lectures • 2hr 58min

EVENTS: Worksheet Events made Easy21 lectures • 1hr 59min

WorkBook Events21 lectures • 1hr 25min

Worksheet Controls54 lectures • 7hr 6min

Requirements

Description

Who this course is for: