+ Reply to Thread
Results 1 to 3 of 3

Userform with dynamic combo boxes and autofilters

  1. #1
    Registered User
    Join Date
    06-03-2013
    Location
    stl
    MS-Off Ver
    Excel 365
    Posts
    3

    Userform with dynamic combo boxes and autofilters

    Does anyone have any ideas/code to, on each combo box change, update the other combo boxes based on the selections? The combo boxes can be selected in any order.

    I am guessing that each time a combo box is changed, all of the combo boxes would be checked to see if not null then filter data based on all the selections. when looping through the combo boxes on the form, how do you store those into variables that I can use for the advanced/autofilter?

    It would be easier if the combo boxes had to be selected in a specific order, but it decreases the value of my form tremendously.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Userform with dynamic combo boxes and autofilters

    I am not sure if this helps, but I like to use pivot tables linked together with slicers and use the activeX to control the slicer. I am not sure if it is the sexiest method...
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Userform with dynamic combo boxes and autofilters

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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. [SOLVED] Help with code for userform text boxes, combo boxes and excel
    By innerise in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-20-2014, 09:07 AM
  2. [SOLVED] Adding dynamic named ranges to combo boxes in userform
    By Spritz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-04-2013, 09:45 AM
  3. Userform with 2 combo boxes
    By WhiteKelso in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-30-2007, 11:46 AM
  4. Dynamic Combo Boxes
    By wotrac in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-29-2005, 03:09 PM
  5. [SOLVED] dynamic combo boxes
    By tjb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2005, 04:06 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