Have Questions? 
help@excelvbaisfun.com
Excel Ninja Pro
All Access

[et_pb_section fb_built="1" custom_padding_last_edited="on|tablet" disabled_on="off|off|off" _builder_version="4.10.4" _module_preset="default" background_color="#2d2d2d" custom_margin_last_edited="off|tablet" custom_padding="0px||0px||true|false" custom_padding_tablet="0px||4px||false|false" custom_padding_phone="0px||16px||false|false" sticky_position="top" hover_enabled="0" locked="off" global_colors_info="{}" border_width_all="4px" border_color_all="#0C71C3" border_style_all="ridge" sticky_enabled="0"][et_pb_row column_structure="3_4,1_4" custom_padding_last_edited="on|phone" _builder_version="4.10.4" _module_preset="default" width="90%" width_tablet="90%" width_phone="" width_last_edited="on|desktop" max_width="1600px" max_width_tablet="1300px" max_width_phone="" max_width_last_edited="on|tablet" custom_margin="||||false|false" custom_margin_tablet="-3px||-32px||false|false" custom_margin_phone="-2px||-30px||false|false" custom_margin_last_edited="on|desktop" custom_padding="17px||10px|||" custom_padding_tablet="13px||0px||false|false" custom_padding_phone="" custom_css_main_element="display: flex;" global_colors_info="{}"][et_pb_column type="3_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text content_tablet="

%22%22

" content_phone="

%22%22

" content_last_edited="on|desktop" disabled_on="off|off|off" _builder_version="4.10.4" _module_preset="default" text_font="Arial||||||||" text_text_color="#FFFFFF" text_font_size="19px" text_letter_spacing="1px" custom_margin_last_edited="off|tablet" custom_padding="||||false|false" hover_enabled="0" text_font_size_tablet="9px" text_font_size_phone="12px" text_font_size_last_edited="on|phone" global_colors_info="{}" sticky_enabled="0"]

[/et_pb_text][/et_pb_column][et_pb_column type="1_4" _builder_version="4.10.4" _module_preset="default" global_colors_info="{}"][et_pb_button button_url="/checkouts/uepc-checkout/" button_text="πŸ‘‰ 20% OFF LIFETIME DISCOUNT" button_alignment="right" button_text_tablet="πŸ‘‰ 20% OFF LIFETIME DISCOUNT" button_text_phone="πŸ‘‰ 20% OFF LIFETIME DISCOUNT" button_text_last_edited="on|desktop" _builder_version="4.10.4" _module_preset="default" custom_button="on" button_text_size="19px" button_text_color="#FFFFFF" button_bg_color="#e78d3e" button_border_width="2px" button_use_icon="off" background_layout="dark" custom_margin_tablet="||2px|||" custom_margin_phone="" custom_margin_last_edited="on|tablet" hover_enabled="0" button_text_size_tablet="15px" button_text_size_phone="9px" button_text_size_last_edited="on|desktop" button_border_width_tablet="" button_border_width_phone="1px" button_border_width_last_edited="on|phone" locked="off" global_colors_info="{}" sticky_enabled="0"][/et_pb_button][et_pb_wc_price product="60760" _builder_version="4.10.4" body_font_size="22px" text_orientation="center" module_alignment="right" custom_margin="-15px||||false|false" custom_margin_tablet="-2px||||false|false" custom_margin_phone="" custom_margin_last_edited="on|phone" custom_padding="|||37px|false|false" custom_padding_tablet="|||80px|false|false" custom_padding_phone="|||21px|false|false" custom_padding_last_edited="on|tablet" body_font_size_tablet="15px" body_font_size_phone="13px" body_font_size_last_edited="on|tablet" body_line_height_last_edited="off|tablet" locked="off" global_colors_info="{}"][/et_pb_wc_price][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.9.11" _module_preset="default" background_image="http://excelvbaisfun.com/wp-content/uploads/2021/08/robots-hand-typing-on-keyboard-background-smaller.jpg" custom_margin_tablet="" custom_margin_phone="" custom_margin_last_edited="on|phone" custom_padding="0px||0px|0px|true|false" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" background_enable_image="off" width="100%" width_tablet="100%" width_phone="100%" width_last_edited="on|desktop" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#000000" text_font_size="36px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" custom_margin="|0px||0px|true|false" custom_margin_tablet="|0px|||false|false" custom_margin_phone="-13px||-4px||false|false" custom_margin_last_edited="on|phone" text_text_color_last_edited="off|phone" text_font_size_tablet="" text_font_size_phone="20px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

The Secret Way Excel Pros Automate Their Workflow & Save Time By
Eliminating Annoying Tasks...

[/et_pb_text][et_pb_text _builder_version="4.10.4" _module_preset="default" text_font="Arial||||||||" text_text_color="#000000" text_font_size="22px" text_orientation="center" custom_margin="8px||8px||false|false" custom_padding_tablet="" custom_padding_phone="||||false|false" custom_padding_last_edited="on|phone" text_font_size_tablet="" text_font_size_phone="17px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

Watch this FREE Preview from the courseπŸ‘‡

[/et_pb_text][et_pb_video src="https://vimeo.com/566139367/efee64301d" _builder_version="4.9.11" _module_preset="default" width="80%" module_alignment="center" box_shadow_style="preset2" global_colors_info="{}"][/et_pb_video][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.9.4" _module_preset="default" background_color="#2d2d2d" custom_padding="20px|||||" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" custom_padding="19px|||||" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#FFFFFF" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" custom_margin="-8px|||||" text_font_size_tablet="" text_font_size_phone="33px" text_font_size_last_edited="on|phone" header_text_color_tablet="" header_text_color_phone="" header_text_color_last_edited="on|phone" global_colors_info="{}"]

Stop Wasting Time On Boring Tasks

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_font_size="25px" text_orientation="center" background_layout="dark" global_colors_info="{}"]

Have you always wanted to automate those boring Excel tasks, like formatting the same reports week after week?

Wouldn't it be nice if data entry was automated and you could create your own custom tools to automate your work?

In today's workplace, with the ever-increasing demand for production, and more work - you need a competitive advantage to get more done with less time!:

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_font_size="25px" text_orientation="center" background_layout="dark" custom_margin_tablet="" custom_margin_phone="" custom_margin_last_edited="on|phone" custom_padding="|4px||4px|false|true" text_font_size_tablet="" text_font_size_phone="19px" text_font_size_last_edited="on|phone" global_colors_info="{}"]
  • 81% of businesses globally use Excel
  • This can account for 10 to 30% or more of our working lives
  • and most people just learn enough to get by so they can survive to the next boring report or deadline...
[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" admin_label="Section" _builder_version="4.9.11" _module_preset="default" background_image="http://excelvbaisfun.com/wp-content/uploads/2021/08/ash4-scaled.jpg" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#000000" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="27px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

🚨When I Started In VBA There Was Nothing But Books and Blogs... And Writing My First Program For Work Took Over A Year...

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="rgba(28,28,28,0.93)" text_font_size="24px" text_line_height="1.3em" global_colors_info="{}"]

I remember the first programming job I got working in Excel like it was yesterday.

I went in to a job interview for an accounting job. I knew nothing about accounting.

The interviewer asked me about my Excel skills I listed on my resume and then the boss came in.

They told me they wanted me to rewrite a bunch of legacy programs that weren't working well anymore.

They asked me to write these programs in Excel. What?!

I had mastered Excel formulas and making cool worksheets that could format and use neat data validation.

But I didn't know any VBA or programming.

Naturally, I said, "Sure".

That weekend, I started buying all the books on VBA I could find and searching the internet.

Although I found a few helpful resources, the project took a LONG time to complete, since nothing was out there to take a complete newbie and progressively teach them how to build REAL Programs in Excel.

I promised myself that I would make it easier for other people to learn this valuable skill and so the Ultimate Excel VBA Course was born (several years later).

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" admin_label="Section" _builder_version="4.9.4" _module_preset="default" background_color="#2d2d2d" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#FFFFFF" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="33px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

Here's What I Was Missing...

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="24px" text_line_height="1.3em" text_orientation="center" global_colors_info="{}"]

Early on in my Excel VBA journey, I didn't know what I didn't know, so I'd waste a lot of time testing different controls, tools, solutions - only to find there are still better ones and have to re-do lots of things...

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_3,1_3,1_3" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="1_3" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#FFFFFF" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="27px" text_font_size_last_edited="on|phone" text_orientation_tablet="" text_orientation_phone="left" text_orientation_last_edited="on|phone" global_colors_info="{}"]

1. UserForms

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="24px" text_line_height="1.3em" global_colors_info="{}"]

There's nothing more frustrating than using buttons and dropdown controls (comboboxes) on a worksheet, only to find that they sometimes resize or disappear if overused.

I wish I knew about how powerful and professional Userforms are when I was starting out!

[/et_pb_text][/et_pb_column][et_pb_column type="1_3" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#FFFFFF" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="27px" text_font_size_last_edited="on|phone" text_orientation_tablet="" text_orientation_phone="left" text_orientation_last_edited="on|phone" global_colors_info="{}"]

2. Loops

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="24px" text_line_height="1.3em" global_colors_info="{}"]

Loops open doors! You can:

  • Automatically create tens, hundreds, thousands of rows of data in a split second
  • Scan tables (like writing your own VLookup only more options!)
  • Write dynamic custom reports (that are not your basic cookie-cutter pivot tables)
  • Make changes to your data sets on a massive scale with surgical precision!
[/et_pb_text][/et_pb_column][et_pb_column type="1_3" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#FFFFFF" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="27px" text_font_size_last_edited="on|phone" text_orientation_tablet="" text_orientation_phone="left" text_orientation_last_edited="on|phone" global_colors_info="{}"]

3. Controls

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="24px" text_line_height="1.3em" global_colors_info="{}"]

ActiveX? Form Controls?

I wasted so much time using the wrong controls, or using the right controls wrong.

Most people are looking for a button or a drop-down menu (ComboBox), but there are sooo many things you can do with these controls, so many options and actually more controls than you think.

Each bit of knowledge with each control will save you from wasting loads of time.

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.9.11" _module_preset="default" background_image="http://excelvbaisfun.com/wp-content/uploads/2021/08/bees-hard-work-background-smaller.jpg" custom_padding="10px||10px||true|false" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#000000" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="27px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

Don't Waste Years Learning the Hard Way!

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_font="Oswald||on||||||" text_text_color="#000000" text_font_size="18px" text_letter_spacing="2px" text_line_height="1.2em" text_orientation="center" global_colors_info="{}"]

Unless you've got unlimited time to invest in blog searching, making mistakes, errors
and endless learning curve, use my 15+ years of experience using Excel to streamline your workflow!

[/et_pb_text][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/08/thumb-dan-experience-smaller.jpg" title_text="thumb-dan-experience-smaller" src_last_edited="off|phone" _builder_version="4.9.11" _module_preset="default" custom_padding="|89px||89px|false|true" custom_padding_tablet="|39px||39px|false|true" custom_padding_phone="|0px||0px|false|true" custom_padding_last_edited="on|tablet" global_colors_info="{}"][/et_pb_image][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.9.4" _module_preset="default" background_color="#2d2d2d" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#FFFFFF" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="27px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

Learn My Secrets Of Automation...

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_font_size="25px" text_orientation="center" background_layout="dark" global_colors_info="{}"]

If you liked today's free training, I want to share something that will take you from Excel Novice to Automation Master.

Think about the smartest Excel guru at your office.

Now multiply that times 10 and then add 300 horsepower and magic and...

Ok, well what I mean is imagine you being able to click a button and BAM! Your tasks are done.

This is the power of advanced automation training...

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" admin_label="Section" module_id="uepcintro" _builder_version="4.9.11" _module_preset="default" background_image="http://excelvbaisfun.com/wp-content/uploads/2021/08/class1-background-smaller2.jpg" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#000000" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="27px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

Introducing: The Ultimate Excel VBA Course by Dan Strong

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="rgba(28,28,28,0.93)" text_font_size="24px" text_line_height="1.3em" global_colors_info="{}"]

Now that you've awakened the beast within by completing today's training, you're ready to see what can truly be accomplished with a thorough knowledge of Excel VBA.

In my full-length 30+hour 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.

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.

[/et_pb_text][et_pb_button button_url="/checkouts/uepc-checkout/" button_text="πŸ‘‰ ORDER THE ULTIMATE EXCEL VBA COURSE" button_alignment="center" _builder_version="4.10.4" _module_preset="default" custom_button="on" button_text_color="#FFFFFF" button_bg_color="#e78d3e" button_use_icon="off" background_layout="dark" custom_padding="20px|20px|20px|20px|true|true" hover_enabled="0" locked="off" global_colors_info="{}" sticky_enabled="0"][/et_pb_button][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.9.4" _module_preset="default" background_color="#000000" locked="off" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" custom_padding="||41px|||" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#FFFFFF" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="34px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

After Taking This Course, You’ll…

[/et_pb_text][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/08/dan-teach8-smaller.png" title_text="dan-teach8-smaller" show_bottom_space="off" admin_label="Image" _builder_version="4.9.11" _module_preset="default" transform_scale="60%|60%" transform_scale_tablet="70%|70%" transform_scale_phone="98%|98%" transform_scale_last_edited="on|desktop" transform_translate="1540px|-379px" transform_translate_tablet="602px|-377px" transform_translate_phone="110px|-254px" transform_translate_last_edited="on|phone" transform_translate_linked="off" transform_rotate="0deg|0deg|338deg" transform_rotate_tablet="" transform_rotate_phone="" transform_rotate_last_edited="on|desktop" transform_skew_tablet="" transform_skew_phone="" transform_skew_last_edited="on|desktop" transform_origin_tablet="" transform_origin_phone="" transform_origin_last_edited="on|desktop" transform_styles_last_edited="on|phone" max_width="34%" custom_margin="||-327px||false|false" custom_margin_tablet="||-219px||false|false" custom_margin_phone="||-140px||false|false" custom_margin_last_edited="on|phone" custom_padding="||||false|false" transform_styles_tablet="" transform_styles_phone="" global_colors_info="{}"][/et_pb_image][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_2,1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="24px" text_line_height="1.3em" global_colors_info="{}"]

πŸ‘‰ 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!

[/et_pb_text][/et_pb_column][et_pb_column type="1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="24px" text_line_height="1.3em" global_colors_info="{}"]

πŸ‘‰ 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...

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#FFFFFF" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="27px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

PLUS, You’ll Get…

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="24px" text_line_height="1.3em" global_colors_info="{}"]

πŸ“… Full lifetime access to the course content, updates and to me for 100% complete support

βŒ› Over 30 hours of on-demand video

🎲 30+ Unique Excel Projects, Games and Exercises, and a myriad of Mid-Lecture Challenges!

πŸ’» Hundreds of Powerful, ready-to-use VBA code examples that you can use out of the box

Everything you need to transform your work into play and make Excel do your work for you

AND so much more. . .

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.9.4" _module_preset="default" background_color="#2d2d2d" custom_padding="10px||10px||true|false" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#FFFFFF" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="33px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

See What REAL Students Are Saying About The Ultimate Excel VBA Course

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_2,1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="25px" global_colors_info="{}"]

Matt had massive hurdles with his project at work.

He had been handed a major project that had really stumped him.

After he got our course, he aced the project and his boss was so happy, they gave him a nice BONUS!

Be like Matt.

Ready to streamline your tasks or get your own raise or bonus?

[/et_pb_text][/et_pb_column][et_pb_column type="1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/08/Matt-D.-Testimonial-smaller.jpg" title_text="Matt D. Testimonial-smaller" align="center" _builder_version="4.9.11" _module_preset="default" module_alignment="center" height="440px" global_colors_info="{}"][/et_pb_image][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_2,1_2" module_id="robert-testimonial" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/08/Robert-B-Testimonial-smaller.jpg" title_text="Robert B Testimonial-smaller" align="center" _builder_version="4.9.11" _module_preset="default" width="100%" module_alignment="center" height="440px" global_colors_info="{}"][/et_pb_image][/et_pb_column][et_pb_column type="1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="25px" text_line_height="1.3em" custom_margin="40px||||false|false" global_colors_info="{}"]

Robert used to do everything manually, the boring way..

He's taken several other VBA courses, but they were boring or difficult.

Robert was able to automate most of his work after taking our course.

He says 80% of his tasks at work are now on auto-pilot!!

Naturally, he's mad at himself for waiting so long!

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_2,1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="25px" text_line_height="1.3em" custom_margin="40px||||false|false" global_colors_info="{}"]

John took a boring 4-hour process and used his Excel VBA skills to shave it down to 30 seconds?

That's 30 seconds of him going and getting coffee while the computer did the work for him!

Do you want to join the Excel Automators club?

Grab our course and dive in. Let's put your work on Autopilot too!

[/et_pb_text][/et_pb_column][et_pb_column type="1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/08/John-H.-Testimonial-smaller.jpg" title_text="John H. Testimonial-smaller" align="center" _builder_version="4.9.11" _module_preset="default" width="100%" module_alignment="center" height="440px" global_colors_info="{}"][/et_pb_image][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.9.11" _module_preset="default" background_image="http://excelvbaisfun.com/wp-content/uploads/2021/08/business-people-background-smaller.jpg" background_repeat="repeat" custom_padding="12px||12px||true|false" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" custom_padding="0px||0px||true|false" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#000000" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="33px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

What Will You Get With The Course?

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="rgba(28,28,28,0.93)" text_font_size="24px" text_line_height="1.3em" text_orientation="center" global_colors_info="{}"]

Most beginners have no idea how to get started in programming. That's why we've developed a progressive method; the perfect path from complete newbie to advanced ninja… You get:

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_3,1_3,1_3" _builder_version="4.9.4" _module_preset="default" custom_margin="15px||||false|false" custom_padding="0px||0px||true|false" global_colors_info="{}"][et_pb_column type="1_3" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.4" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#000000" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" global_colors_info="{}"]

LIFETIME ACCESS

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="rgba(28,28,28,0.93)" text_font_size="22px" text_line_height="1.3em" locked="off" global_colors_info="{}"]

Once you're in, you're in. No monthly or annual fees. Ever. You'll be able to come back to the course materials again and again, whenever and wherever works best for you.

[/et_pb_text][/et_pb_column][et_pb_column type="1_3" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.4" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#000000" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" global_colors_info="{}"]

UPDATES

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="rgba(28,28,28,0.93)" text_font_size="22px" text_line_height="1.3em" locked="off" global_colors_info="{}"]

We're constantly updating the course to include new lectures, new ways of doing things, new exercises or games to challenge you and keep you growing. Much of this is due to student feedback, so be sure to drop us a line!

[/et_pb_text][/et_pb_column][et_pb_column type="1_3" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.4" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#000000" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" global_colors_info="{}"]

INSTRUCTOR ACCESS

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="rgba(28,28,28,0.93)" text_font_size="22px" text_line_height="1.3em" locked="off" global_colors_info="{}"]

This is not a fly-by-night operation. We're here to stay and we fully support our student base. We have a forum for questions where the instructor as well as our Excel Ninja community can interact and help you understand the concepts or with errors you may have.

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_2,1_2" _builder_version="4.9.4" width_tablet="82%" width_phone="" width_last_edited="on|tablet" custom_margin="-6px|auto||auto||" custom_padding="15px||21px|||" global_colors_info="{}"][et_pb_column type="1_2" _builder_version="4.4.7" global_colors_info="{}"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/08/certificate-vba.png" title_text="certificate-vba" align="center" _builder_version="4.9.11" custom_margin="9px||||false|false" custom_padding="10px||||false|false" global_colors_info="{}"][/et_pb_image][/et_pb_column][et_pb_column type="1_2" _builder_version="4.4.7" global_colors_info="{}"][et_pb_text content_tablet="" content_phone="" content_last_edited="on|desktop" _builder_version="4.9.4" header_2_font="Roboto|900|||||||" header_2_text_align="center" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" custom_margin="22px|||||" custom_margin_tablet="" custom_margin_phone="0px||||false|false" custom_margin_last_edited="on|phone" custom_padding="|||66px|false|false" custom_padding_tablet="" custom_padding_phone="0px||0px|0px|false|false" custom_padding_last_edited="on|phone" header_2_text_align_tablet="" header_2_text_align_phone="center" header_2_text_align_last_edited="on|phone" header_2_font_size_tablet="" header_2_font_size_phone="28px" header_2_font_size_last_edited="on|phone" locked="off" global_colors_info="{}" custom_padding__hover_enabled="off|desktop"]

 

 

 

[/et_pb_text][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="center" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" custom_margin="22px|||||" custom_margin_tablet="" custom_margin_phone="0px||||false|false" custom_margin_last_edited="on|phone" custom_padding="|||66px|false|false" custom_padding_tablet="" custom_padding_phone="0px||0px|0px|false|false" custom_padding_last_edited="on|phone" header_2_text_align_tablet="" header_2_text_align_phone="center" header_2_text_align_last_edited="on|phone" header_2_font_size_tablet="" header_2_font_size_phone="28px" header_2_font_size_last_edited="on|phone" locked="off" global_colors_info="{}" custom_padding__hover_enabled="off|desktop"]

Show off your new skills: Get a

[/et_pb_text][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="center" header_2_text_color="#d61f2c" header_2_font_size="40px" header_2_line_height="50px" custom_margin="10px|||||" custom_margin_tablet="" custom_margin_phone="-41px||||false|false" custom_margin_last_edited="on|phone" custom_padding="0px||23px|66px|false|false" custom_padding_tablet="" custom_padding_phone="0px||26px|0px|false|false" custom_padding_last_edited="on|phone" header_2_font_size_tablet="" header_2_font_size_phone="27px" header_2_font_size_last_edited="on|phone" locked="off" global_colors_info="{}"]

Certificate of Completion

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.9.4" _module_preset="default" background_color="#0e76a8" background_enable_image="off" locked="off" collapsed="on" global_colors_info="{}"][et_pb_row column_structure="1_2,1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="left" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" custom_margin="0px||||false|false" custom_padding="|||47px|false|false" custom_padding_tablet="" custom_padding_phone="0px||0px|0px|false|false" custom_padding_last_edited="on|phone" header_2_text_align_tablet="" header_2_text_align_phone="center" header_2_text_align_last_edited="on|phone" header_2_font_size_tablet="" header_2_font_size_phone="28px" header_2_font_size_last_edited="on|phone" locked="off" global_colors_info="{}" custom_padding__hover_enabled="off|desktop"]

Add it to your resume, your LinkedIn profile or other professional profiles.…

[/et_pb_text][et_pb_text _builder_version="4.9.4" text_font="Libre Baskerville|300|||||||" text_text_color="rgba(24,39,57,0.94)" text_line_height="26px" custom_margin="11px|47px||47px|false|true" custom_margin_tablet="" custom_margin_phone="|7px||7px|false|true" custom_margin_last_edited="on|phone" global_colors_info="{}"]

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.

[/et_pb_text][/et_pb_column][et_pb_column type="1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/08/linkedin-cert.png" alt="LinkedIn Certificate" title_text="linkedin-cert" _builder_version="4.9.11" _module_preset="default" global_colors_info="{}"][/et_pb_image][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" custom_padding_last_edited="on|tablet" module_id="vidtestimonials" _builder_version="4.9.4" custom_margin_tablet="-53px||||false|false" custom_margin_phone="-83px||||false|false" custom_margin_last_edited="on|phone" custom_padding="0px||0px||false|false" custom_padding_tablet="0px||0px||false|false" custom_padding_phone="0px||0px||false|false" locked="off" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.4.7" custom_padding="||17px|||" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.4.7" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" header_2_font="Roboto|900|||||||" header_2_text_align="left" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" custom_margin="37px|||||" custom_margin_tablet="" custom_margin_phone="0px||||false|false" custom_margin_last_edited="on|phone" custom_padding="|||66px|false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" text_font_size_tablet="" text_font_size_phone="27px" text_font_size_last_edited="on|phone" header_2_text_align_tablet="" header_2_text_align_phone="center" header_2_text_align_last_edited="on|phone" header_2_font_size_tablet="" header_2_font_size_phone="30px" header_2_font_size_last_edited="on|phone" locked="off" global_colors_info="{}"]

What REAL Students Are Saying...

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_2,1_2" use_custom_gutter="on" gutter_width="1" custom_padding_last_edited="on|phone" _builder_version="4.9.4" width="93%" max_width="2090px" custom_padding="29px|200px||200px|false|false" custom_padding_tablet="|38px||38px|false|false" custom_padding_phone="|10px||10px|false|false" global_colors_info="{}"][et_pb_column type="1_2" _builder_version="4.4.7" custom_padding="|2.5px||5px|false|false" global_colors_info="{}"][et_pb_video src="https://vimeo.com/427801638/58e2dd9ee0" thumbnail_overlay_color="rgba(0,0,0,0.6)" _builder_version="4.9.4" width_tablet="100%" width_phone="" width_last_edited="on|desktop" max_width="100%" custom_margin="|34px||34px|false|true" custom_margin_tablet="|0px||0px|false|true" custom_margin_phone="|0px||0px|false|true" custom_margin_last_edited="on|phone" custom_padding_tablet="|0px||0px|false|false" custom_padding_phone="" custom_padding_last_edited="on|desktop" module_alignment_tablet="" module_alignment_phone="" module_alignment_last_edited="on|desktop" global_colors_info="{}" width__hover_enabled="off|desktop"][/et_pb_video][et_pb_testimonial author="Devon Kennedy" job_title="Lead Project Manager Reactor Modifications" company_name="GE-Hitachi Nuclear Energy International, LLC" portrait_url="data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iNTAwIiBoZWlnaHQ9IjUwMCIgdmlld0JveD0iMCAwIDUwMCA1MDAiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+CiAgICA8ZyBmaWxsPSJub25lIiBmaWxsLXJ1bGU9ImV2ZW5vZGQiPgogICAgICAgIDxwYXRoIGZpbGw9IiNFQkVCRUIiIGQ9Ik0wIDBoNTAwdjUwMEgweiIvPgogICAgICAgIDxyZWN0IGZpbGwtb3BhY2l0eT0iLjEiIGZpbGw9IiMwMDAiIHg9IjY4IiB5PSIzMDUiIHdpZHRoPSIzNjQiIGhlaWdodD0iNTY4IiByeD0iMTgyIi8+CiAgICAgICAgPGNpcmNsZSBmaWxsLW9wYWNpdHk9Ii4xIiBmaWxsPSIjMDAwIiBjeD0iMjQ5IiBjeT0iMTcyIiByPSIxMDAiLz4KICAgIDwvZz4KPC9zdmc+Cg==" quote_icon_color="rgba(0,0,0,0)" quote_icon_background_color="rgba(0,0,0,0)" portrait_width="0px" portrait_height="0px" _builder_version="4.9.4" body_text_color="#000000" body_letter_spacing="-0.5px" background_color="#ffffff" transform_translate="0px|-24px" transform_translate_linked="off" custom_margin="|34px||34px|false|true" custom_margin_tablet="|0px||0px|false|true" custom_margin_phone="|0px||0px|false|true" custom_margin_last_edited="on|phone" custom_padding="50px|23px|50px|23px|true|true" border_radii="off|||30px|30px" box_shadow_style="preset1" box_shadow_blur="80px" box_shadow_spread="-10px" global_colors_info="{}"]

... The best part of it is that Dan is extremely interactive with everyone that takes the course. If you have questions he gets back to you immediately and he's always willing to help you... I reached out to him about help with a project I'm doing at work and he's gone above and beyond to make sure that my project got done and all my questions got answered. I would definitely highly recommend the course, it's really great - especially if you're a beginner programmer.

I took the course without knowing anything about programming and I just wanted to improve my Excel skills for the project that I was working on and to improve the over all spreadsheet itself. It's a great course and I highly recommended. Dan is a great instructor for it.

[/et_pb_testimonial][/et_pb_column][et_pb_column type="1_2" _builder_version="4.4.7" custom_padding="|2.5px||2.5px|false|false" global_colors_info="{}"][et_pb_video src="https://vimeo.com/427801305/f3b8bdb174" thumbnail_overlay_color="rgba(0,0,0,0.6)" _builder_version="4.9.4" custom_margin="|34px||34px|false|true" custom_margin_tablet="|0px||0px|false|true" custom_margin_phone="|0px||0px|false|true" custom_margin_last_edited="on|phone" global_colors_info="{}"][/et_pb_video][et_pb_testimonial author="Ben Jacobs" job_title="Category Specialist" company_name="Walmart eCommerce" portrait_url="data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iNTAwIiBoZWlnaHQ9IjUwMCIgdmlld0JveD0iMCAwIDUwMCA1MDAiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+CiAgICA8ZyBmaWxsPSJub25lIiBmaWxsLXJ1bGU9ImV2ZW5vZGQiPgogICAgICAgIDxwYXRoIGZpbGw9IiNFQkVCRUIiIGQ9Ik0wIDBoNTAwdjUwMEgweiIvPgogICAgICAgIDxyZWN0IGZpbGwtb3BhY2l0eT0iLjEiIGZpbGw9IiMwMDAiIHg9IjY4IiB5PSIzMDUiIHdpZHRoPSIzNjQiIGhlaWdodD0iNTY4IiByeD0iMTgyIi8+CiAgICAgICAgPGNpcmNsZSBmaWxsLW9wYWNpdHk9Ii4xIiBmaWxsPSIjMDAwIiBjeD0iMjQ5IiBjeT0iMTcyIiByPSIxMDAiLz4KICAgIDwvZz4KPC9zdmc+Cg==" quote_icon_color="rgba(0,0,0,0)" quote_icon_background_color="rgba(0,0,0,0)" portrait_width="0px" portrait_height="0px" _builder_version="4.9.4" body_text_color="#000000" body_letter_spacing="-0.5px" background_color="#ffffff" custom_margin="|34px||34px|false|true" custom_margin_tablet="|0px||0px|false|true" custom_margin_phone="|0px||0px|false|true" custom_margin_last_edited="on|phone" custom_padding="50px|23px|50px|23px|false|true" border_radii="off|||30px|30px" box_shadow_style="preset1" box_shadow_blur="80px" box_shadow_spread="-10px" global_colors_info="{}"]

I admit I was a little bit skeptical at first that there could be a course on a high-level topic like this that would be both accessible to newbies and could really engage with more experienced Excel users without really pulling them through a slog. I feel like I fell right in the middle of those two categories.Β 

I really love the course! I still have a few more lectures and sections to go but I'm still working through them. It's really really intuitive, it’s really easy and dare I say even fun to watch sometimes.

Again - can't overstate how helpful it's been and I really looking forward to whatever you do next so keep up the good work.

[/et_pb_testimonial][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" module_id="games" _builder_version="4.9.4" _module_preset="default" background_color="#2d2d2d" custom_padding="10px||10px||true|false" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#FFFFFF" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="32px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

What Kind Of Practical Exercises And Games Are Included?

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_2,1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_text_color="#FFFFFF" text_font_size="25px" custom_margin="40px||||false|false" custom_margin_tablet="" custom_margin_phone="-5px||||false|false" custom_margin_last_edited="on|phone" global_colors_info="{}"]

So glad you asked!

We understand that some people learn better by HEARING, some like to READ and SEE, others prefer to experience by DOING.

That's why we designed our curriculum to combine visual, auditory and kinesthetic learning styles into one big awesome course!

Yes, we have a few PowerPoints here and there to help with key concepts, but most of the course is hands-on.

You get to follow along and try new things out all the time to solidify your mental gains!

[/et_pb_text][/et_pb_column][et_pb_column type="1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/08/uepc2_04_PPTExamples-smaller.gif" title_text="uepc2_04_PPTExamples-smaller" align="center" _builder_version="4.9.11" _module_preset="default" module_alignment="center" global_colors_info="{}"][/et_pb_image][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_2,1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/08/wage-calc-smaller.gif" title_text="wage calc-smaller" align="center" _builder_version="4.9.11" _module_preset="default" width="100%" module_alignment="center" global_colors_info="{}"][/et_pb_image][/et_pb_column][et_pb_column type="1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="25px" custom_margin="40px||||false|false" global_colors_info="{}"]

We'll not only learn how to manipulate Cells, Sheets and even Workbooks..

We'll also learn how to manipulate controls using hover effects, images, click events.

In this example, we're able to calculate regular wages OR using special Overtime rules, depending on which macro the user wants to run.

We also are using a special little-known hover trick to make descriptive labels appear elsewhere on the sheet when you hover over a button!

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_2,1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text content_tablet="

We also get to make our own interactive games, such as

Rock, Paper, Scissors

Morse Code Generator

Random Password Generators

Login and Password Userforms (that close the workbook after 3 failed passwords!)

Tic-Tac-Toe (as shown below)πŸ‘‡

" content_phone="

We also get to make our own interactive games, such as

Rock, Paper, Scissors

Morse Code Generator

Random Password Generators

Login and Password Userforms (that close the workbook after 3 failed passwords!)

Tic-Tac-Toe (as shown below)πŸ‘‡

" content_last_edited="on|tablet" _builder_version="4.9.11" _module_preset="default" text_text_color="#FFFFFF" text_font_size="25px" text_line_height="1.3em" custom_margin="40px||||false|false" custom_margin_tablet="" custom_margin_phone="-10px||||false|false" custom_margin_last_edited="on|phone" global_colors_info="{}"]

We also get to make our own interactive games, such as

Rock, Paper, Scissors

Tic-Tac-ToeΒ Β Β Β Β Β Β Β Β Β  (as shown to the right)πŸ‘‰

Morse Code Generator

Random Password Generators

Login and Password Userforms (that close the workbook after 3 failed passwords!)

[/et_pb_text][/et_pb_column][et_pb_column type="1_2" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/08/tic-tac-toe-smaller.webp" title_text="tic-tac-toe-smaller" align="center" _builder_version="4.9.11" _module_preset="default" width="100%" module_alignment="center" global_colors_info="{}"][/et_pb_image][/et_pb_column][/et_pb_row][et_pb_row _builder_version="4.9.4" _module_preset="default" custom_padding="13px|||||" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_text_color="#FFFFFF" text_font_size="32px" custom_margin="18px||||false|false" text_font_size_tablet="" text_font_size_phone="27px" text_font_size_last_edited="on|phone" text_line_height_tablet="" text_line_height_phone="1.3em" text_line_height_last_edited="on|phone" global_colors_info="{}"]

Look how easy it is to perform data entry with this Stock Shares Userform!

[/et_pb_text][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/08/stocksZoom-smaller.gif" title_text="stocksZoom-smaller" align="center" _builder_version="4.9.11" _module_preset="default" width="100%" module_alignment="center" global_colors_info="{}"][/et_pb_image][/et_pb_column][/et_pb_row][et_pb_row _builder_version="4.9.4" _module_preset="default" custom_padding="13px|||||" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_text_color="#FFFFFF" text_font_size="27px" custom_margin="18px||||false|false" text_line_height_tablet="" text_line_height_phone="1.3em" text_line_height_last_edited="on|phone" global_colors_info="{}"]

Make your own custom responsive calculators (or do like I do and combine auto-calculation features with data entry).

You can do so many things with UserForms!!

[/et_pb_text][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/08/uepc2_11_ConversionToolRedo-smaller.gif" title_text="uepc2_11_ConversionToolRedo-smaller" align="center" _builder_version="4.9.11" _module_preset="default" width="100%" module_alignment="center" global_colors_info="{}"][/et_pb_image][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.4.7" custom_padding="0px||0px||false|false" locked="off" global_colors_info="{}"][et_pb_row custom_padding_last_edited="on|tablet" _builder_version="4.4.7" width="55%" width_tablet="100%" width_phone="" width_last_edited="on|tablet" custom_padding="||||false|false" custom_padding_tablet="0px||0px||false|false" custom_padding_phone="" module_alignment_tablet="center" module_alignment_phone="" module_alignment_last_edited="on|tablet" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.4.7" global_colors_info="{}"][et_pb_text _builder_version="4.10.4" header_2_font="Roboto|900|||||||" header_2_text_align="center" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" text_orientation="center" custom_margin="37px|||||" custom_margin_tablet="" custom_margin_phone="0px||||false|false" custom_margin_last_edited="on|phone" custom_padding="||||false|false" custom_padding_tablet="" custom_padding_phone="15px|||0px|false|false" custom_padding_last_edited="on|phone" header_2_text_align_tablet="" header_2_text_align_phone="center" header_2_text_align_last_edited="on|phone" header_2_font_size_tablet="" header_2_font_size_phone="33px" header_2_font_size_last_edited="on|phone" header_2_line_height_tablet="" header_2_line_height_phone="50.8px" header_2_line_height_last_edited="on|phone" locked="off" global_colors_info="{}" custom_padding__hover_enabled="off|desktop"]

Your Full Course Curriculum

[/et_pb_text][et_pb_text _builder_version="4.10.4" header_4_font="Roboto|900|||||||" header_4_text_align="center" header_4_text_color="#1a1a1a" header_4_font_size="22px" header_4_line_height="28px" text_orientation="center" global_colors_info="{}"]

THE ULTIMATE EXCEL VBA COURSE

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row custom_padding_last_edited="on|tablet" _builder_version="4.4.7" width="55%" width_tablet="83%" width_phone="93%" width_last_edited="on|phone" custom_padding_tablet="||0px||false|false" custom_padding_phone="" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.4.7" global_colors_info="{}"][et_pb_toggle title="The Range Object" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.10.4" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" global_colors_info="{}"]

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
[/et_pb_toggle][et_pb_toggle title="Range Properties" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" global_colors_info="{}"]

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
[/et_pb_toggle][et_pb_toggle title="The Cells Object" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" global_colors_info="{}"]

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
[/et_pb_toggle][et_pb_toggle title="Variables" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" global_colors_info="{}"]

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
[/et_pb_toggle][et_pb_toggle title="Toolbars and Menus" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" global_colors_info="{}"]

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
[/et_pb_toggle][et_pb_toggle title="Super Important Tools and Excel Logic" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" global_colors_info="{}"]

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
[/et_pb_toggle][et_pb_toggle title="Loops and Report Writing Basics" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" global_colors_info="{}"]

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
[/et_pb_toggle][et_pb_toggle title="EVENTS: Worksheet Events made Easy" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" global_colors_info="{}"]

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
[/et_pb_toggle][et_pb_toggle title="WorkBook Events" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" global_colors_info="{}"]

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
[/et_pb_toggle][et_pb_toggle title="ActiveX Controls on Worksheets" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" global_colors_info="{}"]

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
[/et_pb_toggle][et_pb_toggle title="Userforms - the best thing. EVER." open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" global_colors_info="{}"]

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. . .
[/et_pb_toggle][et_pb_toggle title="BONUS Section - VBA Functions" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_line_height="26px" border_width_all="0px" border_width_bottom="2px" global_colors_info="{}"]

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
[/et_pb_toggle][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" admin_label="Section" _builder_version="4.9.4" _module_preset="default" background_color="#2d2d2d" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#FFFFFF" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="27px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

And of Course, Your Bonuses...

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_3,1_3,1_3" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="1_3" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#FFFFFF" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="27px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

1. Excel VBA Master Keyboard Shortcuts Cheat Sheet

[/et_pb_text][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/05/bestmockShade250.png" title_text="bestmockShade250" align="center" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][/et_pb_image][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="24px" text_line_height="1.3em" global_colors_info="{}"]

It's no secret that knowing keyboard shortcuts can drastically cut down the time it takes to get stuff done.

Our new cheat sheet now comes with more efficiency-boosting keyboard shortcuts (for both PC and Mac) than anywhere else, including hidden (undocumented) shortcuts that aren't listed online or elsewhere!

[/et_pb_text][/et_pb_column][et_pb_column type="1_3" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#FFFFFF" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="27px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

2. BONUS Images Pack

[/et_pb_text][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/05/image-bonus-small.png" title_text="image-bonus-small" align="center" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][/et_pb_image][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="24px" text_line_height="1.3em" global_colors_info="{}"]

We've put together a Bonus pack of Mouse Cursors, Icons and Background Images that you can use to make Buttons and Userforms look infinitely more professional as well as several mouse cursors for customized hover effects!

We'll show you exactly how to maximize images using Dan's imaging secrets in Excel to shave off loads of learning time.

[/et_pb_text][/et_pb_column][et_pb_column type="1_3" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#FFFFFF" text_font_size="40px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="27px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

3. Limited Discount Offer

[/et_pb_text][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/05/20-offcrp-noback250.png" title_text="20 offcrp-noback250" align="center" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][/et_pb_image][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="24px" text_line_height="1.3em" global_colors_info="{}"]

Special offer for today's attendees!

I want to say Thank You for joining our training session today with a special discount.

If you order using this order page, I'm going not only going to give you all the bonuses previously mentioned, but I'm also offering an additional 20% off if you order today using the below link.

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" admin_label="Section" _builder_version="4.9.11" _module_preset="default" background_image="http://excelvbaisfun.com/wp-content/uploads/2021/08/success-and-freedom-background-smaller3.jpg" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#000000" text_font_size="50px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="32px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

But Dan, How Do I Know It'll Work for Me?

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="rgba(28,28,28,0.93)" text_font_size="24px" text_line_height="1.3em" global_colors_info="{}"]

First, let's address who this will NOT work for...

This course is NOT for you if…

❌you're not interested in learning, you just want to immediately post a very specific macro you want somebody else to write for you

❌you just want someone to do your homework for you or answer quiz questions for you...

❌if you can't sit still for 10 to 15 minutes at a time

On the flip side:

This course is right for you if you…

βœ… are someone who wants to learn Automation secrets in Excel VBA.

βœ… are complete newbies and/or students looking for a refresher or Reference tool, to pick and choose relevant lessons for their projects.

βœ… have NO prior programming knowledge that's ok - it's not needed.

βœ… are ready to automate your repetitive tasks with over 30.5 hrs of real-world examples, exercises, projects, games and quizzes, this is for you.

βœ… use Excel for PC or Mac... we teach BOTH!

βœ… want to get the edge at work; for your boss to think you're working late or are extremely fast at your job!

[/et_pb_text][et_pb_button button_url="/checkouts/uepc-checkout/" button_text="πŸ‘‰ ORDER THE ULTIMATE EXCEL VBA COURSE" button_alignment="center" _builder_version="4.10.4" _module_preset="default" custom_button="on" button_text_color="#FFFFFF" button_bg_color="#e78d3e" button_use_icon="off" background_layout="dark" custom_padding="20px|20px|20px|20px|true|true" hover_enabled="0" global_colors_info="{}" sticky_enabled="0"][/et_pb_button][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.9.4" _module_preset="default" background_color="#2d2d2d" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#FFFFFF" text_font_size="50px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="33px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

Here's What Happens When You Click The Button, Complete the Payment, and Join

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="24px" text_line_height="1.3em" global_colors_info="{}"]

1. You'll see a thank you page which you can immediately exit (nothing important here)

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="24px" text_line_height="1.3em" global_colors_info="{}"]2. You'll receive a welcome email with your login details to the course[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="24px" text_line_height="1.3em" global_colors_info="{}"]

3. You've now got personal support from myself (Dan) and other students in our course forum, for as long as you need/want our help...

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="24px" text_line_height="1.3em" global_colors_info="{}"]

4. ​You watch and participate with our training, try all the exercises, projects, games, mid-lecture challenges, put in the work, and then you start looking at everything from a different perspective. You'll start seeing opportunities for automation and new solutions everywhere!

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" admin_label="Section" _builder_version="4.9.11" _module_preset="default" background_image="http://excelvbaisfun.com/wp-content/uploads/2021/08/futuristic-smaller2.jpg" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#000000" text_font_size="60px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="33px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

Click on the Button and Complete Your Payment For Instant Access to Our Excel VBA Training

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="rgba(28,28,28,0.93)" text_font_size="30px" text_line_height="1.3em" global_colors_info="{}"]

In case you skipped down here without reading anything else. Here's the offer:

We're going to provide you with ALL the Excel VBA training you need to write code from scratch that saves you time and effort and makes you an Excel Ninja...

This includes 30+ hours of video training along with tons of Unique Excel Projects, Games and Exercises, and a myriad of Mid-Lecture Challenges, Hundreds of Powerful, ready-to-use VBA code examples that you can use out of the box.

Every section comes with both the Ready-To-Follow-Along Clean workbooks as well as the Completed Excel workbooks!

This training program will help you streamline your work and the work of others and make you indispensable to your company!

[/et_pb_text][et_pb_button button_url="/checkouts/uepc-checkout/" button_text="πŸ‘‰ ORDER THE ULTIMATE EXCEL VBA COURSE" button_alignment="center" _builder_version="4.10.4" _module_preset="default" custom_button="on" button_text_color="#FFFFFF" button_bg_color="#e78d3e" button_use_icon="off" background_layout="dark" custom_padding="20px|20px|20px|20px|true|true" hover_enabled="0" global_colors_info="{}" sticky_enabled="0"][/et_pb_button][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" module_id="faq" _builder_version="4.9.4" _module_preset="default" background_color="#2d2d2d" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#FFFFFF" text_font_size="60px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="33px" text_font_size_last_edited="on|desktop" global_colors_info="{}"]

Frequently Asked Questions

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="#FFFFFF" text_font_size="30px" text_line_height="1.3em" global_colors_info="{}"]

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!

[/et_pb_text][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2021/08/mac-support-smaller.webp" title_text="mac-support-smaller" _builder_version="4.9.11" _module_preset="default" custom_padding="|58px||58px|false|true" custom_padding_tablet="|50px||50px|false|true" custom_padding_phone="|0px||0px|false|true" custom_padding_last_edited="on|desktop" global_colors_info="{}"][/et_pb_image][et_pb_button button_url="/checkouts/uepc-checkout/" button_text="πŸ‘‰ ORDER THE ULTIMATE EXCEL VBA COURSE" button_alignment="center" _builder_version="4.10.4" _module_preset="default" custom_button="on" button_text_color="#FFFFFF" button_bg_color="#e78d3e" button_use_icon="off" background_layout="dark" custom_padding="20px|20px|20px|20px|true|true" hover_enabled="0" global_colors_info="{}" sticky_enabled="0"][/et_pb_button][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" admin_label="Section" module_id="join" _builder_version="4.9.11" _module_preset="default" background_image="http://excelvbaisfun.com/wp-content/uploads/2021/08/pc-thinner.jpg" collapsed="on" global_colors_info="{}"][et_pb_row _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" global_colors_info="{}"][et_pb_text _builder_version="4.9.11" _module_preset="default" text_font="Oswald|600|||||||" text_text_color="#000000" text_font_size="59px" text_letter_spacing="1px" text_line_height="1.2em" text_orientation="center" text_font_size_tablet="" text_font_size_phone="33px" text_font_size_last_edited="on|phone" global_colors_info="{}"]

Join The Ultimate Excel VBA Course Today and
Learn to Put Excel On Auto-Pilot

[/et_pb_text][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="rgba(28,28,28,0.93)" text_font_size="30px" text_line_height="1.3em" global_colors_info="{}"]

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"...

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_2,1_2" _builder_version="4.9.4" width_tablet="" width_phone="90%" width_last_edited="on|phone" custom_padding="||16px|||" global_colors_info="{}"][et_pb_column type="1_2" _builder_version="4.4.7" global_colors_info="{}"][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="left" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" custom_margin="37px|||||" custom_margin_tablet="" custom_margin_phone="0px||||false|false" custom_margin_last_edited="on|phone" custom_padding="|||66px|false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" header_2_text_align_tablet="" header_2_text_align_phone="center" header_2_text_align_last_edited="on|phone" header_2_font_size_tablet="" header_2_font_size_phone="30px" header_2_font_size_last_edited="on|phone" locked="off" global_colors_info="{}"]

The ExcelVbaIsfun guarantee:

[/et_pb_text][et_pb_text _builder_version="4.4.7" text_font="Roboto Slab|300|||||||" text_text_color="#000000" text_font_size="17px" text_line_height="2.4em" ul_font="Libre Baskerville||||||||" ul_text_color="rgba(24,39,57,0.94)" ul_font_size="16px" ul_line_height="26px" custom_margin="-23px||||false|false" custom_margin_tablet="" custom_margin_phone="0px||||false|false" custom_margin_last_edited="on|phone" custom_padding="|||66px|false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" ul_font_size_tablet="" ul_font_size_phone="" ul_font_size_last_edited="on|phone" locked="off" global_colors_info="{}" custom_padding__hover_enabled="off|desktop"]
  • 30-day no questions asked money back period
  • Use your new skills immediately as you learn.
[/et_pb_text][et_pb_text _builder_version="4.4.7" header_3_font="Roboto|900|||||||" header_3_text_color="#1a1a1a" header_3_font_size="28px" header_3_line_height="35px" header_3_font_size_tablet="" header_3_font_size_phone="25px" header_3_font_size_last_edited="on|phone" global_colors_info="{}"]

Lifetime Access for a one-time fee

[/et_pb_text][et_pb_wc_price product="60760" _builder_version="4.9.4" text_orientation="center" global_colors_info="{}"][/et_pb_wc_price][et_pb_button button_url="/checkouts/uepc-checkout/" button_text="πŸ‘‰ ORDER THE ULTIMATE EXCEL VBA COURSE" button_alignment="center" _builder_version="4.10.4" _module_preset="default" custom_button="on" button_text_color="#FFFFFF" button_bg_color="#e78d3e" button_use_icon="off" background_layout="dark" custom_padding="20px|20px|20px|20px|true|true" hover_enabled="0" global_colors_info="{}" sticky_enabled="0"][/et_pb_button][et_pb_text _builder_version="4.4.7" text_font="Libre Baskerville||on||||||" text_text_color="rgba(24,39,57,0.94)" text_line_height="26px" text_orientation="center" global_colors_info="{}"]

All courses come with a 30-day money back guarantee.

[/et_pb_text][/et_pb_column][et_pb_column type="1_2" _builder_version="4.4.7" global_colors_info="{}"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2020/06/paypal-verifieddan.png" title_text="paypal-verifieddan" _builder_version="4.9.11" global_colors_info="{}"][/et_pb_image][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2020/06/30day-guarantee.png" title_text="30day-guarantee" _builder_version="4.4.7" global_colors_info="{}"][/et_pb_image][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.9.4" _module_preset="default" collapsed="on" global_colors_info="{}"][et_pb_row use_custom_gutter="on" make_equal="on" _builder_version="4.9.4" _module_preset="default" width="100%" max_width="100%" module_alignment="center" global_colors_info="{}"][et_pb_column type="4_4" _builder_version="4.9.4" _module_preset="default" custom_padding="|0px||0px|false|true" global_colors_info="{}"][et_pb_text _builder_version="4.9.4" _module_preset="default" text_text_color="rgba(28,28,28,0.93)" text_font_size="22px" text_line_height="1.3em" text_orientation="center" global_colors_info="{}"]

Β© 2021 - Strong Software Solutions LLC | ExcelVbaIsFun - Privacy Policy - Terms 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.

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
LEARN MORE
Copyright Β© 2024 ExcelVbaIsFun
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram