adding range items to a listbox upon initialization
Posted by elizabeth on November 15, 2000 2:34 PM
I've been trying to get a ListBox to AddItems when it is initialized. When I put in text it works fine. But I can't figure out how to get it to pull the information from a named range on my worksheet. Any suggestions on how I can get it do do this?
Here is the code that works when it accepts text.
(where Choose is the UserForm and SelectPerson is the ListBox)
Sub Choose_Initialize()
With SelectPerson
.additem "jim"
.additem "joe"
End with
SelectPerson.ListIndex = 0
End Sub
Thanks!!!
E