Random Number Generator

[anasshaukat]

Hi,
I am creating a math game in excel, and i wanted to use a random number generator to randomize the questions. I also made it when they get the correct answer the box is green and if it isnt its red. However whenever I type the answer in, it randomizes the questions again before you can answer it correctly. I want it to wait until its correct, protect the sheet, and then make a button show up that says next question, where when I click it the button disappears and a new equation appears. Hope this is not too confusing.

P.S Idk where to learn Macro from so its hard for me so I hoped the community could help me. Thanks.

 

[diddi]

hi and welcome to MrExcel
it will help if you post your code

 

[anasshaukat]

hohope

Hope this helps. I am slightly new to VBA so dont quite know how it works. The button is supposed to make the numbers randomized and it does that, but when I randomize the questions, and try to type in the correct answer, it changes it to a new equation.

 

[diddi]

when you press the Button2 is that when the macro4 runs
are there any other macros

 

[anasshaukat]

No there isnt any other macros besides that one. And yes when i press the button the macro runs. Thank you in advance for helping. I'm so bad at excel?

 

[diddi]

put this new line before your line as i have shown. that may sort your problem

Range("BU13").Value=""
Range("BI18").Select

 

[anasshaukat]

Thanks. It did solve half my problem though. Do you know how to make the randomizer not randomize the 2 cells when I type in an answer?

 

[diddi]

i would generate the random numbers in the code...

Sub Macro4()
    Range("P13").Value = Int(Rnd()*10 +1)
    Range("AY13").Value = Int(Rnd()*10 +1)
    Range("BU13").Value=""
End Sub

 

[anasshaukat]

Thanks, that actually worked. Thank you.