Why Won't The Date Display Correctly In A Userform Combobox?

Hi all,

this is a minor irritation more than a major problem but I'm flummoxed by it all the same. Rylo and ProtonLeah helped me with some code (thanks guys) for using a userform and spin button to amend data - the code is below

Please Login or Register  to view this content.

Here's the problem - the date in combobox2 won't display in the format I would like (DD-MMM-YY) - the data in Column B of the "Data" worksheets is just dates (formatted as DD-MMM-YY) - when the userform loads however, the date (eg 5 Jul 12) is displayed as 7/5/12

I tried using a change

Please Login or Register  to view this content.

but this changes the displayed date to 7 May 12 and gives me a "Huh?" moment. What am I missing here?

Cheers,

AJ

I put together a userform, set cells(1, 1) = 5-July-12, and then used the following code;

Please Login or Register  to view this content.

The combobox displayed it fine to me... Try setting the format when you set the value, rather than via a trigger to the change combobox event.

I also cleaned up your code a bit;

Please Login or Register  to view this content.

Medpack,

that worked nicely, thank you.

Cheers,

AJ