Write a Macro and Add a Button (for Excel 2010 Windows)

Write a small macro in VBA and activate it using a button or a piece of clipart

---

Closed Caption:

let's look at creating this from a macro
by writing some code am also start
looking at the idea
controls sell for simple om
going to go to the developer tear and go
over to Visual Basic
let's open up the country this workbook
by cable clicking
and here's our code lingo all right now
I'm going to type action text
always like to have that and I'm going
to write a macro directly
cell to do that all-star the keywords to
and John going to write macro the train
see active cell Fred
so it's cool red cell and
the two open parentheses mean time
this is where parameters can go
are not going to have any parameters for
this one so I won't put anything in
there
when I push enter this system goes ahead
and gives me on the hence the matching
and sent to the cell
so other co for this seventeen goes
between San
an answer you know what I'm going to do
is set up put a little comment here
a banner comment which I like to do so
starting it with that
well in any case going to say with this
guy
against and the kid
cell red and
the other cited the banner you don't
have to use asterisks
its whatever you want just make
something that really shows up
now this is going to be simple and what
I wanna do
is refer to the active cell internet red
they just see how to know how to refer
to it
in the Visual Basic on for applications
object language cell because we'll have
to work she kept
she active in the cell active we can
start with the cell
and there's a special key word for that
the active cell
now we put a dot in this shows us all
the different properties at the active
cell
that we could potentially address for
their code now what
we need to do here is talk about the
interior and
what we want is color up the interior
and by the way instead actually typing I
could push
Tampa news I'm at completion to get one
at the
and now I am I want to set this to a
color
and where do that I is Phoebe red
okay shell now let's go back to excel
here
when I want to do is set up a button
to use to run my am macro
song go to the Insert menu in here the
different control center
available for forms will be using a lot
of the six times goes on
let's start with the butt some going to
insert a button right here
and on
this is the choosing the macro I just
got to associate with this time
push okay and now I don't wanna
it to say but we won I wanted to say
something meaningful
sound I just put bread
okay now let's try it sa selected cell
a push the button while turner et
and i cant from this all day
so that's how you doing now I am
let's try something
here if I can find that clip art
yes I'm going to search for something
rare include are
out confined
X trying illustrations
on guess it is unlikely looking for red
show I could be read careful okay
cell it's capping yes
and Tim going to pasted over here
she's pace
okay and I'm going to make it a little
smaller
Anna region and doing this is to show
you
bank now sees this as a button for my
neck while
so let's right click and
here is an option to assign a macro
us on the same macro to it okay
and now if I select is selling push the
sky
but also tournament alright