Userform Textboxes and dates

Hi All,
I have a multi-page userform that, 1. Is used to populate information entered into a data sheet, and
2. Receive data from the data sheet and place in a list-box and, placing a row of data in various textboxes on the userform in order search, edit or delete the previously selected information.
When entering dates, e.g. date of birth or date of admission, the appropriate dates are entered from the userform into the data sheet correctly, in the required format, dd mmm yyyy. When re-calling data the dates are shown in the userform's list-box in the correct format - dd mmm yyyy, but
when calling (double-clicking) on data in the userform list-box in order to edit the information, the list-box data is placed in the relevant text-boxes ready for editing again correctly however, when the dates in the list-box are transferred they appear in the textboxes as a date in "general" format i.e. 9238 instead of 16 Apr 1925.

I have looked at and tried many examples from various examples but to no avail. Does anyone know how I can force a text-box to accept a dd mmm yyyy format?

Thank you in anticipation of any help given.

Originally Posted by AndyRoo119

Hi All,
I have a multi-page userform that, 1. Is used to populate information entered into a data sheet, and
2. Receive data from the data sheet and place in a list-box and, placing a row of data in various textboxes on the userform in order search, edit or delete the previously selected information.
When entering dates, e.g. date of birth or date of admission, the appropriate dates are entered from the userform into the data sheet correctly, in the required format, dd mmm yyyy. When re-calling data the dates are shown in the userform's list-box in the correct format - dd mmm yyyy, but
when calling (double-clicking) on data in the userform list-box in order to edit the information, the list-box data is placed in the relevant text-boxes ready for editing again correctly however, when the dates in the list-box are transferred they appear in the textboxes as a date in "general" format i.e. 9238 instead of 16 Apr 1925.

I have looked at and tried many examples from various examples but to no avail. Does anyone know how I can force a text-box to accept a dd mmm yyyy format?

You have not given us any code to work with, so a general type answer... take the value from the ListBox and pass it through the Format function. So, if your ListBox was named ListBox1 and your TextBox was named TextBox1, then something along the lines of this should work...

TextBox1.Value = Format(ListBox1.Value, "dd mmm yyyy")

Hi Rick,

Did like you said and my relevant bit of code now reads;

Please Login or Register  to view this content.

Works great, thanks.

Now going to try and work out how to validate the dates being entered.

Watch this space!