Excel Userforms for Beginners (10/10) – Use Excel VBA to Create A Userform and Manage a Database

Excel Userforms for Beginners – Use Excel VBA to Create A Userform and Manage a Database

Link to download files:
Link to playlist for Excel Userforms series:

Video 1 – Introduction To Excel Userforms
Video 2 – Create an Excel Userform, Add a ‘Control’
Video 3 – Build up an Excel Userform, Add Labels, TextBoxes, ComboBoxes
Video 4 – Maximise User-Friendliness of an Excel Userform
Video 5 – Link the Excel Userform to the Spreadsheet Using Excel VBA
Video 6 – Position data precisely in the database using Excel VBA
Video 7 – Control and Helpful User Interaction in Excel Userforms
Video 8 – Use an Excel Userform to Edit Existing Data
Video 9 – Load Data from a Database into an Excel Userform
Video 10 – Creating a Sense of Mode – ‘Add New’ and ‘Edit Existing’

Note: Chris did do some ‘tidying up’ of the code after shooting, to improve the quality of the completed file. This involved improving the in-code annotations and the structure of the code. No new coding ideas were introduced, however, and the mechanisms all work in the same way. Don’t feel that you should copy every detail of Chris’ approach, however; you now have the tools to design and implement your own powerful Excel userform-based applications. Good luck!

🎁YOUR EXCEL CHEATSHEET
🎁1 Page Summary Of What You Need To Know

Get in touch with Tiger using the platforms below!
For regular spreadsheet hints and tips and more on the #ExcelRevolution:

[chromebook]

Chris - I'm an old dog (semi-retired) but with your help I have now learned new tricks and have applied them to improve several excel workbooks we use to process financial data at my part-time job. On behalf of myself and the young couple I work for thank you from Dallas, Texas

[calvinelikem]

A month ago I had no knowledge in VBA but after working through your VBA for beginners playlists and other playlists on the channel I've become quite proficient with VBA and I'm now handling all the routine and coding tasks in the office. I've applied everything I learnt from the channel in very interesting ways. Your userform videos helped a lot in creating userforms that could be used outside the office. Thank you for all your great videos and I hope to see more from you.

[Poulsen]

Great course. Thank you very much. I took you course on VBA for beginners about a year ago, and now i have returned. I was not disappointed.

Kind regards from Denmark

[Hey_Delight]

I made a disbursement system using only excel formulas and functions because i was reluctant to study VBA, but when i saw this tutorial and finished the whole process, i was hooked.
And because of you Sir, i incorporated VBA into my disbursement system, it has now data entry forms that will not only make my reports efficient but will make my colleagues data entry procedures and reports generation faster and more efficient.
Thank you very much for your exemplary teaching.

[Nigromancy]

Just going to echo the comments here - you my friend are a GODSEND! Cannot believe I was able to follow along and actually recreate this - learnt so much about VBA from this ! thank you!

[KSHOE]

I want to thank-you for you tutorial videos. I spent an entire day watching your 10 videos and following along with my own sheet. I have tried watching other videos across YouTube and you are the only one who broke the coding down to the basic level. Most of the other videos just tell you what coding to type, but there is no explanation behind what coding you are really trying to type or do. Your videos brought coding to an elementary type level. Obviously I need more time to practice but you definitely provided me a foundation or place to start. Thank you again.

[rjm]

I just went through the 10 lessons and cannot thank you enough for the beginning skill-set. I will now try the new skills on a large db I have been working. Your a great teacher and I thank you for your effort to move those along the path.

[Sir_Gallant]

I just wanted to let you know that thanks to these videos I was able to create a working inventory system for my father's small business. What's so great about it is that since you explained the process, implementation, and theory, I was able to not only replicate your file but build a completely new system. I even coded an undo button that deletes a previous entry made in "NEW" mode and stores the previous version of an edit made in the engine. That way when in edit mode pressing the undo button reverts the last edited entry into its previous version! Recycling code is a godsend.

[herogalaxyhuang]

I have done your 10 videos on Userforms in one day and it's great. Thank you very much.

[nikon]

you taught me an entire course worth of excel in one night....

[tracycritchley]

A big Thank You for these videos and step by step instructions. You are a great teacher!! This series helped me look like a "Rock Star"!!

[MickHollywood]

Just like many before me I have thoroughly appreciated and enjoyed all 10 videos, I am new to visual basic and your explanations are clear and easy to follow. Just hope I can go on and use what I have learnt.

[mariyatsvetanova]

Excellent video lecture, again! Already three months with your channel and I know so much more. If I could, I would rate for the teacher of the year Chris! This is the least you deserve! Thank you!

[ridwanbello]

Many special thanks for this video series, Chris. I have been learning Excel from different platforms and different teachers, and this has got to be one of the most useful lessons I have had in my learning journey. You are such a good teacher!

[sbors]

Simply spectacular! In 10 easy to follow videos you helped me create my very first UserForm to streamline daily registrations and edits for the company I work for. Worth noting that I’ve been struggling to achieve this for the past 5 days following different tutorials or trying to decode stackoverflow.
Thank you again!!

[MaiNguyen-rlvo]

THE LOVE I HAVE FOR THIS GUY!!!! AMAZING HUMAN BEING!! <3

[KN-wins]

Chris, thank you kindly for your effort and time in putting this together. It is appreciated. I’m really good with excel, but have never ventured into VB. I’ve just completed this series. I now feel empowered to take my Excel skills up a notch. You’re a really great tutor, and I will be recommending this channel to all who will listen. Greetings from South Africa 🇿🇦

[Alibabachalise]

Dear Sir, I personally thank you for those 10 lessons. I learned excel Userforms for beginners well. Once again thank you for the good lesson.

[zackaryahhughes]

Thank you for so much for producing these videos, they are immediately beneficial. You explain everything very methodically, calm, and collected and really alleviate the fright of learning to code. I know there is exponentially more to learn but I really appreciate you taking the time to make these videos and go over very work pertinent material.

[johnsoncheung]

Thanks for showing me how to handle Excel using UserForm. Before, I always think Excel is just for 'What if' analyst. I appreciate your way of coding bit by bit and test it. This lets me know what is the going on by using those coding. These videos are amazing. Thumb up for you.