This is an easy one, adding a list to a combobox

[DaveR]

Sorry for the basic question but I am a hacker.
I want to have a list of the months of the year to select from. Usually, because I do my work in Excel I build a name list and pull that into the ListRange property but i was wondering if their was an easier way?

thanks
Dave

 

[dannyh]

The combobox has an AddItem method, you can do something like -

combobox1.AddItem "Jan"

- for each, or make an array containing the month names and loop through it for adding the array elements.

Hope this helps,

Dan.

 

[johnwm]

Try this

For a = 1 To 12
List1.AddItem Format(CDate("1/" & a & "/01"), "mmm")
next a

in the form load event Let me know if this helps
________________________________________________________________
If you are worried about how to post, please check out FAQ222-2244 first

'There are 10 kinds of people in the world: those who understand binary, and those who don't.'