Excel VBA ActiveX Controls #1 Worksheet Button and Textbox

Using a Button and a Textbox directly on a worksheet to invoke some simple VBA code. In this lesson, we show the user how to access the Design mode in the Developer ribbon.
Design mode allow you to resize/reshape ActiveX items and right-click,Properties to edit properties.
We also give the button and textbox a custom name and watch how excel utilizes that name.

**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:

welcome back youtubers Daniel strong
with excel vba is fun
in this lesson we're finally getting it
started with these wonderful things
called for patrols activex controls what
are they
they've their buttons comboboxes
checkboxes option buttons text fields
pictures and you can click on and make
macros run
toggle buttons text boxes
scrollbars all kinds of good stuff so
we're going to get started immediately
today I think we'll just take a text box
and a button and we will use those two
in our lesson
so what's a text box
what how is it different from a cell
cells contain text
well a text box is hard to describe
i'm going to go ahead oops i'm going to
go ahead and click the insert button and
we might as well go into design mode
notice on the Developer tab going to
insert I like to typically use these
activex controls because you can
directly affect what happens when
they're clicked rather than having to
design a macro and then just run that
single solitary macro off of the form
controls snow and note all that the that
all these buttons here are somewhat
volatile
if you run a report sometimes they'll
they'll relocate or resize themselves on
the page
so that's why user forms are much more
recommended we will go ahead and go over
worksheet controls
anyways let's go ahead and place a text
box right about here you can size it any
way you like
what size is it about like that
ok so there's our first one it by
default it's called textbox1 if i create
another one to be called text box to you
can go into the name field multi name it
will call this one TB for text box and
then a capital letter
let's call this person person 1 enter
ok so now a TV person one is what this
is called now we're going to go to
insert and in the activex controls will
insert a command button
I want that but no it's a little big
resize it to about there and looks like
the fondest racked up quite a bit i'm
going to right click and go to
properties will see the properties menu
pops up
so the caption is what you may be seeing
right here
not the name but the caption so for
example who is that fun so big
let's change the font right here and
we'll change that to say size eight
wonderful that'll do it
maybe we need to make it even smaller
ok hello like I said some of these are
pretty volatile
so here's our button will will change it
to press here
all right
you'll notice when you double click on
either these example command will call
this command button set of command
button one will call foot BTW and button
press here
why not ok so if you click on them when
you're in design mode it will just allow
you to edit them in the properties
window or resize them we take design
mode off and you have an actual why is
it making those so large
oh I guess it's because i zoomed in i
need to make these little bigger
yes because i zoom in so much that's
okay zoom it i hold control and i use my
scroll wheel in and out
ok i'm zooming ok so this is actually
the right size
look TV person will call this button
press here
now let's get to the nitty-gritty
double-click on the press your button
notice it says private sub button press
your underscore click so that tells me
we're off the bat there's a lot of stuff
you can do you could make somebody a
double click on the button for it runs
the macro but by default that just
thinks you're going to click the button
so there's a sneak peek into what i'm
about to do what we're doing here let's
say that somebody clicks on one of the
names in our dudes list
let's say they click on Dan that's a
good name here so double click in here
again
how bout and you can say me . and that
does anything any button or macro or
whatever that's associated with me
me is in this case is the workbook this
workbook so me . t be a TV person one
that's our text box called person won't
die value equals how about whatever the
selection is so soon as I click this
button it's going to run this one liner
that says well you know whatever the
selection is
that's what I want the value of the text
box called TV person
let's try and take design mode off
so now you have a legitimate button
let's click on this and Joe about Sally
who
cool go back to design mode is for kicks
let's say this equals the word
Scotty ampersand and whatever the
selection is so let's try that
whoops design them off press here is
here is here
Scotty Joe it's open that up a little
bit helps
Scotty Scotty Joe
Scotty dan and if we want to put a space
there you can obviously put a space
marker there Scotty space and Joe or
selection whatever selection is Scotty
space
Sally Scotty space chest Bob
so that's our first lesson and just note
that whenever you are in design mode
when you click here or here you can
access the properties by right clicking
and going to properties and there's a
lot of properties and you should check
those out mess around with them
thanks for watching