Having Trouble With VBA Project Can Anyone help me build this form?

Record Employee Work Time

[IMG]file:///C:/Users/Student/AppData/Local/Temp/msohtmlclip1/01/clip_image001.jpg[/IMG]
• Form opens in the center of the screen
• Workbook can be accessed while the form is open
• Initial formatting o Form caption correct o Labels formatted correctly o Textboxes formatted correctly o Combo box has correct values o Combo box is formatted correctly o Date label shows current date in correct format o Label showing current time is functioning correctly o Buttons in correct location and formatted correctly o Record Time button initially disabled o Clock In/Clock Out option buttons have correct captions o Clock In/Clock Out option buttons are disabled o Message label has correct message
• When an employee is selected the Clock In/Clock Out option buttons are enabled
• When an employee is selected the appropriate message is shown in the message label
[IMG]file:///C:/Users/Student/AppData/Local/Temp/msohtmlclip1/01/clip_image003.jpg[/IMG] Instructions.docx
• When Clock In is selected the Record Time button is enabled
• When Clock In is selected the appropriate message is displayed in the message label
[IMG]file:///C:/Users/Student/AppData/Local/Temp/msohtmlclip1/01/clip_image004.jpg[/IMG]
• When Clock Out is selected the Record Time button is enabled
• When Clock Out is selected the appropriate message is displayed in the message label
[IMG]file:///C:/Users/Student/AppData/Local/Temp/msohtmlclip1/01/clip_image005.jpg[/IMG]
• When Clock In is selected and Record Time is pressed o If the selected employee has not already clocked in without clocking out
§ The current date is put on the Time Sheet in column 1 of the first available row
§ The employee’s full name is put on the Time Sheet in column 2 of the first available row
§ The time the button was pressed is put on the Time Sheet in column 3 of the first available row § The Employee combo box has no value showing
§ The Clock In/Clock Out option buttons are disabled
§ The appropriate message is displayed in the message label
§ The font in the message label is formatted appropriately
§ The Record Time button is disabled
[IMG]file:///C:/Users/Student/AppData/Local/Temp/msohtmlclip1/01/clip_image007.jpg[/IMG]
o If the selected employee has either not clocked in or has clocked in without clocking out
§ Nothing is added to the Time Sheet
§ The appropriate message is displayed in the message label
§ The font in the message label is formatted appropriately
[IMG]file:///C:/Users/Student/AppData/Local/Temp/msohtmlclip1/01/clip_image009.jpg[/IMG]
 When Clock Out is selected and Record Time is pressed o If the selected employee has logged in on the current day and has not logged out
§ The time the button was pressed is put on the Time Sheet in column 4 of the row in which the employee has already clocked in, but not clocked out
§ The Employee combo box has no value showing
§ The Clock In/Clock Out option buttons are disabled
§ The appropriate message is displayed in the message label
§ The font in the message label is formatted appropriately
§ The Record Time button is disabled
[IMG]file:///C:/Users/Student/AppData/Local/Temp/msohtmlclip1/01/clip_image011.jpg[/IMG]
Guy has already clocked out for the day without clocking back in
§ Nothing is added to the Time Sheet
§ The appropriate message is displayed in the message label
§ The font in the message label is formatted appropriately
[IMG]file:///C:/Users/Student/AppData/Local/Temp/msohtmlclip1/01/clip_image013.jpg[/IMG]