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

Recent Posts

Save Time and Money with Excel VBA Is Fun tips and tricks!

Exercise 06a - Objectives Overview

Exercise 06a - Objectives Overview

Exercise 04 - Objectives Overview

Exercise 04 - Objectives Overview

Exercise 03 - Solution

Exercise 03 - Solution

Exercise 03 - Objectives Overview

Exercise 03 - Objectives Overview

Exercise 02b - Solution

Exercise 02b - Solution

Exercise 02b - Objectives Overview

Exercise 02b - Objectives Overview

Exercise 02a - Solution

Exercise 02a - Solution

Exercise 02a - Objectives Overview

Exercise 02a - Objectives Overview

Exercise 01 - Solution

Exercise 01 - Solution

Exercise 01 - Objectives Overview

Exercise 01 - Objectives Overview

BONUS LECTURE

BONUS LECTURE

Count Function in VBA

Count Function in VBA

Sum Function in Excel VBA - EASY!

Sum Function in Excel VBA - EASY!

The EVALUATE Function - Mac-Daddy of all functions

The EVALUATE Function - Mac-Daddy of all functions

InStr Function - Search for Text Within Other Text

InStr Function - Search for Text Within Other Text

Concluding Thoughts. . .

Concluding Thoughts. . .

Advanced Exercise BONUS C Automate the Workflow for Efficiency - Solutions

Advanced Exercise BONUS C Automate the Workflow for Efficiency - Solutions

Advanced Exercise BONUS A and B - Solutions

Advanced Exercise BONUS A and B - Solutions

Advanced Exercise 03 and 04 - Solutions

Advanced Exercise 03 and 04 - Solutions

Advanced Exercise 02 - Solution

Advanced Exercise 02 - Solution

Advanced Exercise 01 - Solution

Advanced Exercise 01 - Solution

Advanced Exercise - Objectives Overview

Advanced Exercise - Objectives Overview

EEOC Report For Employee Stats (VBA Efficiency Tricks)

EEOC Report For Employee Stats (VBA Efficiency Tricks)

Alternating Row Colors or Lines Using Conditional Formatting (Zebra)

Alternating Row Colors or Lines Using Conditional Formatting (Zebra)

Programmatically Update Page Headers and Footers - Plus Special Formatting Code

Programmatically Update Page Headers and Footers - Plus Special Formatting Code

Report Generation and Aesthetics, Headers, Footers, Repeat Rows etc

Report Generation and Aesthetics, Headers, Footers, Repeat Rows etc

Offering Users Different Sort Options For Reporting

Offering Users Different Sort Options For Reporting

Applying Dynamic Custom Filters To Reports (2 Ways)

Applying Dynamic Custom Filters To Reports (2 Ways)

Userform Employee Report - Set Up Dynamic Column Variables (Easy Hack)

Userform Employee Report - Set Up Dynamic Column Variables (Easy Hack)

Log In Program Exercise 2.0 - Solution

Log In Program Exercise 2.0 - Solution

Log In Program Exercise 2.0 - Userform With UserName and Password (Overview)

Log In Program Exercise 2.0 - Userform With UserName and Password (Overview)

How Usernames and Passwords Work - Encryption, Hashing, Salt Basics

How Usernames and Passwords Work - Encryption, Hashing, Salt Basics

Advanced MultiColumn Search Tools - Custom Lookup by Name, ID, and More!

Advanced MultiColumn Search Tools - Custom Lookup by Name, ID, and More!

Easy Way To Copy A UserForm or Module (2 Methods)

Easy Way To Copy A UserForm or Module (2 Methods)

UserForm Final Cleanup and Tips

UserForm Final Cleanup and Tips

Refreshing the Rowsource After Updating Data On Dynamic ComboBoxes

Refreshing the Rowsource After Updating Data On Dynamic ComboBoxes

Troubleshooting Tips For ListBox With Empty String

Troubleshooting Tips For ListBox With Empty String

Edit Mode for Employee DataSet - Part 7 - Saving Existing Records In Edit Mode

Edit Mode for Employee DataSet - Part 7 - Saving Existing Records In Edit Mode

Edit Mode Part 6 - Switch Search Mode To ID, Name, LastName, etc

Edit Mode Part 6 - Switch Search Mode To ID, Name, LastName, etc

Edit Mode for Employee DataSet - Part 5 - Load Picture From DataSet File Name

Edit Mode for Employee DataSet - Part 5 - Load Picture From DataSet File Name

Edit Mode for Employee DataSet - Part 4 - Load & Select ListBox Entry from Data

Edit Mode for Employee DataSet - Part 4 - Load & Select ListBox Entry from Data

Edit Mode for Employee Database - Part 3 - Loading The Form Based On Selection

Edit Mode for Employee Database - Part 3 - Loading The Form Based On Selection

Edit Mode for Employee Database - Part 2 - Custom Function to Find Row of Emp ID

Edit Mode for Employee Database - Part 2 - Custom Function to Find Row of Emp ID

Edit Mode for Employee Database - Part 1

Edit Mode for Employee Database - Part 1

Data Entry Userform Project - Creating A Function To Validate Required Fields

Data Entry Userform Project - Creating A Function To Validate Required Fields

Data Entry Userform Project - Adding User Photos and Using GetOpenFilePath() Fun

Data Entry Userform Project - Adding User Photos and Using GetOpenFilePath() Fun

Data Entry Userform Project - Resetting The Form Upon Submission

Data Entry Userform Project - Resetting The Form Upon Submission

Data Entry Userform Project - Coding Employment Tab and Automation

Data Entry Userform Project - Coding Employment Tab and Automation

Data Entry Userform Project - Set Up Employment Tab and Planning

Data Entry Userform Project - Set Up Employment Tab and Planning

Data Entry Userform Project - Tab Order and Data Cleanup Tricks

Data Entry Userform Project - Tab Order and Data Cleanup Tricks

Data Entry Userform Project - Get Next Available Employee ID Custom Function (UDF)

Data Entry Userform Project - Get Next Available Employee ID Custom Function (UDF)

Data Entry Userform Project - Adding A 'Save New' Button For 'Personal' Tab

Data Entry Userform Project - Adding A 'Save New' Button For 'Personal' Tab

Data Entry Userform Project - Filling ComboBoxes and Planning (2 Ways)

Data Entry Userform Project - Filling ComboBoxes and Planning (2 Ways)

Data Entry Userform Project - Employee Form Setup Tab 1

Data Entry Userform Project - Employee Form Setup Tab 1

Data Entry In Excel vs Access Or Other Sources

Data Entry In Excel vs Access Or Other Sources

Conversion Userform Tool Exercise - Solutions Video

Conversion Userform Tool Exercise - Solutions Video

Conversion Userform Tool Exercise - Objectives Overview

Conversion Userform Tool Exercise - Objectives Overview

Centering A Userform On A Window (Even With Multiple Monitors)

Centering A Userform On A Window (Even With Multiple Monitors)

New ActiveX Controls - Frame

New ActiveX Controls - Frame

New ActiveX Controls - MultiPage - Backcolors and Color Workaround

New ActiveX Controls - MultiPage - Backcolors and Color Workaround

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
X

Forgot Password?

Join Us

0
    0
    Your Cart
    Your cart is emptyReturn to Shop
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram