You could set the RowSource property dynamically in code.

When would you want the different ranges?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"enyaw" wrote in message
...
I am using the row source to populate a list box. Is there a way to
populate
the list box using different ranges of a worksheet. eg B63:G71 and
B82:G85.