RowSource
Thanks! Got it....
"JLGWhiz" wrote:
Try this:
Me.listbox1.RowSource = Range("CashierList").Address.
The row source must equate to A1 format.
"Sam" wrote in message
...
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.
.
|