gacid
11-01-2008, 07:30 AM
Hi! I've got a problem with a VBA-code.
Here it goes:
Step 1: I have to make 2 inputboxes, where you can choose an upper and lower limit for the numbers in the calculations (the calculations we want the VBA-code to generate in step 2).
Step 2: Here excel should generate 30 random calculations. 5 horizontal and 6 down. I have to like this image: (her is lower limit 10, upper 30)
http://imageload.dk/files/7a571463bc2502a0728f67e47f634cbf.JPG
Step 3: a person is manully calculating og inserting results.
Step 4: The VBA-code should now check if the results the person answered are correct. The calculations have to be run through and test:
1) how many correct answers
2) how many wrong answers
3) how many missing answers
I could look like this:
http://imageload.dk/files/6a92c2a83628e008a2070fc8fe1df98d.JPG
Step 5: The result of this test should be presented for the person in an Msgbox. It could look like this:
http://imageload.dk/files/ea4647df76b4bb3524a5c0046d6930ef.JPG
I know it's in danish ; )
Translated:
"There are 5*6 = 30 calculations and they are solved with following result:
26 correct answer(s).
1 missing answer(s)
3 wrong answer(s)
If you're not satisfied, then remember practice make champion!"
Here it goes:
Step 1: I have to make 2 inputboxes, where you can choose an upper and lower limit for the numbers in the calculations (the calculations we want the VBA-code to generate in step 2).
Step 2: Here excel should generate 30 random calculations. 5 horizontal and 6 down. I have to like this image: (her is lower limit 10, upper 30)
http://imageload.dk/files/7a571463bc2502a0728f67e47f634cbf.JPG
Step 3: a person is manully calculating og inserting results.
Step 4: The VBA-code should now check if the results the person answered are correct. The calculations have to be run through and test:
1) how many correct answers
2) how many wrong answers
3) how many missing answers
I could look like this:
http://imageload.dk/files/6a92c2a83628e008a2070fc8fe1df98d.JPG
Step 5: The result of this test should be presented for the person in an Msgbox. It could look like this:
http://imageload.dk/files/ea4647df76b4bb3524a5c0046d6930ef.JPG
I know it's in danish ; )
Translated:
"There are 5*6 = 30 calculations and they are solved with following result:
26 correct answer(s).
1 missing answer(s)
3 wrong answer(s)
If you're not satisfied, then remember practice make champion!"