Set Filter Equal to ListBox Selection

Please Login or Register  to view this content.

The code above sets the PivotTable Filter to the Index #. As I only have one choice selected, the Index # is 0. However, I want it to be set to the value that Index # 0 is. In other words, the first list item in the ListBox is "GreenDog", how do I I change

Please Login or Register  to view this content.

to equal what the text of the choice is, rather than its Index #?

I solved my own question.

Please Login or Register  to view this content.