Excel 2010 VBA Tutorial 54 - ActiveX Controls - Command Button

How to use Active X Controls to add buttons to your worksheets that run macros.
Website and Forum: http://yourprogrammingnetwork.co.uk - Please direct any questions you have here.

---

Closed Caption:

how everybody are working to my 54 BB
85,000 tutorial and this tutorial is
going to show you how to use the activex
controls in your workbooks and activex
control is essentially the same as user
forum accepts its going to integrate
itself onto your worksheet rather than
being a separate form that pops up this
has quite a few advantages the main
being the user forms when they loaded up
we'll lock down your entire instance of
Exile so unless you open up a new
instance you can actually look any of
your workbooks activex controls would
ever had because they're embedded into
the worksheet you can get to her sheets
you can eat gate / web books and it
doesn't cause any other problems and the
second advantage is just that they look
at another batter looks more like you
going integrated spreadsheet rather than
it being a separately or use for mopping
up so let's get started the first thing
you need to do is make sure you've got
this developer rip tab on the ribbon up
here we have a good at then write
correct and go to customize the ribbon
and then just make sure you got the
development thing takes here now with
that before we can start adding activex
controls on to our worksheet it's going
to design made well this does is it
stops it from actually running any cage
and just lets us build it up and then we
come out design mode we can run it then
next thing you want to use this insert
symbol this is where all our activex
controls are so if you go on this and
then go down to you after activex
controls and they use the form controls
they're not that useful just use the
activex ones first thing I'm going to do
is I'm going to have a buttered and drop
by it and then we can shape it and
resize it the same as if it was a text
box and and we can right click on it and
go to properties and then you notice
that you've got all the same properties
that you have normally in your editor
that's for the userform
so we can change our back color we can
change our four color we can change our
form and so on and so forth
if we want to change what the command
button says the goods captured and
change the captured say but South once
one saying subjects and so then if we
double-click this and it's going to come
up into arcade for the worksheet and
it's gonna appear have command but one
selected here have clicks let's it's so
when and if it in this sub commander but
modern school clique it's going to run
whenever we click that buttered so let's
just put something simple and hearsay
message box
I don't know worlds and then cruised on
this then if you try and click on it in
design mode is just going to let you
click it and select it will come out of
design moved by own clicking up here and
now when we click on this submit
buttered it's going to say hello world
and you can put as much code in here as
you like or you can call another sub so
if we put another sub down here so sub
my separate routes goes and then here
messagebox world's forearm another sub
and then we click on in here to help
design mode internet and it's not going
to work because we haven't called a sub
procedure and that's a cool my separate
code and now when we actually click on
it
it's going to let say hello world from
another sub so that is the start as of
Howie's activex controls in the
community to tori's i'll show you three
different types and how you use them so
that's it for the streets are real fight
thanks first in and catch you in the
next tutorial