ComboBox and "mmm-aa" format
 

Hello,
I have a problem with the format of value in a combobox.
The range of value in the "ListFillRange" are dates (Jan-02, Feb-0
....).
When I select a value in the combobox, this value changes in a seria
data format (37287,37315 ....)
How can I maintain the "mmm-aa" format ?
Thanks,
Francesc

--
fragher7
-----------------------------------------------------------------------
fragher75's Profile: http://www.excelforum.com/member.php...fo&userid=1236
View this thread: http://www.excelforum.com/showthread.php?threadid=27040

ComboBox and "mmm-aa" format
 

Hi,

I have a problem with the format of value in a combobox.
The range of value in the "ListFillRange" are dates (Jan-02, Feb-02
...).
When I select a value in the combobox, this value changes in a serial
data format (37287,37315 ....)

what do you think about

Private Sub ComboBox1_Change()
ComboBox1.Value = Format(ComboBox1.Value, "dd.mm.yyyy") 'use
whatever format you wish
End Sub

regards

arno