I have tried numerous examples on how to populate a listbox from a range and can't get any of them to work. My only guess is that perhaps it is something different in excel 2003? Maybe I need to change something in properties?
I'm using the default ListBox1 on a standard userform(Sub UserForm1_Initialize) and am trying to get a list from sheets(customers).range("a1:a30")
Any ideas?
Bookmarks