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.

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.

The information I want to put in the list box is within the range B63 to G271.
Some of the information in this range I don't want shown.
If I hide these rows is there any way of not showing them in the list box?

"Bob Phillips" wrote:

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.

Not unless you iterate through them and pick out the non-hidden items.

--

HTH

Bob Phillips

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

"enyaw" wrote in message
...
The information I want to put in the list box is within the range B63 to
G271.
Some of the information in this range I don't want shown.
If I hide these rows is there any way of not showing them in the list box?

"Bob Phillips" wrote:

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.

Can you give me an example of how I would do this please?

"Bob Phillips" wrote:

Not unless you iterate through them and pick out the non-hidden items.

--

HTH

Bob Phillips

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

"enyaw" wrote in message
...
The information I want to put in the list box is within the range B63 to
G271.
Some of the information in this range I don't want shown.
If I hide these rows is there any way of not showing them in the list box?

"Bob Phillips" wrote:

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.

Something like

ListBox1.Clear
For Each cell In Range("H1:H100")
If Not cell.EntireRow.Hidden Then
Listbox1.Additem cell.Value
End If
Next cell


--

HTH

Bob Phillips

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

"enyaw" wrote in message
...
Can you give me an example of how I would do this please?

"Bob Phillips" wrote:

Not unless you iterate through them and pick out the non-hidden items.

--

HTH

Bob Phillips

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

"enyaw" wrote in message
...
The information I want to put in the list box is within the range B63
to
G271.
Some of the information in this range I don't want shown.
If I hide these rows is there any way of not showing them in the list
box?

"Bob Phillips" wrote:

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.