Need some help for validation in a macro

[satishdu]

i am very new to VBA and currently working on a macro buy got stuck with some issue .

My macro details are as below

Under macro i have create a form by which an worker would enter his
daily production unit and this data would be save in another excel
file named database. I am done with saving the data to that excel file
but stuck on some validation.

Please help me on these validation.

Date Validation

1. Under date text box - date format (mm/dd/yyyy) can be enter only
and does not allow to enter future date.

2. On submit click , it validate that unique record saved in database
file on the basis of Name and date.

3. On submit button , none of text box value remain blank, if so then
give error.

4. I want save data month wise, means whenever new month start it
automatically save data on new tab (worksheet) and name that tab with
name.

Please help me with this, i have attached the my macro file.

[Solus Rankin]

Maybe Project_Validation.zip

[satishdu]

Thank you Solus for your urgent help on this.

But can you please help me further , as it still not fulfilling my requirement. Please find my full requirement below

1 . Can we use the Date picker tool instead of text box so that user can pick right date. Further i also want to put validation on that user can't choose any future date (means date greater then today).

2. Data is still saving on same sheet for all months, i want if any user enter data for new month it create the new tab with that month name and save the data of that month into that month tab.

User Jan data goes in Jan tab of sheet, and Feb data on fab tab same way for all months on the basis of user date selection

3. It still accepting the duplicate records, i try to put various validation for preventing duplicate record entry on the basis of user and date but it doesn't work . So please help with this as well. In this if any user enter the data for same date which already exist on his name in database file then he got error of duplicate record and he can't enter the data of that date again.


Thanks Again for your help on this. Mentor like you always help us learn to something new.