Hi,
Basically I would like to list the selected slicer values from "Slicer_Project_Type3" in cell R1 on worksheet "Whiteboard"
Here is my code (that is unfortunately not working)
I've tried putting this code into ThisWorkbook:
My slicer formula name is "Slicer_Project_Type3"Public Function SlicerSelections(Slicer_Name As String) FblSlicerSelections = "" Dim i As Integer With ActiveWorkbook.SlicerCaches(Slicer_Name) For i = 1 To .SlicerItems.Count If .SlicerItems(i).Selected Then SlicerSelections = SlicerSelections & " " & .SlicerItems(i).Value End If Next i End With End Function
So I put, on the "Whiteboard" tab in cell R1
This should return the text from the activated slicer value, but it does not.=SlicerSelections(Slicer_Project_Type3)
Still can't figure out how to accomplish my mission here.
Any ideas would be great.
Thanks.