VBA Scoring Test Answers

[Stephen_IV]

Can someone please help me. I am looking for some vba to automatically score some answers that I have for questions. The questions are from 1 to 5. I would like VBA to give the the TOTAL score right for each person. Can someone please help me.

Thanks in advance Stephen.

Book1
	A	B	C	D	E	F	G	H	I	J
1		Answer1	Answer2	Answer3	Answer4	Answer5	Answer6	Answer7		TotalScore
2	Steve	2	4	5	2	2	3	2		4
3	Bob	3	4	1	2	3	3	2		5
4	John	1	1	1	2	4	3	5		3
5	Mike	5	5	4	2	3	1	3		2
6	Ray	4	2	4	2	1	5	3		2
7	Tony	5	2	1	1	1	2	2		4
8	Sam	3	4	2	1	1	5	5		2
9	Tom	5	4	5	4	1	2	3		3
10
11
12
13
14		Score
15	Answer1	5
16	Answer2	4
17	Answer3	1
18	Answer4	2
19	Answer5	1
20	Answer6	3
21	Answer7	2
Sheet1

 

[PaddyD]

well, what wuld you want the vba to do with the results? when would it be triggered etc...

 

[Stephen_IV]

Paddy D,

I should have been clearer. Take nothing away from your response it actually works very well. I am learning VBA so I am a little overwelmed at the moment on how I would approach this with a VBA solution . In other words, I would like to use a subroutine to actually get the values that the formula gives. One press of the button.

Thanks Stephen