Dates as Numbers in Combo Box

I have the same problem as thread,

http://www.excelforum.com/excel-prog...ml#post1969271

When I fill the Combo Box it shows as a date in the list for selecting in the Combo Box. Once I select the Date I want it then changes back t its number format. I have tried using the code below and still no joy, where am I going wrong?

Please Login or Register  to view this content.

I have tried this and keep getting a Type Mismatch error on the section

Please Login or Register  to view this content.

When I hover over it on the Debug it shows me the date as a number still

Please Login or Register  to view this content.

Where am I going wrong?

I have tried this code and still when selecting the dates in the Combo Box they appear as a number format

Please Login or Register  to view this content.

I cant see where am going wrong?

I've tried the Hash's

Attached is the file I'm using to test things out...

Its also the same file that the other thread I have open is (Running Stored Procedures from Excel)

Thanks

I have tried this code below and it seems to work like it should...

Please Login or Register  to view this content.