Intro: I volunteer with a bunch of mature people (old guys) that refurb old PC's and give them to needy families at no cost in our area.
What I am trying to do is create a simple time tracking system based on a excel 2010 spreadsheet utilizing userforms. The ws looks like this: date, name, start, stop, total time, comments (pretty basic). I have developed a userform that enters the date, name (from dropdown list) and start time .... works fine.
Now the problem: I need a userform that will read a date and time that are input on the "stop" userform and populate that part on the userform and blank text boxes for "stop" and "comment" and once the user fills in the stop and comment box and hits a enter button, it will update the existing excel record with the additional information.
There are a number of good examples in this forum for calculating time differences, so I can just use that to populate the last field.
thanks in advance for any help or suggestions....
senile2
What I am trying to do is create a simple time tracking system based on a excel 2010 spreadsheet utilizing userforms. The ws looks like this: date, name, start, stop, total time, comments (pretty basic). I have developed a userform that enters the date, name (from dropdown list) and start time .... works fine.
Now the problem: I need a userform that will read a date and time that are input on the "stop" userform and populate that part on the userform and blank text boxes for "stop" and "comment" and once the user fills in the stop and comment box and hits a enter button, it will update the existing excel record with the additional information.
There are a number of good examples in this forum for calculating time differences, so I can just use that to populate the last field.
thanks in advance for any help or suggestions....
senile2
