two things at once?

I am trying to make a game with Excel. It's a word game, and part of it is you have to type in a word before the game timer elapses. The timer is the easy part. I am using a Do While Loop and a timer to subtract a second off the game timer every second. The problem is you can't type into a cell while the timer is running. I have added DoEvents to allow other processes, but typing tends to stop the timer.

I thought I'd see if anyone had any ways around Excel's apparent inability to do two things at once.

There's a vba implementation of the visual basic timer on my site that will
sort you out.

Robin Hammond
www.enhanceddatasystems.com

"evanzo" <[email protected]> wrote in
message news:[email protected]...
>
> I am trying to make a game with Excel. It's a word game, and part of it
> is you have to type in a word before the game timer elapses. The timer
> is the easy part. I am using a Do While Loop and a timer to subtract a
> second off the game timer every second. The problem is you can't type
> into a cell while the timer is running. I have added DoEvents to allow
> other processes, but typing tends to stop the timer.
>
> I thought I'd see if anyone had any ways around Excel's apparent
> inability to do two things at once.
>
>
> --
> evanzo
> ------------------------------------------------------------------------
> evanzo's Profile:
> http://www.excelforum.com/member.php...o&userid=29167
> View this thread: http://www.excelforum.com/showthread...hreadid=488926
>

I have posted an example at http://cjoint.com/?lDohCca2wE which you should
be able to use.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"evanzo" <[email protected]> wrote in
message news:[email protected]...
>
> I am trying to make a game with Excel. It's a word game, and part of it
> is you have to type in a word before the game timer elapses. The timer
> is the easy part. I am using a Do While Loop and a timer to subtract a
> second off the game timer every second. The problem is you can't type
> into a cell while the timer is running. I have added DoEvents to allow
> other processes, but typing tends to stop the timer.
>
> I thought I'd see if anyone had any ways around Excel's apparent
> inability to do two things at once.
>
>
> --
> evanzo
> ------------------------------------------------------------------------
> evanzo's Profile:
http://www.excelforum.com/member.php...o&userid=29167
> View this thread: http://www.excelforum.com/showthread...hreadid=488926
>