Excel User Form - Date format problem

Cross-posted at https://www.mrexcel.com/board/thread...-form.1207643/

Hello

I've created an Excel User Form which requires a date to be entered (dd/mm/yy). On entering the date in to the form it show correctlys when the data is added to the Excel worksheet .

But When the textbox calls the information from the spreadsheet it converts to number not date format
Many Thanks

Probably you use textboxes to display the data on the userform. The numkber visible is 7th Feb 2022. Writing date value to textbox convert it to text like:

Please Login or Register  to view this content.

see big yellow banner - upload your workbook with 10 or 12 rows of typical data.
far easier then to give you a formatting answer in context to your application.

excel attached

Note that there are extensive responses in the cross-post

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

I have added it since it's your first post.

rather than just answer your immediate question I have uploaded a UserForm and its related code which you may find helpful.
it addresses many issues - do not use 'rowsource' it can be unstable especially in larger apps as it is constantly reading the sheet which slows processes.
try using a 'structured table' for your database - leave UserForm controls with their default name (i.e. TextBox1 etc.,) you can then loop through them - this saves countless rows of code naming each individual when reading/writing data to the sheet.
If you put the 'structured table' into an array it is then stored in memory making access far quicker than reading the sheet every time.
With my calender you will see the buttons are dealt with by a very small module as a button class - this saves the need for individual code on 42 buttons.
To input a new item first press 'NEW' this clears the form and activates the 'ADD' button - enter your data and press 'ADD' to save to the sheet - the rest should be intuitive.
Hope some of this proves useful.
Also do not hard code combobox selections - use individual tables to populate them - you will find this useful when making future additions - (i.e. no need to constantly update code.)