Filtered Data Listbox

[bob3940]

I have about 300 items in several columns, I want to choose all of the items in the list that meet a criteria and display those in a listbox. for example my spreadsheet has the following info.

   A         b
1  Carrot    Vegetable
2  Orange    Fruit
3  Spinach   Vegetable
4  Apple     Fruit
5  Banana    Fruit

I apply a filter to limit the rows displayed to be only Fruit so now my spreadsheet looks like this:

   A         b
2  Orange    Fruit
4  Apple     Fruit
5  Banana    Fruit

If I want to display this info in a listbox on my form I would normally just set the listbox.rowsource="Sheet1!A1:B5" but this puts all of the items fruit and vegetables in the listbox. (which makes sense because the filter only hides the rows).

Is there an easy way to have it use only the filtered data?

Thanks for any help,

Bob