Assuming you are entering the times on Sheet1, the code belongs in the Module
named Sheet1, NOT in Module1.

On Mon, 17 Jan 2005 14:21:03 -0800, "leah"
wrote:

No, I'm not sure I understand. I opened up VB and then in the project window
I expanded the modules for that spreadsheet and then double clicked on module
1, and pasted it in the window on the right.
Sorry, I don't know the jargon, I've mostly just played around and figured
out the little I do know.

thanks for your help and patience,
leah

"Bob Phillips" wrote:

Leah,

If I recall correctly, it is event code that goes in the appropriate
worksheet code module. Do you understand what that means, and do that?

--

HTH

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


"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