Hi all. Been a while since I've been on.
I'm trying to create a visible timer that will START when a macro button is selected and STOP when entry is made into a particular cell with an ENTER key press. I'm measuring length of time transcription takes but, in the meantime while I learn this, I'd like to make an extremely simple version.... so what I did was take a simple adding sheet for my grandkids that starts with a macro, and then when they make an entry it gives them a wingdings happy or sad face, shown by conditional formatting (if right or wrong...). I thought an easy application of the timer while I learn to use it would be to add it to the sheet for the kids.
What I'd be looking to do is have the visible timer run from when the macro button is selected ("New Numbers") until the answer is entered and the ENTER key is pressed. An enhancement to this particular sheet would be to collect the data on the tries and build a database of a session with a success/failure rate calculated... though I have NO idea how to do that.
On the attached file, I've hidden all the rows and columns outside the area for the kids to use, and the macro runs on the "New Numbers" button press. The selection goes to the cell where they should put their answer, so the only thing they have to do is click the button, enter their answer, press ENTER, and repeat.
Thanks again for any help.
I've attached the sheet with the kids file... and help is GREATLY appreciated.
I'm trying to create a visible timer that will START when a macro button is selected and STOP when entry is made into a particular cell with an ENTER key press. I'm measuring length of time transcription takes but, in the meantime while I learn this, I'd like to make an extremely simple version.... so what I did was take a simple adding sheet for my grandkids that starts with a macro, and then when they make an entry it gives them a wingdings happy or sad face, shown by conditional formatting (if right or wrong...). I thought an easy application of the timer while I learn to use it would be to add it to the sheet for the kids.
What I'd be looking to do is have the visible timer run from when the macro button is selected ("New Numbers") until the answer is entered and the ENTER key is pressed. An enhancement to this particular sheet would be to collect the data on the tries and build a database of a session with a success/failure rate calculated... though I have NO idea how to do that.
On the attached file, I've hidden all the rows and columns outside the area for the kids to use, and the macro runs on the "New Numbers" button press. The selection goes to the cell where they should put their answer, so the only thing they have to do is click the button, enter their answer, press ENTER, and repeat.
Thanks again for any help.
I've attached the sheet with the kids file... and help is GREATLY appreciated.