VBA Date Format displaying as general number within userform

Hi guys,

My code developed a problem recently, where the date format for a combobox list started displaying in general format within the userform, and within the spreadsheet (when the record was sent to the spreadsheet).

I have a timestamp generated within the userform, which is not causing me problems, so I am stuck on the cause of this fault.

Even within the spreadsheet I have tried formatting the column where the date information is sent to (Column E), and formatting it into ‘date format’ but that doesn’t work either..

Here is my code:

Please Login or Register  to view this content.

Here is what is happening with the date within the userform...

dateissue.JPG

Originally Posted by kalbasiatka

need to see the file

Originally Posted by Norie

How are you populating the combobox on the userform?

Hi, I am populating the combobox on the userform through defined ranges (of a table), which is tgeb listed in the Row Source of the date combobox in the userform - Please see the screenshots below:

This is my 'Date list' on a spreadsheet.

date.JPG

The date has been turned into table which has a defined name and range - so the range dynamically expands as I add new dates to the list:

named range.JPG

This is the rowsource within my userform ocmbobox - referencing the named range:

visual basic row source.JPG

And this is what happens with the Userform date drop down - and within the spreadsheet (I have data validation within the date spreadsheet too I must make you aware):

2.JPG

MAIN spread.JPG

Thanks!