Hello,
This is my first forum posting so please let me know if I need to include any other information.
What I am looking for is some type of macro that can evaluate text strings and numbers that are entered into a cell. It is apart of our new employee training. Ideally the user would enter in what they think is the correct answer for all the cells, then they click a button or run the macro that tells them if there answers are right or wrong (by highlighting red, etc.) I was planning to have the answer key in a hidden workbook for the macro to pull from.
Any suggestions?
This is my first forum posting so please let me know if I need to include any other information.
What I am looking for is some type of macro that can evaluate text strings and numbers that are entered into a cell. It is apart of our new employee training. Ideally the user would enter in what they think is the correct answer for all the cells, then they click a button or run the macro that tells them if there answers are right or wrong (by highlighting red, etc.) I was planning to have the answer key in a hidden workbook for the macro to pull from.
Any suggestions?
