list boxes
 

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

list boxes
 

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

--
Regards,
Tom Ogilvy



wrote in message
oups.com...
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

list boxes
 

Hi John

ListBox1.RowSource = "Sheet1!A1:D50"

HTH. Best wishes Harald

skrev i melding
oups.com...
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