none
Creating user search box to select data in slicer? RRS feed

  • Question

  • I have the slicer with 10000 Loan Numbers. I want to create the search box to filter the required loan numbers in slicer.  Is there any way we can achieve this Using VBA or Any other way. 

    Thank you 

    Thursday, September 1, 2016 7:40 PM

Answers

  • Hi NadhMandava,

    in that you can selects the records for particular dates like that.

    but here you want to select multiple records. It's called searching instead of filtering.

    maybe the following article can help you.

    How to select slicer values with VBA

    Extract/list slicer values using VBA

    How To Create A Filtering Search Box For Your Excel Data

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, September 2, 2016 7:35 AM
    Moderator

All replies

  • Hi NadhMandava,

    please visit the link below in which you will find the detailed steps and example regarding Filter the Slicer.

    Filter a Pivot Table or Slicer for the Most Recent Date or Period

    How to Add a Search Box to a Slicer to Quickly Filter Pivot Tables and Charts + Video

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, September 2, 2016 2:58 AM
    Moderator
  • Hey Thank you for your Replay 

    In that example we can enter only one loan number or use the multiple selection option but i want to select 50 loan numbers in  10000 count. 

    Thank you 

    Friday, September 2, 2016 3:47 AM
  • Hi NadhMandava,

    in that you can selects the records for particular dates like that.

    but here you want to select multiple records. It's called searching instead of filtering.

    maybe the following article can help you.

    How to select slicer values with VBA

    Extract/list slicer values using VBA

    How To Create A Filtering Search Box For Your Excel Data

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, September 2, 2016 7:35 AM
    Moderator