Activex combobox date format

hi all,

attached a example of a combobox with a date. When the date gets chosen in the combobox it will no longer be displayed as a date but as a excel date serialnumber.

As proof that I'm not a lazy bum, I've included a macro that is supposed to be working in this situation(googled it). In my case it still wont work :/

Thanks !

combobox example.xlsm

Doesn't seem to do it :/

Please Login or Register  to view this content.

This code generates an error : "Run-time error '380':
Could not set the Value property. Invalid property value."

I guess that by getting rid of that error, the value would become a date. Anyone got a clue?

Thanks!

That didn't do it either john55. I googled it for quite some time and it turns out, that the problem lied within the style. It has to be fmStyleDropDownCombo instead DropDownList.

With that out of the way, I've encountered another problem:

Please Login or Register  to view this content.

The Listindex function isn't returning anything but a 0 (regardless of the choice in the combobox). I noticed, that by ereasing the formating part from the code, the listindex works properly. Anyway i can bypass this limitation? I need the date being displayed (instead of a serial number) - at the same time i do need a listindex :/