Hello
I am currently trying to make an addition sheet for my son to try help him learn addition. I have a start checkbox and a reset checkbox. When checking the start checkbox I am having 2 fields receiving random numbers. In the third field, he is going to write the answer, and he will receive "Great" or "Try again" in another field. My problem is that when entering the answer and hitting enter, the random function kicks in and changes the 2 first fields. Is there anyone here that can help me how to solve this??

Have a nice evening

Anything that causes a workbook to recalculate with cause the RAND function to do exactly that - recalculate. The only way of preventing the RAND variables recalculating them is to copy/paste their outputs as values - which then removes the formula and its RAND behaviour.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]