Can Listfillrange be used with a listbox on a form?

  • Thread starter Thread starter Simon Skelton
  • Start date Start date
S

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.
 
Hi Simon,

Try the following.

UserForm1.Show
UserForm1.ListBox1.RowSource = "Sheet1!A1:A20"
 
You should really stick with your original thread. This what I posted
there...

Try this...

cmbName.RowSource = "Employees"
 
Back
Top