Entering the VB Code for the Checkboxes - Checklist Survey in Microsoft Word 2010 (part 6 of 9)

This video shows the Entering the VB Code for the Checkboxes. Microsoft Word 2010. Word Document is built using Visual Basic Editor and is saved as a Macro Enabled Document (.docm). VBA ActiveX Controls Used: Checkbox, Label, Commandbutton. Survey has checkbox options for a customer satisfaction survey checklist. Commandbutton allows user to clear the survey and all data is auto-calculated.

---

Closed Caption:

a large one now that you have your form
set up with all the activex controls
checkboxes at it the next part is to
begin coding now I'm gonna go to my
developers tab take myself out of design
mode which pretty much this means we're
in production mode which is the mode
that the form will open up when your
user opens up the form so right now
without doing any kind of coating
nothing on this forum is functional we
can check mark 1 2 3 4 and 5 all-fiber
checkmark know kind of statistics are
being calculated and of course it's not
what we want we want to be functional
so that's where we were going to do some
coding now the very first thing that I'm
going to show you in this video is how
we can set up the check boxes so that if
you're select option three your user
won't be able to select option 5 and
then three at three remain active so let
me show you how to do that on your
developers tab select design mode so now
we'll be able to to click the one two
three four and five
go ahead and double-click the one the
moment you double-click your first check
box is going to pull you into the visual
basic environment and what is the same
is private sub and this is its question
1 a which is the what we named this what
we named this control-click so any code
that we put here is what will be
executed when your user clicks on the
screen so just show you really quick
this is just a little message box you
click check box 1 i'm gonna take us out
of design mode toggling back to
microsoft word if I check if i click one
we get that message box you click check
box one if I'm to uncheck market is
still going to say you clay checkbox one
because all the procedure is saying is
that if the user clicks this option that
message box is going to come up some
push back into design mode and we're
going to put the code that we really
want
so what we want to do is if the user
selects question 1a this is we're going
to do an if statement and you don't need
to have a a crystal clear understanding
of if statements is a pretty basic if
statement
we're not doing anything complicated
here and again you're going to see the
code on my screen so we're going to put
if q1 a that value equals true which
means that when the user picks it if it
now has a checkmark then the value is
going to be true then and what we're
going to do is going to end if so any
code that i put in here is what's going
to occur if the user clicks question 1
and the value is true meaning meaning
that it's check marked and so we're
going to want to do in this case is what
we want to set 2 3 4 and 5 to false or
unchecked so we're going to do q1 be
that value equals false and what I'm
gonna do is I'm just going to copy this
i'm going to paste it so that way all i
have to do is change q1 b c d and e so
I'm gonna kinda just recap again what
this is doing if the user is to click on
question one option A which is the one
that we have set right here and the you
and we determined that the value is
checked or true then it's going to do bc
dnes false meaning it's going to uncheck
mark them so i'm going to close this out
take us out of design motor show you
what this does if I'm to select right
now nothing's going to happen or we
don't see anything happened but if I
also select two three four and five
which again these they should be q1 b c
d and e and now I i select the first
check box all those are blacked out
I'm going to go on and select two three
four and five again and this time I'm
gonna check mark
cue the first option q1 a as you see
nothing will happen because the user
clicked it and it's it's not seen that
the value as being true so it doesn't
pay attention to any of these but i'm
going to show you how we're going to
correct that and make this all better
that way we the user can only select one
option so i'm going to put us back into
design mode
well we just did for this checkbox we're
going to have to do for two three four
and five but of course we're going to
have to change some values around so
first i'm going to copy this and i'm
always going to copy the if statement
i'm not going to copy the private sub q1
a click or the end sub I'm specifically
going from the beginning of the if
statement down to the end if i'm going
to copy that
now what I'm going to do is I'm gonna go
to the two and again I have myself in
design mode i'm going to double-click
the two so now i'm in q1 be click i'm
going to paste the statement that i have
and we're going to change the value now
it's going to be we have q1 be so it's
going to be if q1 be that value equals
true then what you're going to do is set
all the other activex controls to
falsetto a question one with the
exception of be so we're going to do a C
D and E and we're going to repeat that
process for the next activex control
three and here I'm going to speed this
up but all I'm doing here again is if
question one option C is true
select set all the other checkboxes to
false which is a BD + e do the same
thing for four
ABC and he will be false and then option
5 i'm an option in question 1 e if
that's true then a b c and d will be
false
let's go on and test this out i'm saying
is how to design mode if i select option
one right now it's going to set its
going to be true
everything else is going to be set to
false i select to everything else set to
false if i select three and three is
true all the other ones are set as false
if i select for all the other ones have
been set to false and if i select five
all the all the men protect falls so all
that is set and that's all just for
question 1
ABCD and eat question 2 still has no
kind of functionality so that's going to
be the next thing that we're going to do
but in this video take the time to
really look at what you're doing for
question one for all five checkboxes
ABCD any in the next video I'm just
going to quickly go through adding the
coding for the next two questions which
is pretty much going to be doing the
same the same process but we're going to
it's going to be questioned to ABCD and
E and question 3
ABCD and E thank you for watching guys