Listbox that alters a filter?

[Macdave_19]

Hi All,

I'm trying to alter a filter ion a range to include all items selected within a listbox, here's what i have so far:

Please Login or Register  to view this content.

it's only working when i select one of the items at a time? the items in the lists are just ID numbers at the moment.

any help is greatly appreciated?

thanks all

[Andy Pope]

Try this,

Please Login or Register  to view this content.

[Macdave_19]

Hi Andy,

Cheers for attempting that it' not owking though?

when i step into it and go through each part at the end it does nothing and the bit that reads

vntItems says <subscript out of range>

??

any idea's

[Andy Pope]

That would suggest nothing was selected in the listbox.

Here's my example

[Macdave_19]

Yo andy,

i dunno what i'm doing wrong?

could you have a butchers please:

[Andy Pope]

The index number is being stored in the array, which for my example was fine as I was using ids 1 to 10.

This change will use the actual selected values.

Please Login or Register  to view this content.

[Macdave_19]

Cheers andy,

i should have spotted that as that was what i was originally doing!

thanks once again