| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3 months prior and 3 months post a date | Excel Worksheet Functions | |||
| Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions | |||
| How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) | |||
| listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
| Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Linear Mode
