list boxes

[john.9.williams]

Hi i wish to display data within a listbox on a userform, i can do it
by entering the row source in the properties but can i write it in the
userform activate event, the code i am using at the moment is

ListBox1.Text = Range("a1:d50").Text

this is not working , so any help greatly received

john

 

[Tom Ogilvy]

ListBox1.ColumnCount = 4
ListBox1.List = Range("a1:d50").Value

 

[Harald Staff]

Hi John

ListBox1.RowSource = "Sheet1!A150"

HTH. Best wishes Harald