The Excel UserForms for Data Entry ebook kit will take you
through the steps to build a UserForm that stores data on a hidden
worksheet. You don't need to be an experienced programmer -- everything
is explained in simple steps, with written instructions, screen shots,
videos and workbooks.
There are also 2 bonus add-ins
UserForm Builder -- quickly creates a simple UserForm for you.
Search Form Builder -- quickly builds a UserForm with search boxes, so you can add, update or delete records in an Excel Table
Latest version: 4.00, August 8, 2019 (added the Search Form Builder)
What's In the Kit?
To guide you through the steps to build the UserForms, the kit contains:
an 89 page written lesson guide (PDF
format), with video tutorials and demos
It is for Windows versions only -- not designed for Macintosh Excel
The Lesson Guide
Both of the projects in the 89-page ebook (pdf format) are explained
in detail. For each project, there are:
written descriptions that carefully explain what to do
screen shots that show the workbook and Visual Basic Editor
(shows Excel 2010 screen)
video links, so you can see a demo of the steps
The lesson guide:
is formatted in a generous sized 13 pt font, so it's easy to read.
is saved in Adobe PDF forma
has a table of contents with bookmarks, for easy navigation.
has an index so you can find the steps later
Step by Step Projects
For each step by step project, there is:
a completed workbook, so you can see how the UserForm works,
before you begin building it.
a starting file, so that you can skip the preliminary steps,
if you wish to, and get right to the UserForm construction.
The course has 2 step by step projects, and you can see a demo of
project 2 in the video below.
Project 1: Simple UserForm with textboxes
Project 2: UserForm with dependent comboboxes; Pivot Table report
to summarize inventory
Bonus Add-in 1 - UserForm Builder
Use this tool to make a simple UserForm for data entry, based on a table in your workbook. This short video shows you how quick and easy it is -- much faster than building from scratch!
Bonus Add-in 2 - Search Form Builder
Use this tool to make a powerful UserForm for data entry, based on a table in your workbook. Choose fields for the Search Boxes, then find and update existing records, or add new records.
There are 5 bonus files in the
UserForm kit. These do not include step by step instructions, but
there is a User Guide that outlines the key settings in each form,
and a demo video that shows how each form works. Also, you can examine
the code to see how the advanced techniques work.
Bonus 1: Golf Tee Off Time Assignments &