Generate Random Math Questions

Hi,

I'm new to writing code in excel and don't have a lot of time to learn. I need to write code for the following. Please help.

I would like to generate random math questions in excel that appear for a few seconds then disappear for a few more before the next problem appears on the screen. Each new question appears with a sound "bing". The questions and answers get recorded where they can’t be seen (so the questions can be marked afterward). I need to be able to say how many questions I want, how long they appear on the screen, how long before the next question appears, how many digits the first number is and how many digits the second number in the question is and what type of math operation is required.

For example: I want to generate 10 random multiplication problems where the first number is three-digit and the second is one-digit. (e.g. 357x4). I want the question to appear for five seconds and then disappear for 20 before the next question appears. Here are the variables with their values:

• Number of questions = 10
• Type of operation = multiplication (select from drop down: multiplication, addition, subtraction, division)
• Number of digits in first number = 3
• Number of digits in second number = 1
• Seconds to show question = 5
• Seconds to hide questions = 20

Of course these variables would change as students become quicker or require more difficult problems. A number in the operation could also be fixed. For example, first number is a random two-digit number and the second is always 7.
No question should appear twice. Questions should be large enough to see on a screen from the back of a classroom.

I know I'm asking for alot, but if you could help me out, I'd be very grateful!

read this book
i didn't get to the part with the math questions yet, but you can skip to it.
just copy down the code in the book
i will have to email u the book because the file is too big to send right now

read which book?

Microsoft Excel VBA Programming for the Absolute Beginner, 3rd edition
Duane Birnbaum and Michael Vine ^^^^^^^^^^^ is not true it is pretty advanced
Thomson Course Technology
u can find it online or in a library
i currently have it online as PDF and i have the book. i realized that they were the same

please send me link for pdf book

http://www.gilmet.ir/tools/Microsoft...e_Beginner.pdf

thanks! will check it out.

ok
takes a while to load the first time, but after that, its really fast