Combobox in XL messed up?

[VulcanJedi]

I have a combobox pulling values from XL. The dates from a sheet show correctly, however after selecting one the date entered in the comobox after the pane retracts is XLs 5 digit code for a date? Solutions? Thx. Tranpkp

 

[xlbo]

Just plop this into the combo change event (substituting the combo name in)

Private Sub ComboBox1_Change()
ComboBox1.Value = Format(ComboBox1.Value, "dd/mm/yy&quot
End Sub Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde