Excel 2010 VBA Tutorial 57 - ActiveX Controls - Spin Buttons

How to use Active X Controls to add Spin Buttons to your spreadsheets.
Website and Forum: http://yourprogrammingnetwork.co.uk - Please direct any questions you have here.

---

Closed Caption:

I don't everybody and welcome to my 57
BB 8520 tutorial in this tutorial is
going to show you how you spin buttons
so it's been button is just but as a
little up and down on it and as you
click it up but so value / no box up and
as you put it
press down and puts a value over
southtown very simple to use and very
effective and I quite like using them
because people who are very easily
impressed by them so if we go into
design mode to get and go to insert and
come down here to the spin button click
on this and then put it in wherever you
want it to be so you then go to their
available to us and if we go to
properties and we're going to one mix
out and we link ourselves of the so we
want to use once i get to the minute so
you see 8 c 8 and that's putting our
sheet in first so she warned ! c8 and
then come out design mode and then
whenever we click on up
it puts the summer value of our cell up
by one but we put it down put the value
of that self-doubt and you can have put
restrictions on it so if we go to hear
you can have a minimum maximum value so
as default it 0 to 100 i'm going to set
it as 0 to 500 i'm going to close this
down and then now we can go all the way
up
keep going keep going keep going keep
going and you'll notice that is actually
taking quite a while to get all the way
to 500 if we just keep patient you go
ahead and then get lazy and put its 455
manually as you can still talk over the
box and then you going
somebody has to 500 is going to stop and
so that's quite useful to have different
things on it if you do is there is going
really slowly then you can actually
change the delay so the moment the
layers fifth
if we put the delay in aswad and then
come up design mode and I get it
notice that now it's actually moving
along a lot faster and say that is how
he would speed up and slow it down it's
just change in that property value of
delay i'm gonna leave that one a tad I'm
now going to copy this so if it means i
can actually just copy and paste buttons
and we're going to show you this one so
this one is going to increase it by
amounts of odd this was going to
increase it by up by 16 minutes or hours
so if i go into my properties
okay too much small change down here the
moment of sets of 10 changes by one each
time i can put this is what everyone so
if i put it as 60 and then I'm coming
off of it come out of design made and I
want to press up its going to add 60
onto the length of this and the moment
is too sensitive say that's what are
they up a bit 50 and then do it again
and then what we can do it in Nice steps
of 60 and then we can add in the rest of
our lives that are you notice i tried to
put in more . five-minute gay and the
small change actually doesn't accept say
no . one or something like that so if
you want to have increments of your
point one then you need to go into
properties you need to link your cell to
a different cell so that's linked it to
f/8 and then a fate we have a valued and
then in here we go equals that value /
it's a tad so now we've done this dress
up on it
that one's going to go up by want that
was going to go up by your point one so
if you want to have a change that is a
whole number that's the only real way of
going
around it or you could also do you say
we have our months in here that I've
sneaky hidden in black
if we get them back out again and we
stick our above numbers down the side
then we can have vlookup and then these
two commerce to false and then remember
up to type your cookbooks equals the
start if you're unsure will be the
campus then if you look at my advanced
or intermediate excel tutorials thinners
for the formulas you need and now
false now we don't need a cup style and
12 and that's maybe so that they're
actually feel series and then we press
up and down in here is going to change
the month name because this sounds
change it to the different numbers and
that's looking up the month named
accordingly so that's how you can have
different text values and that and that
is how you would you spit buttons that's
gonna be it for this tutorial and the
next tutorial I'm going to show you how
to use a listbox so thanks for us then
and soon