Require fields to be filled out?

Is there a way to make it so that a person has to fill out a field, or gets an error message if they fillout a form and leave spaces blank? I'm creating a sign-in sheet that has

Name, Time In, Time Seen and Time Out. I want it to require or at least notify the users if they don't fill out one of the sections in a line.

Sure, are you using a UserForm or is the user filling data directly onto the worksheet?

If using a form, after clicking whatever button they push to put the data into the sheet but before actually moving the data, have excel check that each of those controls (txt or combo boxes) are not = "". If they are, show a message box telling them to fill each out and then exit sub.

If the user is writing directly to the spreadsheet, you need something to trigger the code that checks if the line is completely filled out. Once you have that you can check that each cell has a value, and if one does not use a message box telling them to fill it out.

If you post a sample workbook I'd be happy to put an example of the needed code in it.

The reasons I'd use a userform are:
1) Looks cleaner / more professional.
2) Easier trigger to make sure your whole line is filled out. As is, I can't think of how you'd make sure a whole line is filled.

I've reposted your example with a rough userform. Check out the RowSource property of the comboboxes, and the code behind the whole form to see how it works.

The page I found most helpful when I was creating my first forms was:
http://www.exceltip.com/st/Create_Us...Excel/629.html

Hope that helps!

Thanks a lot for the form, I'll play with it for a bit to get it to where I want, but this is a great starting point.

*EDIT* Nevermind, I figured it out. Thanks again.