Force a user to enter a date instead of text

Hi,

In a userform i have 2 textboxes that need to be populated with a date.
Is there a simple script to force a user to enter a date in format dd-mm-yyyy?

When commandbutton1 is clicked, it should check if the textbox is populated with a correct date. Otherwise give a messagebox that says something like "Please enter a correct date."

thanks!

Please Login or Register  to view this content.

Repeat for 2nd text box

In the Command Button Click event you could use

Please Login or Register  to view this content.

However you should try to avoid allowing users to enter text for stuff like dates which require a strict format. Instead use one of the many calendar forms you'll find if you google around, or keep it simple and have three listboxes to contain the numbers 1-31, 1-12 and 2016-whatever year is necessary. Then use the numbers selected in the list boxes to create the date. The days listbox could be made to react to the number of days in the month if you force the month listbox to be the first to be colmpleted.

....or create Variables for each date that you capture with the calendar, identifying them with date1, date2...etc and then use the variables to populate the text boxes.

However why are you persisting with text boxes which are capable of being changed. If you just want to record the date on the userform then use the caption property of a Label.

Hi,

One way

Please Login or Register  to view this content.