listbox months

  • Thread starter Thread starter toon
  • Start date Start date
T

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
 
Use addItem rather than listfillrange or rowsource and load the box using

additem Cell.Text

so the entries are text strings.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using combobox to find column 4
help with dates on form combobox 5
Excel Help with dates 2
Lookup Formula 1
Set Up Calendar To Account For Leap Years 2
macro to do subtotal by eachqtr in calendar year 3
Convert Worksheet List to Named Array Constant 4
Column Headings Repeating 5

Back
Top