Carim: I am trying to create the exact above solution, but in a userform instead of a cell. In the attached file, sheet "Orders" has a userform button. In the form, the box "Item" is a combo box. I would like that box to be searchable. It is referencing data from the named range "Items" from the sheet "Catalog". I used your code above and changed it according to my data, but I am getting errors. Could you take a look please? It would be greatly appreciated.