searchable drop down list

  1. Chris The Rock

    Searchable Data Validation Drop-Down using a FILTER() function..with a twist

    I've just been made aware of the technique for making a drop down list with data validation searchable, using a Dyanmic Array function, FILTER(). The examples I've seen, however, are those with a single cell containing that drop-down list. And I have this technique mastered. However.... I...
  2. J

    Searchable ComboBox

    Hi, I have a combobox with dropdown list with hundreds of PLU numbers, how would I make the combobox searchable so they only have to type the first few numbers to filter the list. The With GetObject("P:\DataBase.xlsm") ComboBox1.List = .Sheets("ALL").Range("B7:B500").Value
  3. L

    Searchable drop down lists without Combobox

    Hi all - I have a sheet with multiple columns utilizing data validation drop-downs. I need the drop-downs to be searchable due to the large number of options in the drop-down lists (Country column for example). I understand there are limitations with data validation and this can be done with...
  4. D

    Best way to create a searchable drop-down list with auto-complete functionality to cells in a column?

    Hi Folks, I have a time-sheet workbook with two worksheets (ws). In sheet 1 (the time-sheet ws), Column A is "Employee". Time-sheet worksheet. <tbody> Employee Start time Finish time Hours worked Joe Blogs Jane Doe </tbody> I wish to be able to start typing a different...
  5. P

    How to create searchable drop down list for multiple cells in excel

    How to create searchable drop down list for multiple cell in excel. I need to import the data sheet in excel, I created a drop-down list with datavalidation but the listbox is too long. Please help me to create searchable drop down list in excel but for multiple cells. Thanks

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top