+ Reply to Thread
Results 1 to 5 of 5

Help with three dependent ActiveX comboboxes?

  1. #1
    Registered User
    Join Date
    01-18-2021
    Location
    Italy
    MS-Off Ver
    365
    Posts
    22

    Help with three dependent ActiveX comboboxes?

    Hello everyone,
    some months ago I opened another thread similar to this one, but due to my minimal knowledge about the topic I ended with not giving you the necessary info...
    Now, after some studying, I think I realized what I need to complete my work, which is a dashboard built from several pivot tables and filtered by some slicers and three dependant ActiveX comboboxes. The first combobox should filter the "Product" field, the second the "W.O." field and the third the "Operations" one.

    Currently I almost managed to complete the first combobox, but I still have some problems due to my limited knowledge. I would like to learn and would really appreciate your help!

    My current goals are as follows:
    1. make the macro I wrote more stable (I am a beginner with VBA and every tip is always welcome!), because sometimes, if I delete the names of the products filtered in the combobox itself, they might even disappear;
    2. being able to clear the comboboxes and make the pivot tables return as before;
    3. filter the "Product" and "Progress" tables, located in their respective sheets (it seems like I am not able to filter tables which do not have the "Product" field in the pivot filter...);
    4. connect (if possible, because it would be a gem!) the slicers to the comboboxes, so that they react whenever they filter a product.


    Down below you have my code and my attached sample file.

    Please Login or Register  to view this content.
    Thank you very much in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Help with three dependent ActiveX comboboxes?

    Hi ifritaeon61?
    maybe so (see attached)
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-18-2021
    Location
    Italy
    MS-Off Ver
    365
    Posts
    22

    Re: Help with three dependent ActiveX comboboxes?

    Hi nilem,
    first of all thank you for answering!
    It's a good solution and it actually shows what I would like to achieve, but in reality I have to manage thousands of products and I would like to avoid inserting huge slicers.
    Also, I would like to give the possibility to open PDF files from the results obtained in the comboboxes (I would like to work on it on my own and see what I am able to do, before asking help here) and, unless I am proven wrong, I don't see any other way other than using comboboxes.

    Any idea of yours is welcome, though!

  4. #4
    Registered User
    Join Date
    01-18-2021
    Location
    Italy
    MS-Off Ver
    365
    Posts
    22

    Re: Help with three dependent ActiveX comboboxes?

    Hello everyone,
    I'm sorry to bump this, but may I almost know if it is possible to filter the "Product" and "Process" pivot tables along with all the others, please?

  5. #5
    Registered User
    Join Date
    01-18-2021
    Location
    Italy
    MS-Off Ver
    365
    Posts
    22

    Re: Help with three dependent ActiveX comboboxes?

    I can't stop hoping that what I want to achieve is possible.
    If anything, please let me know if I wrote anyhing unclear.

+ 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. Help with Comboboxes/Dependent Comboboxes
    By PintaExcel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-14-2020, 12:42 PM
  2. [SOLVED] Clear dependent activex comboboxes
    By michael61182 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2016, 02:04 PM
  3. [SOLVED] Vba to clear and then populate activex comboboxes
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-31-2015, 04:07 PM
  4. [SOLVED] VBA help need for linking three ActiveX Control ComboBoxes
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2014, 10:22 PM
  5. Indexing Through ACTIVEX Comboboxes
    By Hemimud in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-13-2012, 11:27 AM
  6. Linking two ActiveX comboboxes across different tabs
    By sgillette01 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-08-2011, 10:08 AM
  7. Linking two ActiveX Drop-Down ComboBoxes
    By Madic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-02-2011, 02:42 AM

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