Hi there, iv been asked at work to come up with this time sheet but
haven’t really thouched on the coding side of excel before,

What I have is two sheets, one called Table and the other called Times.
Table is meant to hold all the data of what times the job was started
and stopped at on each of the days, there is also a check box next to
the days to be checked if the job has run over the lunch break to then
subtract the 30mins break.

I need a user form with a combo box at the top which the users is able
to select the job number from the first column ‘A’ then below two combo
boxes for each day with a list of times from Sheet ‘times’ inside.

When the user form is fill in and the enter button is pressed. I need
it to find the right row, on the ‘Table’ sheet from what was chosen
from the top combo box at the top of the form, and then fill in the
rest of the sheet with the other times selected from the other boxes.

Thanks Clare Foxly


+-------------------------------------------------------------------+
|Filename: time sheet.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3474 |
+-------------------------------------------------------------------+

--
clarefoxly
------------------------------------------------------------------------
clarefoxly's Profile: http://www.excelforum.com/member.php...o&userid=24183
View this thread: http://www.excelforum.com/showthread...hreadid=378036