RowSource

S

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.
 
J

JLGWhiz

Try this:

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


The row source must equate to A1 format.
 
J

JLGWhiz

Actually, you could just:

Me.ListBox1.RowSource = "CashierList"

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top