Can Listfillrange be used with a listbox on a form?

[Simon Skelton]

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.

 

[OssieMac]

Hi Simon,

Try the following.

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

 

[Rick Rothstein]

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

Try this...

cmbName.RowSource = "Employees"