Simple kids math training tool

ravenoki · Oct 6th 2021

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"

**royUK** · Oct 7th 2021

Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.

How to use code tags

Just highlight all of the code and press the <> in the post menu above button to add the code tags.

Thanks.

**royUK** · Oct 7th 2021

Attach an example of the workbook

ravenoki · Oct 7th 2021

Hello and sorry for the missing information....
Here is the file

**royUK** · Oct 7th 2021

Try this.

The number of correct answer is shown in C15 when the button is clicked. It uses a formula and formatting to calculate the answers. VBA simply changes the format of the cell.

ravenoki · Oct 7th 2021

Hey big thanks to you mate!

**royUK** · Oct 7th 2021

Pleased to help.

Post back if you need further help.

Visit my web site, http://www.excel-it.com, for more examples and some helpful articles.

Simple kids math training tool

Participate now!

Share