Clear Survey Button - Functional Checklist Survey in Microsoft Word 2010 (part 8 of 9)

This video shows how to code the Clear Survey Button for the Checkboxes in 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:

okay now this video I'm going to show
how we can add some coding
into the clear survey but in that way
all the show by civic cleared out
and automatically the label will be
updated with an with another function
I'll be called
once the labels one sees check boxes are
are cleared out so what we're gonna do
go to your developers tab and select
design mode
go on and double-click the clear survey
but in
the very first thing we want to do is
prompt the user
and in programming what you're going to
do is you want to know what the user
inputs whether the click Yes or No sorry
to do that yet to find assign it like a
a variable so we have question thick
clear
equals and do a message box by doing MSG
Boix
and then do I'm your open for the Seas
double quote
history tell you there are you sure you
want to clear
the survey still few spaces
do a double quote and they do a common
the ones that we're gonna use
is your with this option that comes up
the palace says you're gonna go on a
select
BB Yes No and hit the tab but in
and we're gonna do the icon the BB
question icon
that should be someone here BB question
and then now this part
as you can see in this option if the
title swords in
question and all
what this portion is gonna do so far if
we were just hit the command but in
right now
in production mode gonna give us this
message box are you sure you want to
create the survey
yes or no nothing's gonna happen by let
me show you what we're gonna do now
Mike prospectus I know double click the
Clear survey but in
question clear
if this Valley right here if the user
cyclic
yes Visual Basic in the programming
environment
returns the number six
and I guess it's a show you gonna do
this part
message box question clear am gonna play
the same code
my head yes
we get a6 if I had known
we got a seven so that way we know what
to use our pics
so this organ it to you if question
clear
equals 7 which is no
then exit sub all this means is that
we won't do anything because the user
click No
but
if question clear equal sixth
then they were doing and if so we're
gonna put code in here
which means all is clear that we put in
here will be executed because the user
click Yes
and the colour we're gonna put in here
is clearing out all these checkboxes
which is going to use the code that we
in a way the code credit earlier but I'm
gonna copy it
so I'm gonna do
q1 a that value equals false
ima do the same for all check boxes for
key for Question one
eight-b_ CDN Eve as false
this is all for Question one we do the
same for question two
so for here I'm a change the one to a2
and then the same thing
for Question three so all this is doing
s setting up to false which means there
they won't be checked
question one option ABCD any sandifer
question to
ABCD any and question 3 abcd&e
so now let me say how this is gonna work
takes a design mode which an hour into
production mode
I'm gonna for like three 3
and three by a clear survey almost like
no for clearing
nothing happens way clear surveyed and
hit yes
all the checkboxes have been erase
including that that that
that the reason I mean they've been
unchecked
so that concludes his personal other
video but I'm gonna briefly X
explain that we did do any to this label
yet
because all we're gonna do in the next
video is we're going to explain
and added the coating needed
in order to get this label to calculate
and the way that's going to work is at
any time
any checkbox is changed it automatically
calls
a procedure to calculate the code so
buyers
clicking clear survey and hitting I yes
because it makes chains such a popular
it's automatic an account
it's gonna do that calculating function
which will populate this field
as zeros or whatever value you have
selected up here
so hang in there we're almost done and
pretty soon you'll have a complete
customer satisfaction survey or
checklist