Hi Simon,

I think you are referring to a different type of listbox created from the
Forms Toolbar. The type used on a Userform are the type created from the
Control Tools Toolbar.

Try the following

UserForm1.lbEmployees.RowSource = "Employees"

--
Regards,

OssieMac


"Simon Skelton" wrote:

I have a worksheet which contains a list called "Employees".

I want to use that list to populate a listbox called "lbEmployees" which is
located on a form - instead of using multiple additem entries.

I thought it would be possible to use listfillrange to achieve this goal but
cannot generate the necessary syntax to do so.

Can listfillrange be used with a listbox on a form or is it limited to being
used with a listbox embedded in a worksheet? If it can be used with a form,
what is the best syntax to use?