How to validate my text boxes???
1)Range check, which will allow user to enter only number from 25 up to 1000 only, if lesser or greater than the range then MsgBox should appear.
2) the text boxes should not be left empty or unfilled
3) Format check for Date entry, i want the user to be able to enter in this format only : dd-mm-yy.
4) and also the date entered by the user, should not be before the system date and not later than 90days from the system date.
someone plz help me out, i tried and tried but it's not working
And i have to submit the project soon...
So plz help,
Thank you so much...
Will be waiting for reply...
1)Range check, which will allow user to enter only number from 25 up to 1000 only, if lesser or greater than the range then MsgBox should appear.
2) the text boxes should not be left empty or unfilled
3) Format check for Date entry, i want the user to be able to enter in this format only : dd-mm-yy.
4) and also the date entered by the user, should not be before the system date and not later than 90days from the system date.
someone plz help me out, i tried and tried but it's not working
And i have to submit the project soon...
So plz help,
Thank you so much...
Will be waiting for reply...