Trouble with Buttons on my simple math worksheet.

I would:
This is more or less a must. Get rid of the Merged Ranges. They will get you into trouble. Lots of google results around about this.
Put you data from Columns P:T into another (next) sheet.
Have you "Next Problem" Arrow colored Green as soon as the answer In G6 is right. Otherwise have it red.
It will turn red when clicking on it to bring the next problem up.
Code behind it will stay disabled as long as there is no answer or the answer is wrong.
Change your left pointing Right Arrow (Previous Problem) to a left pointing Left Arrow!

I am busy for the next little while so if no one else jumps in with a solution, I'll have a look tomorrow.

Thank you for your assistance.
I got rid of the merged ranges and moved the array to Sheet 2.
I replaced the upside down right arrow with an actual left arrow. And colored the "NEXT" (right) arrow red.
I also recorded two macros, one to turn the arrow to green from red and one to turn it from red to green.
However, I have no idea how to implement that into VBA or how to automate it so that it changes when the solution cell has the correct value in it.
Nor have I been able to figure out how to disable the "NEXT" button until the solution is correct. I will re-upload the sheet with the changes.

Again, any help would be greatly appreciated.

Hi 7 welcome to the board.
If you put this formula in A6 (you can change the font colour to white if you want.
=VLOOKUP(D2,Solutions!A2:E41,5,FALSE)=G6

and then put this code in the sheet module for the problems sheets

Please Login or Register  to view this content.

Fluff13,

Thanks so much for your help!

You're welcome & thanks for the feedback.

I guess I was thinking on a lower level than Fluff13

But I started so I should finish.
Attached is my idea.