Creating Random numbers in Excel problem

Hi all

I have a difficult one here.

1. I have to make a VBA makro that can generate calculus pieces (2 numbers added to each other) for 2.nd grade students. The Program has to generate Random easy calsulus as shown on the
picture. It has to be 30 pieces of (+) Caluculus distributed with 5 horisontally and 6 vertically.

2. A user has to be able to put a minimum and a maximum value of the sum of numbers generated. So if the user puts 20 and 40 the sum of the numbers it is creating can only be between those 2 number. say 11+11, 22+10 etc.

3. Also the student has to be able to try and solve the solve the calculations by typing in his or her answer under the randomly generated numbers.

4. VBA
Then has to go through all the calculations to see if the student made a
right, wrong or no answer at all.

5. The final results will have to be displayed in a message box. e.g. "there are
30 assignments solved with the following results, 22 correct, 1 missing and
3 wrong answers".

Please see attached photo for a better understading.

Thanks in advance. If any questions please ask me.

Thank you very much Andy

i will get cracking with this in the afternoon ...