Excel Userforms for Beginners (1/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:

[mofojackson]

Dude your videos are so rad bro! Just started watching your beginners vids the other night and by far you're one of the best teachers on Excel I have encountered! Interactive, simple learnable examples with explanations of what is doing what. Definitely a fan and you rock mate!

[shubhamrastogi]

You rock dude! Millions of Bow down! Really disheartened to see that not too much people have commented. Have watched your whole videos on Macros. They were simply commendable. The presentation is fantabulous. Looking forward videos on MS word and Excel that really cut down a lot of time.

[billmurphy]

Chris, thank you so much for putting together this excellent series of tutorials. I was able to learn just enough VB in just a couple of hours to build a working prototype.

[jeffnichols]

This was a masterful presentation and of great educational value. The entire series is excellent - Thank You

[alisattar]

Hi chris
Your tutorials are so complete and useful ... Never give up training sir ...

[kimbilton]

Hi Chris.
Im a beginer, with VBA
I have watched a lot of videos out there, signed up for a VBA course from others (not as good as you), now I find you. I think your a great instructor, clear and concise. look forward to more.
One comment, the full name combo box lookup. what about sorting to make it easier to look up names?

[patjohnson]

Just what I needed. Thanks for the help! I'll be back for more!

[alastairgraham]

Great series! Informative and bridges many skills. Also very readily applicable to tasks I need to get done at work!

[jbp]

Thank you for this video sir. New subscriber here. Please continue sharing your skills. God bless

[hessymiha]

Your Tutorials are the best, clearly explained.
Can you be contacted for excel problem solving?

[hobstar]

I'm excited for this. Subbed and liked

[austinevrenthfamily]

good day,
do you have a inventory management video using vba userform?

[cristianpaius]

Thank You for this tutorial .Is great I made almost the same but a need a code in vba to change in a colum from userform number not text.Thank You

[slurrypumper]

Well it eventually would happen and the time has come. Since the NFL is changing from 16 to 17 games, I will take this time in the next 2. months to update and make a brand new data base. Last time was way back in 2002 when the NFL reset the divisions so I have had almost 20 years to think about how I want it to look. Over the next few weeks I expect to be very frustrated and hopefully in the end I will learn a few more things that I didn't know how to do within the excel platform.

[ExcelWithChris]

Hi Chris, hope this message finds you. I see you already published two years ago. I am just starting out with VB (no experience at all). This will be great as a starting point. I am also a Microsoft Certified Trainer and would also like to create videos. I have tried (you can see on my Channel) using Camtasia. Could you please tell me what you use to record? Hope to hear from you. From another Chris (this one in South Africa)

[sohjunwen]

Wow it’s not easy to drive and introduce your videos at the same time hahah

[cristianpaius]

So in data sheet to appear as number not text