Until you get the code right, you could temporarily use "AutoCorrect" to
change a "decimal" entry to a "colon" entry.
That way, you could use the NUM keypad and enter your times using one hand,
and when you've completed your entries, simply change it back to the
decimal, until next time.

<Tools <AutoCorrect
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"leah" wrote in message
...
I did not change the code at all from his code.
I guess I'm asking if I should change the code, or is there something else I
have to do besides just copy and paste it?

leah

"Bob Phillips" wrote:

Well we know Chip's code works, but without seeing yours, and details on
what you did, we would just be guessing.

--

HTH

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


"leah" wrote in message
...
I am trying to enter times (00:01:42) without having to enter the colons
(I'm
lazy). I found out how to do it by a post on 11/2/04 which referred to
this
site:
http://www.cpearson.com/excel/DateTimeEntry.htm
I copied the time program over into Excel Visual Basic, but I must be
missing something b/c it doesn't work.

leah