RowSource

[Sam]

I have a named range, "CashierList" that I would like to populate a
listbox/combo box when the userform is initialized. When I attempt this the
code crashes with error 380 (Could not set the RowSource property. Invalid
property value). If I insert the code, "Me.listbox1.RowSource =
Range("CashierList")". If I hard-code the range in the list box RowSource
properties, it works fine, but I would rather use the UserForm1_Initialize
event so I can change the RowSource depending on which worksheet is active.

Any guidance would be appreciated.

 

[JLGWhiz]

Try this:

Me.listbox1.RowSource = Range("CashierList").Address.


The row source must equate to A1 format.

 

[JLGWhiz]

Actually, you could just:

Me.ListBox1.RowSource = "CashierList"

That would make the row source a string value in A1 format.

 

[B Lynn B]

Me.listbox1.RowSource = "CashierList"

 

[Sam]

Thanks! Got it....

Try this:

Me.listbox1.RowSource = Range("CashierList").Address.


The row source must equate to A1 format.




.