8 hours 33 minutes
in this exercise,
I'm going to show you how to make your own quiz or test in Excel using my crows and how to make it completely looking like a professional piece of software asking the questions.
So, um, let me first guide you through the experience, and then I'll going to explain to you how
the whole thing is working.
So we have two buttons on the first sheet.
And actually, if a student would open this these two sheets down here, worksheets, answers and questions would be hidden
like I showed you before. So you know how to do it using the
the variable that puts, you know, the XL one that
or hides the sheet completely.
So we're not going to do that because we need these sheets to explain to you how this works. This is just one of the ways to do it, but it's the simplest one.
So first of all, you click on the intern, your name, and this is the instruction that students get. So each one of them has to sit in this file and they type their name. So ask said, okay, and this is it. So I'm just entering my name.
And now the step two is to start the test.
And this displays
You get the
and you get to choose one of these three
so it can you can choose just one.
And the space here is open so that the question can be longer. And also, these answers can be much longer if needed. So the full line. So something about 30 40 characters. You can also play with the size of the font and everything.
But this is it so
and then you click, submit, answer.
And then another one appears. So these air trivia questions not to really test,
you just answered them.
You cycle through all of them.
What you see here is that this is appearing on my second display. So I'm
just changing. Moving gets around. And so this is it.
Emily is done. It's finished. So we could have placed the message
that's finished. Save the file. Go home. Whatever.
And we can do that later.
And if you see here in the sheet answers, there is my name. And there is a number off books I have selected to. Ah,
So it was like first box, second box, third book. So this is too. This is tree. This is one. Just do this history.
Now I have
in third sheet in questions all these questions
and I also have,
And here I have the correct ones.
these numbers here
they're used for models to communicate between themselves and some other stuff. So we can simply hide these rose so that the teacher don't accidentally
click on them and change something in the way they shouldn't
our delete them of which could generate the problem for microbes to work.
But in general, this is the function. So we also have some control boxes here, and we can hide them, for example. But I will leave them just when I while I'm running through codes so you can see that perfectly nice.
And you understand what I'm talking about. So, um
Okay, so let's ah, let's go to the visual basic
and let's move it here. Let's reduce the size so we can look at the code and
the file at the same time.
So, first of all, we have user form
and you could look and you can look at this year's of form. So an editor, this is how it's done.
And I'll show you how to do these things on another form.
So this is how it looks. So let's ah, let's make something that looks exactly or almost exactly this. We go insert,
we go to use their form,
and then we get another window. So we just first resize this
and you see relieve these open and now we have toolbox.
So first of all, we select label. So this where the question is going to be is called label
and we put their label here, and later we're going to change the text of discs this label through macro.
Then we put three
Option button, one
option button, too,
and option but three.
we click and put this submit? So command button
and this is it.
Now we can click on these three buttons here
and for example, look, att Ah, there with and let's make it the same. So it's put it like 380.
So they're all here,
and it's also very important thing. We group them together.
So we've put group, for example answers
they're now grouped, which means that
they are old, um,
So when you have seen how it works, when I click on the one button, the other automatically gets be selected.
So when I click unjust if one of these buttons here have this left. Okay, so the height is not the same, but the way it is, So I can now adjust the height
more with a little bit around It took me some time to fit them together. To be
exactly precise is they should be. But this is it.
And this is our form.
And we're not going to save this one just not to mess with this file because you're
having that filing. Your resource is Deb.
Uh, but this is pretty much it and be just
Andi. Eso user form to I'm going to remove your user from Do they want to export? No, I'm not. So this is it. So I have ah, you see, in the form I if I selected, I have also changed the color off the background and I changed the color
off these buttons. So
this is background color so you can paint it with every want. The same thing is with this one. So, for example,
I can I can change this to take your palate and I can make it something like this. But I'm not. So
let me just
we won't save it. So this is it. So this is form
and this is the code behind it
And their two subs 1st 1
is this is the first and most important one.
This is ah,
user form initialized.
And you see that I don't have here. User form one initialized. Now this is user form initialize. This is macro that execute when you opened this form, when you call it from some other
17 or or function
and I'm basically the mentioning roll numbers, integer and row number is and look at this sheets Question cells 11
So this is it,
uh, at the beginning, the software that the other macro will reset this to two. And this is basically telling this form where to look for
the question, the possible answers. So this is it
and leads back to it, and then we have the whole initialization procedure. So we would say, use their form captured.
And this is important. You see here when you click it
to use a form look and we get captured its user form one. So it's not changed its ah, generic one.
I will put in that caption. So, user for one, that caption this is evoking this cell here.
The caption still
and I say it is
questions with space and
row number minus one. Why? Because I'm starting with drone number two. And actually, that is the first question.
So you have seen in the form it was question one.
And then I have label
which is this This is label one, do you see?
And it's kept Shin is
that sells row number, comma one and then value.
And this is Rome. Number one A room number two, because it's on in initially is going to be too
same thing happens with
option bash in buttons captions. So she's question sells rule number, the same neural number and then 234 and they're closing this up. And we're going to continue with the explanation off all these crows in the next