Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
General Quesiton
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
General Quesiton
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cond. formating quesiton | Excel Worksheet Functions | |||
easy function quesiton | Excel Worksheet Functions | |||
quesiton on links | Excel Discussion (Misc queries) | |||
Pivot Table Quesiton | Excel Worksheet Functions | |||
If..then quesiton. | Excel Worksheet Functions |