Excel VBA USERFORMS #25 Date Picker Calendar revealed! Loop through Userforms and Controls Example

**Limited Offer** Learn to Make Excel Do Your Work For You with The Ultimate Excel Programmer Course – Get the Full 9+ Hour Premium Course for 75% off using coupon code: https://www.udemy.com/ultimate-excel-programmer/?couponCode=2016YOUTUBE75 Click Now to Order and get Lifetime Access to Course, Workbooks, Updates and Support!
------------------------
Create Your Own Barcode Lookup System Using Excel VBA. Learn to Make Your Own Barcode Labels the Easy way and have fun with Barcode Scanners to Automate your Workflow! In this project-driven Course, you’ll learn to Build your own Custom Inventory System with Step-By-Step video instructions. This goes in depth into some advanced Userform strategies that you can use for your other projects to come. A great weekend study! YouTube Subscibers only pay one forth! Get your 75% off Coupon here: https://www.udemy.com/barcodes-excelvba/?couponCode=2016YOUTUBE75
------------------------
Too busy to Learn Piano? Use my Secrets and Play Your Favorite Songs Today! Did you know; You can learn 4 basic chords in about 5 minutes and instantly be able to play millions of songs. Seriously, check this course out. 75% off for my YouTube Friends! Click here: https://www.udemy.com/play-piano-by-ear-today-supercourse/?couponCode=2016YOUTUBE75

For Articles, Updates and to Contact me for Consulting or just to drop me a line, please visit http://www.ExcelVbaIsFun.com

Here is my link to download my FREE workbooks, past present and future: https://www.dropbox.com/sh/nwc5trm2xwlvvbh/XpGTrmKVyQ

------------------------
Playlists:
Excel Vba Basics http://www.youtube.com/watch?v=AIhKNNXzZLM&list=PLw8O1w0Hv2ztGjIkrW7suD6oNDaOk3vbR&index=1
Tips N Tricks https://www.youtube.com/playlist?list=PLw8O1w0Hv2zsPU-k2vPZ_6brD5Gk1sVy_
Userforms https://www.youtube.com/playlist?list=PLw8O1w0Hv2zvnLFyiMrihcaOqA0sT0X2U
Sample Excel Programs https://www.youtube.com/playlist?list=PLw8O1w0Hv2zuP-BE7tV1UjWa0ZexZqY89
Events Series https://www.youtube.com/playlist?list=PLw8O1w0Hv2zvf-YaBApsIHloI9G6Cq1Wh
Activex Controls https://www.youtube.com/playlist?list=PLw8O1w0Hv2zupzNIWkZCOYYngTtMH5nSf
------------------------

Grab an Excel Nerd T-Shirt or Hoodie:
http://ExcelVbaIsFun.spreadshirt.com/

------------------------
Interact and Follow me on:
LinkedIn: http://www.linkedin.com/in/danielcstrong
Facebook: https://www.facebook.com/Excelvbaisfun/
Twitter: https://twitter.com/ExcelVbaIsFun
Google Plus+: http://www.google.com/+ExcelVbaIsFun


'Royalty Free Music by http://audiomicro.com/royalty-free-music'

---

Closed Caption:

everybody stand strong with excel vba is
fun today I want to talk a little bit
more in depth on how we created the
datepicker so i could there and this is
the date picker you can see here I
haven't blank these out yet as I wanted
you to see what happened whenever I
click on this particular button it says
TB s T date there's a little label down
here that normally would be hit but i
want to show you the inner inner
workings of how this works that TB st
day is the name of this text box that I
want to effect in just a second and the
userform to is the name of this user
forum that I want to effect a userform
too . tbst day so that's basically what
i want to show you on and we'll show you
how it works now I'm going to kind of go
over how it was built and hit alt f 11
there's two user forms the first one is
called Cal it's a calendar here and you
can scrunch it up to the very edge if
you like so that people can't see that
or you can just hover over these two
labels and make them invisible by taking
the visibility and double-clicking and
making a false so they wouldn't show up
anyway what I've done here is let's
start with the userform to that's the
one where we want the dates to go into
so I took a pretty little picture that I
got here by clicking on picture and
clicking this button browse for a nice
little picture of a calendar
but that's a whole nother video take a
little button here so the first button
is called to a button st day to Cal I
just named that so if you double-click
on that the user forum called CL that's
what this one right here so the first
label it ends up being we tell it to
become TV end date and a userform too
let's see here that was no sorry the
first one is the start date and the the
other button this one right here tells
it to to make TBN date and then says
calendar . show so show this user form
right here now how do we get this date
picker thing in there did I designed
from scratch
no I thought about it and that i found
out you can do it yourself i'm gonna
show you how using this tool box
normally you don't have this month view
thing going on here but you can
right-click and click on additional
controls ok and I'm going to scroll down
and show you where this one is there it
is
microsoft month view control 6 . oh so
hopefully you have that one but dig for
it for a second is under microsoft month
view control and hit OK and now will add
that little button to your thing to your
toolbox so click on that and I guess you
can maybe resize that i'm not sure i
wouldn't know okay you can't it's always
going to be that size but with that what
you can do is you can double-click on it
oops so double click on it
and you have is called month view 1 by
default i think i named mine something
else you have a date click that's when
they click on a date a date double click
or just a double click anywhere on there
and enter and get a bold all kinds of
things that you can mess around with
with that I'm going to take that one off
and show you what i did with mine so I'm
going to leave this one here so I named
this one F Cal so double-click on there
so i did a loop here for each user forum
in vba . user forms
okay see that we're looking through if
you use if UF . name so if the current
user for more looping through . star .
name is the calendars forms label UF so
that would be this label right here that
has a thank-you says userform to
whenever we click on that one button
going back here
if the user forums name is the same as
that tech the little label there then
we've got a match
we're going to go to the next loop here
for each control in that particular user
forum . controls so if the CTF the
controls . name is and again here's
another label that we laid out if the
controls name is the same as the label
which is you know TBH start date or
something like that so if those match
then that controls value equals whatever
date they clicked to date click is the
default thing that you can variables
built-in so let's let's a loop through
that really quickly and that should
clear everything up but anyway if you
want to
oops you wanna mess around with this i
do have it available on my shared
dropbox link it's at that it's in the
description of this video so please
check it out but we're going to go and
show you how it works first so you can
apply that to your user forms and your
tools and things like this so i'm going
to double-click you know i hit the green
button here so once i click on this it's
going and when i click on a date here
it's going to run our mattress less use
june fourth 2013
I click there and it stops me right
there for each user forum and vba .
userform so the first one if user forum
. name equals use the form to apparently
it was so for each control in uniform
too . controls basically so the first
control is called start date
the control . name let's do the control
that name if that is TB st date it's not
so we'll go to the next control next one
. name is TVs start date or whatever so
the control . value let's take a look at
let's take a peek
so that is this control right here that
we are locked onto using the loop is now
going to be date click which is june
fourth so hit that and now me . hide
will take their current form which is
this one here and hide it and then
you're good
actually we could be real clever and say
go to ending or rx-7 is just to exit sub
whenever it whenever says me . hide the
next thing that will do is X the sub you
don't have to endure any more of that
loop so and then we click on this one
same deal here dead couldn't see the
label for the other for the calendar
thing is going to be TB end date so it
will note a reference that and uniforms
going to still be used for him to show
the calendar click on this date so found
these reform right off the bat for each
control
first one must be that label next one is
probably it is TB and date i know it is
it and there's the next level and he was
probably the userform now 123 and now or
for or is it was a button to their now
we found it finally found the text box
called TV and date and now that controls
that value is date clicked is pretty
dynamic and exit the sub-band it works
so that's how I rigged up the calendars
to do their thing
and hopefully that will help some people
yeah it's pretty cool I you can click to
the next month really fast if you click
here on the year and you can go up and
down the ears like this and if you click
on the month you can select what every
month you want it's very cool it's built
by the brilliant people at Microsoft so
I mean it actually is very cool it's
very helpful so check that out
I hope you enjoyed this tutorial if you
have questions please punch your
questions down in the comments section
be happy to help please click like if
you liked this video click Subscribe if
you want to see more cool stuff
otherwise you guys have a great day and
god bless bye