My wife and I split duties when it comes to teaching our kindergarten-age son. She teaches him reading and writing and I teach him math. To that end, I created a table to help him memorize adding and multiplying zero through nine. It’s nothing fancy, but you can have it if you like.
I started with a grid and some formatting. I use Row 1 and Column A to hold random numbers so I can sort Row 2 and Column B. The data entry grid is conditionally formatted to show green for correct answers and red for incorrect.
The formula for the first one is
The second formula is the same except for it’s ‘not equal’ instead of ‘equal’.
The Start Over button just resets everything with a simple macro:
Dim rTop As Range
Dim rSide As Range
Dim rData As Range
Set rTop = Sheet1.Range(“TopRow”)
Set rSide = Sheet1.Range(“SideCol”)
Set rData = Sheet1.Range(“Data”)
rTop.Sort rTop.Cells(1), , , , , , , xlNo, , , xlSortRows
rSide.Sort rSide.Cells(1), , , , , , , xlNo, , , xlSortColumns
I need to put some fancy animation in for when all the cells are green. So that there’s a prize for completing it.