Could someone please help. I have a userform that enables people to enter data in from drop down menus, at the same time they have to choose a date from the datepicker calander function. The spreadsheet where the information is stored is an unopened workbook plus the workbook where my userform is opened from. I need to stop people from entering duplicate entrys into the workbooks and give an error message to tell them the date has already been taken.
Basically they choose their name and shift they want to work (lates or early) from drop down menus and then choose the date when the shift is. If someone else has already taken the shift on that date then they get an error message back.
I hope this makes sense. I have tried to use the data validation method for this but it does'nt work when using code for some reason.
Many thanks to those who can help.
Simon
Basically they choose their name and shift they want to work (lates or early) from drop down menus and then choose the date when the shift is. If someone else has already taken the shift on that date then they get an error message back.
I hope this makes sense. I have tried to use the data validation method for this but it does'nt work when using code for some reason.
Many thanks to those who can help.
Simon