Creating a form and storing information

[Monsignor]

Hello!

This challenge may be better handled in Access or a true database but the person making the request only uses Excel.

1. Create a form that will accept names, dates, and grades.
2. Store the information on a separate worksheet so that it's being accumulated and reports can be ran from it.

I'm aware of Excel's automatic form but it doesn't allow for validation.

Example: some score ranges are 0-5 others are 0-15. We can't allow for a 12 to be put in where the max is 5.

I know how to do the validation. The big challenge now is telling Excel: I've completed entering this record. Now clear, and start a new record on the next row?

NOTE: I'm not so savvy with VBA. So, a non-VBA solution would be hugely appreciated.

 

[VoG]

This should help you http://www.contextures.com/xlUserForm01.html

 

[Monsignor]

This should help you http://www.contextures.com/xlUserForm01.html

This does help a great deal. I'm just wondering if there's a way that we can limit the use of VBA even further. I know how to use the data validation with the form controls. Doing it in code is another challenge and we've got maybe 30 fields. Also, the users know even less about Excel than I do. So, once I hand this off to them, if they tweak something ... OOPS! Good luck reviewing the code.

I'm wondering this:

Of the 30 fields. Can I do this all on a worksheet with form controls and data validation. And then the only VBA would be a button that:
1. Saves the data in the 30 fields on the next empty row on a separate worksheet and
2. Clears the form so that we can add the next entry