+ Reply to Thread
Results 1 to 3 of 3

VBA ComboBox to search Slicer?

  1. #1
    Registered User
    Join Date
    02-18-2019
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    11

    Question VBA ComboBox to search Slicer?

    Hello again my friends,

    Today I have struggled to find anything online on this subject, I try to avoid wasting peoples time with dumb questions...but yet here I am again.

    To summarize, my excel file has two seperate data sets. One data set is inventory storage (depending where inventory is stored, determines where it is allowed to be exported). The other data set is from our sales force, which is a projection of their sales on specific products, or a "forecast".

    It is my job to look at what we have in inventory, who is projecting sales, determine how much of our inventory qualifies for that particluar sales person, and enter production plans if demand outweighs supply. Simple enough. However, coming into this position they have provided me zero tools in our content mangament system to assess large amounts of data. So I have turned to pivot tables.

    I have everything done, and it functions PERFECT!! The one thing I'm really getting hung up on is this dang slicer. I am using the slicer in my "dashboard" sheet to control the visuals. You can click the product name in the slicer and it will change the graph which shows the breakdown of "forecasts" and it also pulls the inventory & how/where it is stored. I want to add a combobox with active X controls to use as a Search Bar that will control the slicer and manipulate my dashboard instead of scrolling through the slicer looking for the correct product name. I saw the work around of copying the pivot table and hiding everything but the little search box behind the slicer but would much rather use a combobox with active x if at all possible. Someone please haaaaaaalp.
    Last edited by Beast_OnThe_Keys; 05-02-2019 at 05:42 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Calling ALL Excel Guru's - Pivot Table/Slicers/Filters

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    02-18-2019
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    11

    Re: VBA ComboBox to search Slider?

    Hey Sorry about that! Thought somthing catchy would help put eyes on it, unfortuanley got the wrong attention. I have changed the title to best describe what i am trying to accomplish, but may be worded incorrect as I am a noob.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Slicers for Pivot Table
    By Balzer13 in forum Excel General
    Replies: 1
    Last Post: 08-03-2017, 10:36 AM
  2. [SOLVED] Is there any way to tell if a pivot table has slicers?
    By ChemistB in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-07-2016, 12:56 PM
  3. [SOLVED] Disconnect Slicers, Change Pivot Table Source, Reconnect Slicers: a problem
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 02:27 PM
  4. Using Filters with Pivot Slicers
    By Rachel12345 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-07-2015, 02:43 AM
  5. Replies: 2
    Last Post: 05-24-2013, 03:58 PM
  6. Excel pivot table row labels and report filters
    By exodus125 in forum Excel General
    Replies: 4
    Last Post: 10-29-2008, 09:41 AM
  7. Calling all Excel Guru's Help!!!
    By matt shepherd in forum Excel General
    Replies: 5
    Last Post: 06-28-2005, 12:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1