Hi, i am quite new to vba and i need help to create a simple math tool training for my kid.
So the idea is that u have cells C3:C12 that generates random multiplication table in a single cell.
Code
Dim a As Integer
Dim b As Integer
For i = 1 To 10
a = Rnd * 9 + 1
b = Rnd * 9 + 1
Cells(i + 2, 3) = a & "*" & b
Next
Then there is a blank spaces where you place the answer.
i would like to make a button that will count how many of the answers are correct and have this pop up in a msgbox but i can´t figure out how to program this... like "5/10"