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

[samuelparadis]

Finally an excel vba tutorial that explains the relation between the functions. Ive hit so many that will tell you where to put each fucntion without explaining how they work together. THANK YOU !!

[toma_coffin]

Wow - my spreadsheets now have a professional look in only 6 lessons. So impressed !!

[stephenhammond]

Not boring. Error detection and data validation are two of the most important things to spend time on. Making sure all fields contain appropriate data (only numbers in number fields, etc.) saves a lot of headaches down the road.

[nahromusa]

You are the best teacher I have ever seen... Thank you with all my heart.

[jk]

Thank you!! Keep these coming. We really do get great use out of them.

[sofiiaa.y]

Not boring at all! Very useful thank you

[mariyatsvetanova]

It was not boring at all but interesting, usefull, magical. Thank you Chris, again!

[Nigromancy]

definitely appreciate this, not boring at all ! :)

[mofojackson]

Nope! Never boring! I love your vids haha!

[stephenhammond]

Question. For your message box confirming that the name had been added, would it not be better to pick up the name from the spreadsheet, rather than the input form? If you take it from the input form, you would still see the message that the name had been added even if for some reason it wasn't. If you take the name from the spreadsheet you know it's really there.

[melitosaldanha]

This is good.. I've been able to build a userform

[pdmtford]

Mr. Tiger Spreadsheets Sir,

Great content and video teaching! I probably just missed it? Quick question? when data is added through a form in excel how does one get it to go straight to the point of insertion?

Respectfully, BTDFMS

[Alan_]

great series. I've watched everyone so far. Question, rather than alerting the user the name already exists (since there are some pretty common names) could you write code to add an ID number with each new row added, and use the ID to differentiate between same names? That way it'll allow duplicate names, but have an ID differentiating each name in the database. I think this will also help with data integrity. Users will often add phony data to bypass data integrity measures.

[bjrnchrstn]

Chris, these are great! Thank you very much for helping out!!

How do you get the new row number (Ref column) with a new entry? Didnt notice it explained in any previous video.

[rianmalapitan]

Hello,


Did I miss a video regarding data validation where you cannot leave anything blank or required fields to have a value?
Basically checks to make sure all the fields have values and gives an error message to user if fields are missing.



Thanks so much!

[xavierwharton]

I'm still going through the tutorial and so far the information has been very useful.

I'm applying this set up to an existing Excel stat log that will be added to my organization's SharePoint site. Should I or my users anticipate any errors running VBA/Macro-enabled Excel file on SharePoint.

I know that the "editing in the browser" is limited l, however if multiple users simultaneously opt to "edit in excel workbook" will the there be errors with the placement of the data entry? I hope this is clear. Thank you for all of your help.

[buhaytza]

Hi Chris,


Great channel, great tutorials! Thanks for taking the time to teach us, mere mortals :D


I just wanted to ask if there is any reason for which we could not define use the FullName variable as follows:


FullName = Txt_First & " " & Txt_Surname


and then use in :


Sheets("Data").Range("Data_Start").Offset(TargetRow, 3).Value =FullName


My other query is if we could use Arrays to insert the results of the userform across the whole row?




I understand that due to the process of building this (mainly for us to understand the steps and techniques) we have built it up but just wondering for future projects.


Thanks again!

[willemvandijk]

Hello, I Like the series very much. I leaned a lot of it.
Wen a entry contains a dot and it should be a comma. how can I change it automatically

[koleysouvik]

Hello Chris, this is really an excellent tutorial.
I stuck in the validity checking code. i.e. how to check validity using both fullname and age. Person with same name may exist but rarely with both same name and age!

[priosambodo]

Great content, brilliant presentation. Thanks. One question, how do we designate a number entry in the form recognized as number or date in the worksheet so we can use excel numerical operator (e.g. greater or less than, older than, etc) . Thanks.