Hi folks, I'm needing some help. My son is trying to create an integer game in excel for his 6th grade class. We have the majority set up so that a random list of integers are created for students to add/subtract together.
Here's my problem:
Right now every time you type in your answer to the addition/subtraction problem, all the random numbers reset to a new list of numbers. Is there a way to create a macro/use VBA so that a user can click a "Start" button, and it will clear the answers column and create a random list of integers in two separate columns for the students to add/subtract? The list of random numbers won't change until the "Start" button is hit again. And bonus points: how difficult would it be (in VBA) for the user to input in two cells the minimum (example, -100) and maximum (example, 250) numbers to randbetween and use that as the min/max parameters in the randbetween? And how difficult for a user to put in a number of questions they want to answer, and have a random addition/subtraction used for each question? Clear as mud?
I've tried recording a macro but it won't take. ANY help appreciated, I think I've got a 12 year old hooked on excel and this part is really frustrating him. I'll attach the working copy we're using right now.
Here's my problem:
Right now every time you type in your answer to the addition/subtraction problem, all the random numbers reset to a new list of numbers. Is there a way to create a macro/use VBA so that a user can click a "Start" button, and it will clear the answers column and create a random list of integers in two separate columns for the students to add/subtract? The list of random numbers won't change until the "Start" button is hit again. And bonus points: how difficult would it be (in VBA) for the user to input in two cells the minimum (example, -100) and maximum (example, 250) numbers to randbetween and use that as the min/max parameters in the randbetween? And how difficult for a user to put in a number of questions they want to answer, and have a random addition/subtraction used for each question? Clear as mud?
I've tried recording a macro but it won't take. ANY help appreciated, I think I've got a 12 year old hooked on excel and this part is really frustrating him. I'll attach the working copy we're using right now.
