VB ListBox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

joakl - 20 Mar 2006 16:00 GMT

I've never used user forms as part of a macro. I am trying to create a list
box in a user form but can't figure how to enter the list of months. I have
created the user form and inserted the list box, just can't type the months
in...any answers?

Thanks in advance

Reply to this Message

Edwin Tam - 20 Mar 2006 15:59 GMT

In your userform (double-click the form), paste the following code to
"UserForm_Activate". Assume that your listbox is called "ListBox1".

Private Sub UserForm_Activate()
Dim tmp As Integer
With ListBox1
.Clear
For tmp = 1 To 12
.AddItem Format(DateSerial(2006, tmp, 1), "mmmm")
Next
End With
End Sub

Regards,
Edwin Tam
edwintam@vonixx.com
http://www.vonixx.com

> I've never used user forms as part of a macro. I am trying to create a list
> box in a user form but can't figure how to enter the list of months. I have
> created the user form and inserted the list box, just can't type the months
> in...any answers?
>
> Thanks in advance

Reply to this Message