I need to check whether the Date a user inputs into a textbox is a valid date format. When i initially run the form todays date should appear in the textbox. I managed to do that with the following code:
txtDate.value = Format((Date), "dd/mm/yy")
The required Date Format is "dd/mm/yy".
Next, the user should be able to change this date accordingly. Now the user should be able to change the day,month,and the year. For instance the user should not be able to input a date where the 'Day' part is larger than 31 and the 'Month' part is larger than 12. Before i transfer this date to the spreadsheet i need to check whether the Date user has input is a valid date or not.