Select Multiple Values in a Slicer using VBA

[Ambris]

I have a powershell script that passes in a parameter called widgets into a Widgets macro. The Widgets macro uses slicers to return the total cost of the Widgets sold.

Up until now I have only ever needed to total up 1 type of Widget however I would now like to combine multiple widgets (e.g. the total sales for both Red and Blue Widgets). I have tried passing in "Red Widgets, Blue Widgets" but the code is looking for a Widget called Red Widgets, Blue Widgets.

I suspect I need to use an array but in the majority of cases I only need to look up the total cost for one type of Widget.

I have provided what I think is the relevant parts of my code and was wondering if you could assist me in adapting it to work as required.


'

Please Login or Register  to view this content.

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks

[Ambris]

Apologies for not enclosing the code within code tags.

[Andy Pope]

Something like the following, where you loop through the various widgets.

Please Login or Register  to view this content.

You could also use the SPLIT function, instead of ARRAY, to convert a delimited list into an array

[Ambris]

Andy,

Thank you very much for your solution, it works a treat!

Kind Regards Nick