I am creating a worksheet for my class that i teach. There are certain cells they type their answers into. The way my code works is on a worksheet_change event. I have defined a range of cells as the ones where the students will type their answers and called it InputRange. The worksheet_change event runs when one of the cells in the InputRange is changed.
BUT, I missed one cell, cell C38, by accident in my InputRange. So I try to add it into my range by going to Insert -> Name -> Define. I click on "InputRange" and I either click on the cell to add it in or I typed it in. Either way, once I add that cell in and click OK, my code seems to stop running entirely.
The code that I have checks students answers and basically says "Correct" or "Try Again" in the cell right next to it. When I add that cell into my InputRange, I get nothing. It stops printing "Correct" and "Try Again" and the color of the cell stops changing and everything basically doesn't work. I don't get an error at all, just no code is running it seems. How do I fix this???
BUT, I missed one cell, cell C38, by accident in my InputRange. So I try to add it into my range by going to Insert -> Name -> Define. I click on "InputRange" and I either click on the cell to add it in or I typed it in. Either way, once I add that cell in and click OK, my code seems to stop running entirely.
The code that I have checks students answers and basically says "Correct" or "Try Again" in the cell right next to it. When I add that cell into my InputRange, I get nothing. It stops printing "Correct" and "Try Again" and the color of the cell stops changing and everything basically doesn't work. I don't get an error at all, just no code is running it seems. How do I fix this???