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.
Bookmarks