But how about multiple-columns? does it still works ?





"Doug Glancy" ...
Ramthebuffs,

Don't be coy, give us the details <g. It's hard to say without knowing
what you've tried or what used to work for you. This works for me:

Private Sub UserForm_Initialize()
Me.ListBox1.List = Worksheets("customers").Range("A1:A30").Value
End Sub

hth,

Doug

"Ramthebuffs"
wrote in message
...

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?


--
Ramthebuffs
------------------------------------------------------------------------
Ramthebuffs's Profile:
http://www.excelforum.com/member.php...o&userid=16429
View this thread:
http://www.excelforum.com/showthread...hreadid=384141