arno Wrote:
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
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

Excuse me, but in this way, after the selection in the linked cell,
see only this year dates!!!
My dates start from 2002.
Bye,
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