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

10 Excel Userforms - Part II

Current Status

Not Enrolled

Price

$49.00

Get Started

Course Content

Excel UserForms – Part II
Intro to Userforms II (Plus Download Kit)
Data Entry In Excel vs Access Or Other Sources
Data Entry Userform Project - Employee Form Setup Tab 1
Data Entry Userform Project - Filling ComboBoxes and Planning (2 Ways)
Data Entry Userform Project - Tab Order and Data Cleanup Tricks
Data Entry Userform Project - Set Up Employment Tab and Planning
Data Entry Userform Project - Coding Employment Tab and Automation
Data Entry Userform Project - Resetting The Form Upon Submission
Edit Mode for Employee Database - Part 1
Edit Mode Part 6 - Switch Search Mode To ID, Name, LastName, etc
Troubleshooting Tips For ListBox With Empty String
Refreshing the Rowsource After Updating Data On Dynamic ComboBoxes
UserForm Final Cleanup and Tips
Easy Way To Copy A UserForm or Module (2 Methods)
How Usernames and Passwords Work - Encryption, Hashing, Salt Basics
Log In Program Exercise 2.0 - Solution
Userform Employee Report - Set Up Dynamic Column Variables (Easy Hack)
Applying Dynamic Custom Filters To Reports (2 Ways)
Offering Users Different Sort Options For Reporting
Report Generation and Aesthetics, Headers, Footers, Repeat Rows etc
Alternating Row Colors or Lines Using Conditional Formatting (Zebra)
EEOC Report For Employee Stats (VBA Efficiency Tricks)
Advanced Exercise - Objectives Overview
Advanced Exercise 01 - Solution
Advanced Exercise 02 - Solution
Advanced Exercise 03 and 04 - Solutions
Advanced Exercise BONUS A and B - Solutions
Concluding Thoughts. . .

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 © 2025 ExcelVbaIsFun
X

Forgot Password?

Join Us

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram