Susan Harkins
ssharkins at gmail.com
Fri Jul 17 15:31:04 CDT 2009
Private Sub UserForm_Activate()
'Populate combobox1 with months, by name.
Dim i As Integer
For i = 1 To 12
ComboBox1.AddItem Format("28/" & i & "/2009", "mmmm")
Next
End Sub
I've been using that for years to populate a control with the names of the
months. I've been using it for so long, that I'm not sure if it's still
necessary. Has VBA come up with a specific month-naming function that might
make this obsolete?
Susan H.