VBA project in class

heya.

I`ve been making a pretty similar post in another forum a week ago, but didn`t get any response (which means that the post had only 1 read to begin with), so maybe you guys can help me out.

here`s the deal:

I`m studying at a university in Japan. even though I transferred in as a junior, I have to take that ridiculous freshman computer lab class. (ridiculous as in: in class 1 the instructor started out with "this is a mouse. you can click. you can double click. you also can right-click...". or yet in other words, last week [week 5] we learned how to create a file folder on the desktop)　

so I`ve been trying everything to get out of that class (for example by taking the final right off the bat), but the result was that now my teacher requires me to do VBA in class - on my own. I know my sh*t in terms of using MS Office for daily life, but I`m a total programming NOOB.　

what I`ve got to do is refining the Excel sheet attached, trying to make it a more amusing "game".

the "game" (as you can try out by yourself)so far means that the color and text in each A4 and B4 are switching if you click "GO!". (switching text was in the original file I got from the instructor, I somehow managed to get the colors in)
Whoever might be playing that game is supposed to raise or not raise either a red or white card according to the instruction on the screen. (well, it`s Japanese, but I guess you can figure by the colors used)

the time you see in A1 is a manual countdown that I got in there last week, so that a speed component comes in.

however, what I actually want is
a) a visible, automatic countdown that
b) starts when you click "GO!"
c) resets and restarts when you click "GO!" again
d) creates a message box saying something like "time`s up" if you don`t click "GO!" again before the countdown reaches 0 or "quit" the game which
e) would require an additional command button that deactivates the countdown
f) (optional) some sort of "reward" if you manage to go throught the thing let`s say for example 10 times

this seems to be pretty tricky, huh?

even a little progress would help me a great deal already!
(my instructor doesn`t really care whether I understand what I`m programming or not, so "cheating" is perfectly fine)

the VBA script looks like this right now

☆★☆

Please Login or Register  to view this content.

☆★☆

I sure hope someone can help me with this!

Thanks a lot in advance!

Hi inJapan and welcome to the forum.

If you were my student I'd like you to learn two things about VBA.
http://www.cpearson.com/Excel/Scope.aspx and
http://www.cpearson.com/excel/Debug.htm

BTW - your code won't run on my machine as I don't have the correct character set to have my VBA compile.