Excel VBA Introduction Part 21 - User Forms

By Andrew Gould

[vineetat]

You are The Best Tutor. I have no word to tell you how your video helped me learning VBA.

[superiorhomeimprove]

Andrew, You're not a good teacher ...
You're a great teacher !
 Its so rare to find something this complex, explained so simply. thank you very much!

[MinhPhan-nmdk]

Dear Andrew,
Once again, thank you so much for this great lesson and helpful tips.
Although video posted almost 8 years, but until now, its value is truly necessary for new learner.

[TheHellfiremissile]

you are a bloody legend man. The best Excel videos I have found anywhere (after much searching)
cheers to you and your loved ones

[shanibochumcc]

There is always science and arts to anything you do. You have simply mastered both of them without doubt. No words really!

[rustamtau]

this VBA course is of Legendary level, thanks to anyone who participated in creating it, to Andrew "the Teacher" Gould
in particular

[thomaswashington]

For Efficient Reference:


What You'll Learn 0:00:12
What are User Forms? 0:00:42
Creating a User Form 0:02:32
Modifying Properties of a From 0:03:33
Adding Controls to a Form 0:05:21
Running a User Form 0:09:15
Using Additional Controls 0:09:50
The Date and Time Picker Control 0:11:56
Spin Buttons 0:15:27
Combo Boxes 0:17:35
Aligning and Distributing Controls 0:20:25
Using Frames to Group Controls 0:21:55
Adding Code to a Form Event 0:23:36
Changing the Tab Order of Controls 0:29:28
Unloading a Form 0:32:06
Loading and Showing a Form 0:35:07
Linking a Textbok to a Spin Button 0:39:20
Locking and Disabling Controls 0:43:10
Linking a Spin Button to a Text Box 0:45:24
Validating a Single Text Box 0:46:23
Checking the Range of a Spin Button 0:49:55
Validating Multiple Controls 0:52:06
Validating a Combo Box 0:55:55
Validating a Date and Time Picker 0:57:48
Restricitng the Values in a Combo Box 1:02:14
A Summary 1:03:58

[ggg-soyr]

Hi Andrew,
I just wanted to join everyone else here and say how grateful I am for your tutorials. I've been watching these lessons since July of 2018, about 5 months now...I have an extremely busy work schedule, so unfortunately in 5 months I was only able to go through 21 lessons so far, but these lessons have helped me so much at work! I have implemented so many changes to my current department, based on your video tutorials. Because of your fantastic teaching skills, I will be finally getting my VP title at work! Again, thank you very much for all your effort!

[maurocastagnera]

Dear Andrew, I can not believe how you can know all these things of VBA. The hypotheses are two:
1) it's been a long time since you study this subject and have a lot of experience;
2) you're a genius!
I think the second is right! Thank you so much for these videos.

[geronimox]

Great. Crystal-clear and straightforward explanations. And the good impression you get the first time around can only improve when you watch it again, This is clearly a valuable resource in teaching the fundamentals of VBA. I would even go so far as to say that the more you advance in your knowledge of VBA, the more you appreciate the quality of this teaching method. Highly recommended. Don‘t deprive yourself of it!

[maurocastagnera]

Dear Andrew, I watch and watch again and again your videos at any time of the day and whenever I can and I never get tired of appreciating and admiring your great ability to teach so easily what would seem difficult to learn. You are truly exceptional! Sincere congratulations!

[badassack]

Your videos are just perfect. I went from knowing nothing to being able to read basic vba in a week. thank you, thank you, thank you. Look forward to many more videos from you. your a true professional.

[geronimox]

One of the best Vba course around. No question about it. Very well structured and always with a reassuring voice leaving no room for doubt that this can all be learned in due course! I haven‘t watched all of the videos yet but I certainly do intend to.

[mariusavo]

You are the man !!! Straight to the point with no extra bla, bla...

[peterhontaru]

I love how you started with error 1 of spin box values and gave 5 solutions and then 10 different solutions for each of the errors caused by each of those solutions and then another solution of a solution of a solution. Ok, exaggerating but you get the point. Thank you very much!!!

[luismorana]

Andrew,
You did it again. Excellent. Thank you. I finally understood how to start with UserForm in VBA. Hope you do not stop here!!
You are definitely gifted to convey this subject to your audience and I encourage you to pursue this skill. It is not easy to find professionals like you.
I ( and many of your followers) really appreciate your time.
Cheers.

[Vlekka]

As others have said, these are definitely the best source for excel in my opinion! Thank you so much for the time you have taken to do these videos!

[EOO-Stand]

I have learned so much watching your videos in just a short time. I tried other teachers on youtube but found yours to the best, easy to understand, very practical. I started from part 1 and now I am in part 21. I had to stop just to give a comment. can't wait for my next project. Great work!

[dogustinas]

greatest vba serie ever, undisputed! thanks a lot

[maurocastagnera]

Dear Andrew, you're just a genius! No other words are needed!