Results 1 to 3 of 3

Make Dependent Drop Box Searchable

Threaded View

  1. #1
    Registered User
    Join Date
    08-14-2018
    Location
    Northern California
    MS-Off Ver
    2013
    Posts
    8

    Make Dependent Drop Box Searchable

    I may be shooting for the mirror here, but some of my dependent drop boxes have 100+ options in it, so it would be nice to be able to have a search function when using the form's drop down menu without the user having to click on the drop down menu and then start typing - its very counterintuitive to the people who have tested my sheet so far. All of the searchable drop box solutions I found don't use dependent lists, and I can't find a way to make them work with the way I have it set up.

    Is there a VBA solution to make the employee drop box searchable with the way I have my dependent drop lists set up? Do I need to start over and try to come up with a pure VBA solution? What would be best at this point?

    Searchable Box.JPG

    Since I can't upload the sheet (I keep getting an upload failed notice), here is the code:
    Private Sub cboEmp_DropButtonClick()
    
    Select Case txtDIR.Value
        Case Is = "OOC"
            cboEmp.RowSource = "OOC"
        Case Is = "RM"
            cboEmp.RowSource = "RM"
        Case Is = "GM"
            cboEmp.RowSource = "GM"
    
    End Select
    
    End Sub
    I am playing with something like this from StackOverflow, but I seem to be misapplying it:
    Public Sub FilterComboBox1(strFilter As String)
    
        If Sheet1.ComboBox1.ListIndex > -1 Then
    
        Else
            Sheet1.ComboBox1.Clear
            For Each strchoice In colChoices
                If InStr(1, strchoice, strFilter) <> 0 Then
                    Sheet1.ComboBox1.AddItem strchoice
                End If
            Next
        End If
    
    End Sub
    I also found some autocomplete ones, but I am not sure where to put them with the Case/Select functions:
    comboBox1.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown;
    comboBox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
    comboBox1.AutoCompleteSource = AutoCompleteSource.ListItems;
    Last edited by DawnA530; 09-19-2018 at 05:47 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Is this considered a dynamic dependent drop-down? AND how can I make this work?
    By Livingwil in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-11-2015, 07:16 PM
  2. Searchable dependent drop-down list
    By banaanas in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-22-2015, 02:58 PM
  3. Replies: 1
    Last Post: 05-21-2014, 08:11 AM
  4. [SOLVED] Make 2 dependent drop down lists dynamic
    By arsene2conde in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-28-2013, 02:57 PM
  5. [SOLVED] Trying to make multiple dependent drop down list with dynamic ranges
    By Gwen@YouWantWhat? in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-01-2012, 12:55 AM
  6. What would make this workbook non-searchable?
    By Snark in forum Excel General
    Replies: 5
    Last Post: 07-16-2008, 05:54 PM
  7. Replies: 1
    Last Post: 07-29-2005, 12:05 PM

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