Time entry
 

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

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

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

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

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

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

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

Leah,

Best way to get to this is go to the sheet tab on your worksheet,
right-click and then View Code from the menu. Paste Chip's code in there.

--

HTH

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


"Myrna Larson" wrote in message
...
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

How about this:

Format | Cells | Custom
enter the format:
00":"00":"00

Richard



"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

Thank you!! It works great!!
leah

"Bob Phillips" wrote:

Leah,

Best way to get to this is go to the sheet tab on your worksheet,
right-click and then View Code from the menu. Paste Chip's code in there.

--

HTH

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


"Myrna Larson" wrote in message
...
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