Showing selected slicer item in a cell
<p>Any ide how to show selected slicer item in a cell?</p>

<p>I have tried to use this UDF code:</p>

<p><code>Public Function SlicerSelections(Slicer_To_Project_Name1 As String)
FblSlicerSelections = ""
Dim i As Integer
With ActiveWorkbook.SlicerCaches(Slicer_To_Project_Name1)
    For i = 1 To .SlicerItems.Count
        If .SlicerItems(i).Selected Then
            SlicerSelections = SlicerSelections &amp; " " &amp; .SlicerItems(i).Value
        End If
    Next i
End With
End Function</code></p>

<p>But I dont get any response?</p>