Having problem with 2000 to 97 conversion

[jfgambit]

I have built a nice employee time tracking device in Excel 2000. It is pretty self explanitory ("IN" time, "OUT" time, total time, etc). What I am having problems with is the VB code that is behind the "OUT" time. In essence, once an "OUT" time is entered, the ms error message box is overwritten to ask what type of break the person took (No Lunch, 1/2 hour, 1 hour) and takes the response and implements it into the Total hours calculation. Works great in 2000, but the users are getting problems in 97. i don't have 97 and can't seem to trouble shoot it. Could some guru with 97 have a look at this and see what exactly I am missing in 97.

The code is a manipulation of Ken Getz's brilliance by Stratos. Which can be viewed at the following: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=39D37A29.99BF2A63@csv.warwick.ac.uk

If anyone can help, please let me know and I can send you a copy of the Excel sheet. Really appreciate the help.

THANKS.


Thanks for any help

 

[Ivan F Moala]

Ivan:

Thanks! I look forward to reviewing the spreadsheet and your updates.

Thank you both for your time in regards to this matter.

Jeff

Hi Jeff,

couldn't get you

Your message did not reach some or all of the intended recipients.

Subject: RE: Excel sheet for Mr. Excel Post
Sent: 7/05/2003 7:59 p.m.

The following recipient(s) could not be reached:

'Jeff Frick' on 7/05/2003 8:00 p.m.
No transport provider was available for delivery to this recipient.

 

[mort1703]

hi can you tell me what changes I would need to do to adjust the coding to display a 4 button option, I see from your example how to do a 3 button choice, but I'm not seeing what I need to adapt to calculate for the fourth button