Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
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 |
#10
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
Time Format Auto Entry AM and PM | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |