Excel 2010 VBA Tutorial 55 - ActiveX Controls - Text Box

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

---

Closed Caption:

I don't worry i walked into my 55th vba
2010 tutorial and this tutorial is going
to show you how to use text boxes on
your worksheets so again we need to go
into design mode and I'm just going to
drag the submit button down here and
then go to insert and then we want to go
down to this box down here which is text
box was the lady on it click that and
highlight across like this and that's
going to give us a text box when we come
out design mode the user can type in
just like this and we go back into
design mode and click on this i go into
our properties
first we're going to do is just change
your font size up so bold 14 and and
that's going to be that and what you can
also do so you can have a lynx also
viper in a reference to someone here so
she warned a one and then that's our
that box then is going to be equal to
whatever's in a world so we put
something in a1 it changes every change
something in here then a1 changes so
that could be quite useful but we're
going to do this now I'm going to show
you how to take the value of this out
into your cage so in design mode this
give this a thing bad about so put
username the school text box and then
that's copy that and then on a submit
button and arcade in here discovered of
this and then all i want to do is create
a variable say in using name strength
then username equals and I want this
work but sheets she want
. and then we want the name of art xbox
and then thought body
well that's going to do is it's going to
look at our workbook and then our sheet
and then within that sheep we take the
text box and then the body make sure
when naming your textbooks is the
donated the same as any sheets or as the
work but because then you can get saving
violations and you can use all your work
which is a massive pain in your ass and
it's happened to me a few times before
when I haven't noticed I've called the
same thing so just make sure you don't
get any violations like that
let's just make a message box that says
hello
username your request
well now we process so that's closest
town come out of design mode so that's
put in our name here so my sound and
then submit and how that sounds
your request cannot be processed so that
is how you use a xbox that's going to be
it for this tutorial and the next
tutorial I'll show you how you can
create a box we have a drop down in it
so in fact with that are no to catch you
see