Excel Userforms for Beginners (4/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!

***FREE*** Exclusive Blog Membership With Tiger
- Exclusive Content For Blog Members
- Exclusive Discounts On Tiger Products
- Selected Notifications To Your Inbox
- Join The Discussion In The Website Comments

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

[Infotokev]

Far and away superior to any other Excel training on YouTube. Thank you. God Save the Queen

[Aggiemayson]

This tutorial series has been an incredibly useful tool in learning how to develop macros in excel. For the folks also using this tutorial, I would look into using named ranges in place of ambiguous cells referenced in order to aid with the readability of the macros.
when I was using the finished document as a resource to create my own one, I had to pick through a ton of things to figure out what "Row Store" meant from the engine sheet, and what manipulated that cell's value within the macro.

[sozuki]

The best Excel VBA tutorials ever thank you so much

[jeffreywatkin]

These videos are fantastic. Thank you so much!

[daviddevoe]

Very good instruction. Wish you had taught my calculus class many years ago. Detailed not without the dirge. Good job!

[r.a.]

Thank you so much for this series. Extremely legible and end product possible, many thanks !

[samehsayed]

I admire that Although you are an Excel Instructor, Still using the old way of Pen and Paper
Aside from that, Really great videos

[sagaloo]

I have a reasonable working knowledge of Excel for Data Analysis, but these tutorials are just excellent

[billmurphy]

Excellent tutorials! Great pace and very thorough. One suggestion, I very rarely recommend using default values as it leaves you questioning whether the user entered a value or mistakenly skipped over the field.

[shuklasunil]

This is a superb tutorial. I have gone through many but a detailed explanation step by step s so helpful.. Thanks a lot

[metalpower]

This reminds me of the simple Windows apps I used to create using Visual Basic, excellent courses!

[oslcparksville]

Fantastic series! Do you have a video on how to add a picture to the User form ? Thanks

[Ghostride-X]

I need this tutorial
I never thought I can use EXCEL this way to speed up my data entry
I can't wait to try this on my Inventory Database for construction supplies I am already using over 10, 000 rows

[jeffbooth]

Thanks for making these great friendly and easy to follow videos. I’m really new to VBA forms. I have two drop down boxes in my form one for date and one for time. The date is showing as text and time as a decimal. Have you got a video to explain how to make them show true time. Also I would like the date to be prefilled with current date. Any assistance or advice is greatly appreciated.

[RyanAnanda]

Hi huge fan of your beginner's tutorial and I have been using your video every time I create a data entry form! I have a question and I am hoping it is an easy one to solve. I noticed how my combobox has values in it already and as I am clicking down the lists I've entered, once I reach the last one on the list, instead of me unable to go further down and stays on the last option, it goes down to the next textbox or combobox below it. Can you help me with this? Thank you!

[flyusa]

Thank you for such a cool tutorial series. Well done!

Quick question, I created my form quickly following your simple instructions, however, my project has many fields for number values and they are all entered now in the database as “text”. This is the same with the “Age” field on your form that I downloaded; it looks like I may have to reset certain default settings. How do I change this, or, how can I recode this somehow?

Thank you.

[mezianeremila]

Hi Chris, I'm facing an issue when tabbing through the form, instead of tabbing in a circular pattern starting off with tab 1 ending up with tab 10 and starting again with tab 1, it behaves in a reversed pattern when tabbing from TAB 10 it moves back into TAB 9, how can I fix this?

[timhighett]

Hi, whenever I insert a number in a textbox as you've shown for "Age", the sheet states that an error has occurred (Number stored as text). How do I fix this? I've tried dim as integer but no avail

[sk-cexw]

Sorry! I Create all the spreadsheets correctly including this but when today i open the form sheet the macro is disabled.Please tell me i find this type of response what should i do to save it.

[kemdust]

How can aI add a datepicker in a UserForm?