I have a worksheet with a list called "Employees"

I want to use that list to populate a listbox called "lbEmployees" on a form
instead of using multiple lines of additem.

I thought this would have been possible using listfillbox but, if it is, I
can't generate the correct syntax. I am beginning to think that listfillbox
can only be used with listboxes embedded in a worksheet - although that does
sound somewhat illogical.

Are there any suggestions as to the correct syntax that I should use to
allow me to use listfillbox in a form?

Cheers.

Hi Simon,

Try the following.

UserForm1.Show
UserForm1.ListBox1.RowSource = "Sheet1!A1:A20"


--
Regards,

OssieMac


"Simon Skelton" wrote:

I have a worksheet with a list called "Employees"

I want to use that list to populate a listbox called "lbEmployees" on a form
instead of using multiple lines of additem.

I thought this would have been possible using listfillbox but, if it is, I
can't generate the correct syntax. I am beginning to think that listfillbox
can only be used with listboxes embedded in a worksheet - although that does
sound somewhat illogical.

Are there any suggestions as to the correct syntax that I should use to
allow me to use listfillbox in a form?

Cheers.

You should really stick with your original thread. This what I posted
there...

Try this...

cmbName.RowSource = "Employees"

--
Rick (MVP - Excel)


"Simon Skelton" wrote in message
...
I have a worksheet with a list called "Employees"

I want to use that list to populate a listbox called "lbEmployees" on a
form
instead of using multiple lines of additem.

I thought this would have been possible using listfillbox but, if it is, I
can't generate the correct syntax. I am beginning to think that
listfillbox
can only be used with listboxes embedded in a worksheet - although that
does
sound somewhat illogical.

Are there any suggestions as to the correct syntax that I should use to
allow me to use listfillbox in a form?

Cheers.