Userform Time & Date format

[RasGhul]

Hi All,


I'm using a userform for data entry, my Combobox's have drop downs with a named range for times eg from 8am - 5pm.

When I click the dropdown the times appear as 8:00 am but after selection it reverts to the fraction or General format.

Is there something I can add to vba so that after selection the combobox's maintain h:mm format?

Can this also be applied to a Date combobox as well so that after selection it maintains dd-mm-yy format?


Thanks in advance!

 

[Norie]

How are you populating the comboboxes?