I need help making an Excel Quiz

[ionaman]

Hi, I am trying to make a simple quiz using excel but I am not familia
with excel and not very good at programming.

What I need is the command 1 button to be changed to Calculate and fo
this to then Calculate what is on K9 of the second sheet, which is th
overall score.

The command 2 button needs to be called reset. I was wondering can thi
be used to restart the quiz so the current user won’t know what th
previous users answers were.

If anyone can help me with this I would really appreciate it

Attachment filename: book3.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=50953

 

[DNF Karran]

Should be what your after

Attachment filename: book3.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=50954

 

[ionaman]

Hi DNF Karran,
Thanks a million for your help. It is exactly what I wanted. I have on
more small thing I need. I was hoping to have a hint button to help th
user with any question when they got stuck. When somebody would pres
this hint button then a small text file would be on the screen for 3
seconds and then disappear again. For all the questions the hint butto
and text file would be the same. If you can help me with this it woul
be great. If not I appreciate what you have done for me already.
Regards,
Ionama

 

[DNF Karran]

Couple of ways of doing this-

1- have a hint button for each question that runs the code:

msgbox Sheets(2).range([Hint Location]).value

where [Hint Location] is the cell address of the hint on sheet 2.

or

2- Have one hint button that reads from a combobox the question numbe
and looks up the hint accordingly from a list, again using the msgbo
function

 

[ionaman]

The second way sounds like the way to go. Would it be possible for yo
to do it to the excel sheet that I uploaded already? Is it possibl
just to have the text appearing for just 30 seconds?
again thanks for your hel

 

[DNF Karran]

as requested..

Attachment filename: book3.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=50965

 

[ionaman]

DNF Karran just had a look at what you did for me and yet again it i
great and really appreciated. Is it possible to have a timer on th
Hint part? The only reason I ask is so that the person using the qui
will only have a short time looking for the answer and so will kee
them interested in it

 

[ionaman]

Just wondering can anybody put a timer on the hint button so that whe
the button is pressed the text only appears for 30 seconds. any hel
appreciate

 

[ionaman]

Just wondering can anybody put a timer on the hint button so that whe
the button is pressed the text only appears for 30 seconds. any hel
appreciate

 

[DNF Karran]

If were going to do this then lets do it properly- see attached.

Forms are now userforms and can easily be controlled from VBA and are
more useful than the way I suggested before.

Dunca

Attachment filename: book3.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=51109

 

[ionaman]

Hi,
I have been trying to make the hint button bring up an image for eac
question but I am not able to do it. I was wondering can anyone help
At the moment when the hint button is pressed then just a text fro
sheet 2 comes up. What I really need is for an image to come u
instead. The images I need are on sheet 1 below the questions.
Regards,
Dav

 

[ionaman]

This is the excel I am working of

 

[DNF Karran]

There's no file attached to your latest post.

Should be able to find time to get it sorted if you send it over in th
next 30mins.

Dunca

 

[ionaman]

If you send me an email at (e-mail address removed) I can email you bac
with the excel sheet. it is too big to load here.
Dav

 

[DNF Karran]

Dave,

as the file is already large adding pictures may be a bad plan so...

File attached should do what you want- you will need to save you
pictures as "picture1.jpg" , "picture2.jpg" and input the path and th
file extension (if not .jpg) on sheet2.

Apologies for the delay in getting back to you, I didn't get any mai
from you till 5.30pm my time and the file arrived at 11.30pm las
night.

Dunca

Attachment filename: copy_of_fyptest2.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=51403