Hey guys, I'm looking for a way to select multiple values from an Excel table ("products_to_select_in_slicer") in a slicer ("products_slicer") using VBA. Table "products_to_select_in_slicer" just have a single column. Tried to find it on many forums. Never got it... The only thing I found is this way (that is not possible in my situation): ActiveWorkbook.SlicerCaches("products_slicer").VisibleSlicerItemsList = _ Array( _ "[products_to_select_in_slicer].[no_product].&[001]", "[products_to_select_in_slicer].[no_product].&[002]", _ "[products_to_select_in_slicer].[no_product].&[003]", "[products_to_select_in_slicer].[no_product].&[004]") Thanks a lot for your help! Michael

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Select multiple values from an Excel table in a slicer using VBA

Thread starter ecotm034
Start date Jun 4, 2014

ecotm034

New Member

Jun 4, 2014

Hey guys,

I'm looking for a way to select multiple values from an Excel table ("products_to_select_in_slicer") in a slicer ("products_slicer") using VBA. Table "products_to_select_in_slicer" just have a single column.

Tried to find it on many forums. Never got it...

The only thing I found is this way (that is not possible in my situation):

Code:

ActiveWorkbook.SlicerCaches("products_slicer").VisibleSlicerItemsList = _
        Array( _
        "[products_to_select_in_slicer].[no_product].&[001]", "[products_to_select_in_slicer].[no_product].&[002]", _
        "[products_to_select_in_slicer].[no_product].&[003]", "[products_to_select_in_slicer].[no_product].&[004]")

Thanks a lot for your help!

Michael