Hi
My first post here, so here goes!
I work as a Maths teacher and have created some tasks for my students in Excel. I have used IF formulas to create a Correct and Incorrect scenario (which I have hidden) and then I have used a COUNTIF formula to count the number of CORRECT to give the student instant feedback on the number they have done correctly. I have attached the file for you to look at!
My question is - is it possible to create a button and attach a VB script which will mark the answers and return a score (i'm certain it is!?)
and
if this is possible is it possible that when the MARK IT button is clicked the script send the returned score to another file with the student name or emails it to a give email address?
Just wondering if this is possible? I don't possess (personally) the VB skills to do this but wanted to know if it was possible first before pursuing this route.
Any help or guidance (or a better/easier way) would be great!
Thanks Everyone!
J Banks
Bookmarks