LinkBack URL
About LinkBacks
Please Login or Register to view this content.
stop this countdown timer macro
Please Login or Register to view this content.
Last edited by arlu1201; 05-16-2012 at 03:43 AM. Reason: Please put code tags in future.
Please Login or Register to view this content.
Hi Bob,
This StopCount creates an error 1004 but it does stop the macro "RealCount". When I end this error "RealCount" continues.
I have a "Correct" macro button and a "Wrong" macro button. I run the StopCount as the first action for both of them.Please Login or Register to view this content.
I really appreciate your help with this. It is a Jeopardy Quiz for Senior Citizens where they have a fixed time to answer "RealCount"
If they answer (right or wrong) within the time allowed it stops the countdown. If they don't - they run out of time.
Thanks heaps for taking the time to look at it - if I can get this bit right - the game is ready to go.
Sincerely,
Jack Stenhouse
Last edited by arlu1201; 05-17-2012 at 04:15 AM. Reason: Code tags
Jack,
I am a bit unclear on what happens. What is the process, what do these people enter, and who clicks the Correct/Wrong buttons? What macros do these buttons fire?
Hi Bob,
The idea is that the question is displayed, the countdown starts.Jeopardy Scoring.JPG
I do all of the button pressing. The correct and wrong buttons update the scores of the players.
They both do a fair amount of work . . . an example is . . .
Surprisingly . . . they all work except that the clock keeps counting down even when the question is answered.Please Login or Register to view this content.
I appreciate the time you have spent on this. Maybe I should have your StopCount call these macros instead of the other way around?
I have attached an image of the scoring screen - three players - three rights - three wrongs.
The A, B, C buttons identify the person and start the clock.
Again, thanks for your effort.
Sincerely
Jack Stenhouse
Last edited by arlu1201; 05-18-2012 at 03:24 AM.
...and don't forget the code tags that you correctly used in your earlier post.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard,
I'm not sure I know what you mean.
I am completely new to this site and I don't know what you mean by "code tags".
If I have neglected to do something, please accept my apologies.
Sincerely
Jack Stenhouse
I have put it for you this time. At the beginning of your code, you should type [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi again Bob,
I am still trying to get this RealCount macro to stop if I press the "correct" or "wrong" macro buttons.
Your "StopCount" macro creates a 1004 error but does seem to stop RealCount.
I know this is only for a game but it would be nice to solve it.
I have attached the Jeopardy file to give you a better idea of what I am trying to achieve.
(I hope this is OK to do?). There is nothing harmful in this file.
The intended use for the game is Senior Citizens and some disabled kids I work with on a voluntary basis.
I appreciate any help you can give me.
Sincerely
Jack Stenhouse
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks