Hello,

So I have a question about how to make a searchable list that shows the remaining options while typing. The dropdown list is great but with over 100 options it could be easier just searching/typing.

I have looked online and tried to use some Combo Box with vba code (and i have tried 3 different ones) but I always seem to run into a problem.

For instance:

1) Using named range in a table, the options with the vba code and the combo box would not bring over the list in the box rather it was just blank.
2) While using just the range as in like "A1:A50", this would work when I would use the combo box, but it would list the whole range including total cell (Yeah I know I could just not include that row but...). However, month to month another name could be added to the list and with out resetting the data validation 3 different times I am trying to keep it dynamic which is why I originally used the named range in the table.
3) Also tried creating a new named range using formulas such as offset and counta to keep it dynamic, but with the vba code, it then would only bring over the actual formula as options. So it would only show the offset and the other parameters as options and not the actual list.

If the other vba code is needed, let me know and I can put it up, but thinking maybe someone has attempted this while using a table and/or named range with some vba and maybe I can just adjust it to my workbook.

The workbook overall is done for the year, so for this next fiscal year I am updating it to add a few more things to help us out, so I am willing to adjust the file as well.

Please let me know if I should provide the file.

Thanks for any help,
Ant