searchable list

  1. B

    VBA to replace vlookup or countIf due to extensive llist

    Hi, I created comboboxes with dropdown lists I presently have formulas that searches through a long list (7000) of names and then once found information is auto-populated in identified cells This is the search mechanism I presently have in place In Column K...
    • Blanchetdb
    • Thread
    • column combo box drop down list dropdown searchable list vba
    • Replies: 6
    • Forum: Excel Questions
  2. S

    Prevent Combo Box Change Event Triggers

    I've followed a guide on how to create a searchable combo box, but the change event triggers every time the workbook is changed. Is there a way to prevent the event from triggering when the combo box is not selected or when the user isn't searching?
  3. D

    Isolating the "=cell("contents") formula to apply only to cells in one column?

    Hi Folks, I am working on a spreadsheet to log sales. I have two columns (customers and products) that I've created searchable drop-down lists for (using this method as outlined in youtube videos: https://www.youtube.com/watch?v=vkPoViUhkxU). https://www.youtube.com/watch?v=0QrQT9D25Xk&t=5s...
  4. S

    Making Data Validation List Easier

    Hi! I need some help making a data validation list easier to search/use. I have about 600 supplier names in my data validation list and it makes it really tedious to have to scroll down to find the right one in alphabetical order. Is there any way to make the list searchable? Also, if possible...
  5. J

    Duplicate searchable drop down list

    Hello guys, I created a searchable drop down list on excel and i want to duplicate it about 10 times, but when i do it, excel considers the 10 copies at one so when i choose an option in one of them, this same option is selected in the ten drop down list. How can this be fixed? should i create...

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
Back
Top