The pupose of this is to ask the user random questions. I have three drop down menus to do with music theory but for arguments sake say the first one is just even numbers up to 20, the second list is the choice of plus or minus and the third, the choice of half, quarter or whole (of the number in list one)
so random questions could be
10 plus a quarter of 10 = 12.5
or 18 minus half of 18 = 9
I have it working with manual selection from a table lookup but wondered if I could automate it so the user just has to click something like Next question that links to a macro. Is it possible?