listbox months

[toon]

hi
i have a combobox that refers to a lit of months
when i click the little arrow, i see feb/2005, mar/2005 etc

when i click on a month i get displayed in the combobox the number of the
month eg: 38384

how can i have the text "feb 2005" displayed in the combobox ?

txs

[Tom Ogilvy]

Use addItem rather than listfillrange or rowsource and load the box using

additem Cell.Text

so the entries are text strings.

--
Regards,
Tom Ogilvy
"toon" <[email protected]> wrote in message
news:[email protected]...
> hi
> i have a combobox that refers to a lit of months
> when i click the little arrow, i see feb/2005, mar/2005 etc
>
> when i click on a month i get displayed in the combobox the number of the
> month eg: 38384
>
> how can i have the text "feb 2005" displayed in the combobox ?
>
> txs
>
>