Excel VBA USERFORMS #1 Make Userform, Add a Button, Button Click Hides Form

Create a simple Userform, Add a Button which hides the form. Simple. Come learn how you can do this EASILY!

**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-... 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-excelv...
------------------------
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-e...

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/nwc5trm2xw...

------------------------
Playlists:
Excel Vba Basics http://www.youtube.com/watch?v=AIhKNN...
Tips N Tricks https://www.youtube.com/playlist?list...
Userforms https://www.youtube.com/playlist?list...
Sample Excel Programs https://www.youtube.com/playlist?list...
Events Series https://www.youtube.com/playlist?list...
Activex Controls https://www.youtube.com/playlist?list...
------------------------

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-mu...

---

Closed Caption:

hey there YouTube is day no strong with
excel vba is fun this lesson we're
finally getting around to doing some
custom user forms this is going to be
exciting but it's going to be quite an
undertaking I mean there's there's just
a billion and one different things you
can do with the userform so I'm going to
need some input
go ahead and write your comments down
below this video and just tell me what
you're wanting to accomplish and that'll
help me out a lot in kind of fixing up
some scenarios as to what would be
useful to you guys in your actual
day-to-day lives or at your work
whatever give me some examples of what
you do with them because I know what I
do at my job with them and doing reports
running exports and imports and all
kinds of crazy fun things like that
opening files setting file locations but
you know I want to know what up what you
guys are thinking so anyway let's get to
our objectives number one we're going to
make a userform real easy number to
we're going to make a button on our user
forum which is super easy
we're going to hide the userform on the
button is pressed also extremely easy
we're going to started all 11 to get our
visual basics menu up our editor up here
where they have userform one here and we
have seen one of our earlier videos
we're gonna make a new one click here
and click on user for and so there's our
new one it's automatically called
userform to but i believe we hit for
that will bring up our properties menu
and we'll give it a custom name here
let's call it hide form and call it
anything you want I'll call it tied for
because our objective right now it's
just hide it so objective one that was
super easy right what about this little
things as user forum to let's get rid of
that right off the bat that's our
caption let's just say click the button
to hide ! and us as a type even just say
that up here also you may have noted
when i click anywhere on the userform
and brought up the toolbox if you don't
see it go to view click on toolbox and
there's your toolbox it's pretty and
it's got all the things that we've seen
an activex controls and a little bit
more so let's go ahead and add a button
that's right here command button and I
could single click and it would
automatically give me this custom size
or I could have dragged it let's go
ahead and click here you can see that i
can click and start typing the caption
of the button and it will follow as i
start typing click to hide and then you
see the captions following along the
button make the button a little bigger
since our user forum is all about this
button and act let's make the back color
make the back color red
click guide make the font a little
bigger and bolder clicking here on the
font bold let's make its 14 click hide
am right now our last objective as you
can see here is to hide the userform of
the buttons pressed well we haven't
activated the userform we can do that we
can run a quick test on this user form
by clicking the Run sub userform hitting
f5 there's your user form right here
floating around on the page and you
could be us you can't click anywhere on
the worksheet you can't hear what I'm
hearing but it's going to do
ringing ding all right can't click
anywhere there's a way to fix that but
they only think if i click this button
it doesn't do anything if i click this
it will close the userform I won't keep
my place if I had if I had a place this
is such a simple user forum but I click
out of here let's double-click on our
button here that will click whoops
whoops double click ok so there's a
commandbutton 1-click actually I take
that back
let's go to hide form let's give this
button the name will call it BTW in BTN
hide
ok i like to label everything because
later when i'm looking at code now
referring to these things i wanted to be
super easy for me to remember
double-click on that now you see the
button hide understood or click is the
event that we're doing now so it reveals
the actual control the button number
using when we click it what do we want
to do we want to take Hyde form that's
the name of our user forum hide format .
hide
ok that's the command yeah whatever your
user forms name is . hide and that will
hide it will keep whatever its current
status is if you had something selected
from a selection menu or whatever it
would keep that rather than clicking the
X or on the loading the userform we're
just going to hide it
ok so let's go ahead and hit the f5
button to run our user forum and if we
click this button it will run that code
and it's hidden it all right it's pretty
much it's real simple
thanks for watching