Validate UserForm Data Against an Entry from the Worksheet

I have a UserForm that I use to input a soccer league’s schedule. I have both textboxes and optional buttons to input data such as the date, location, field number, home or away team, etc.

I would like to add some VBA code to my UserFrom that would check my selection of a team on the UserForm against the team’s last entry in the worksheet to ensure the start time is greater than their last game’s ending time.

Hopefully, this picture below will bring a little clarity to what I’m attempting to do. I’ve also attached the workbook.

Any assistance with the code is greatly appreciated.

SoccerSchedule.jpg

skywriter,

Thank you for the help. It works perfectly!!