ExcelBanter - listbox months

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - listbox months (https://www.excelbanter.com/excel-programming/323894-listbox-months.html)

toon

listbox months

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

listbox months

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" wrote in message
...
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

All times are GMT +1. The time now is 10:13 AM.