Thread: General Quesiton

background; I have created a quiz that tests professional knowledge based on
a series of questions over a number of sheets (say 20 Q's per sheet).

Is there a way that i can create a macro that records the number of correct
answers and displays it in a table. Each time the user opens the workbook the
cell contents are 'cleared' but the information is saved as an entry in a
table which is displayed on thr first page.

I have made an entry which totals the score on the first page. and it could
incorporate the function =DATE() to provide a column entry?

is this possible, is further info needed?

TIA

Cam
You ask "Is there a way that i can create a macro that records the number
of correct answers and displays it in a table?" Yes, but you don't provide
sufficient information for someone to write the macro for you. For
instance, what constitutes a "correct" answer? What does the test taker do
to enter an answer?
You say "Each time the user opens the workbook the cell contents are
'cleared' but the information is saved as an entry in a table which is
displayed on thr first page." I know this makes sense to you because you
wrote it, but to someone who knows nothing about your business it makes no
sense.
You say "I have made an entry which totals the score on the first page.
and it could incorporate the function =DATE() to provide a column entry?"
Again, this makes no sense except to you.
I am not being critical of what you wrote just to be critical of what
you wrote. All of us in these newsgroups want to help. That's why we look
at these newsgroups and read what you wrote. But you must approach your
task of explaining your question just like you would if John Doe just walked
in off the street. He knows nothing about your business or about what you
are asking and you want him to help you. Please post back and tell us what
you would tell John. HTH Otto


"Cam Neeson" <CamNeeson@discussions.microsoft.com> wrote in message
news:FF77305D-BEA1-4539-9D79-EA4D346B2F4F@microsoft.com...
> background; I have created a quiz that tests professional knowledge based
> on
> a series of questions over a number of sheets (say 20 Q's per sheet).
>
> Is there a way that i can create a macro that records the number of
> correct
> answers and displays it in a table. Each time the user opens the workbook
> the
> cell contents are 'cleared' but the information is saved as an entry in a
> table which is displayed on thr first page.
>
> I have made an entry which totals the score on the first page. and it
> could
> incorporate the function =DATE() to provide a column entry?
>
> is this possible, is further info needed?
>
> TIA
>

Oto,

I will try and explain a bit more in depth

The user chooses the correct answer from a drop down list (populated from a
range of cells in another sheet).

The answer is checked using =if(A1="answer",1,0) cell A2 is then given the
value 1. I have applied conditional formatting to A3 which will display a
color green cell if correct and a color RED cell if incorrect.

The total if the column A2 is summed and added to a cell in the first page
using =SUM(Sheet1!A2+Sheet2!A2) etc.

Ideally what i want to try an do is that when the user is finished
attempting the quiz i want the totals to be saved and displayed as a table
with the date of the attempt logged as a column in the table. At the same
time i would want all the answer cell contents cleared and the condition
formatting removed from the cell column A3.

I hope this make its clearer, anything else i'll try and explain better if
required.
Thanks again