Textbox to search table and show in listbox

Hello

i have a table as database in sheet 1 and i have a userform that contains a textbox , a listbox and a search bottom
my goal is to enter text in textbox1 to search through database (table1) and show matched text in listbox1

i ad my file

thanks for you help CONSULTA DE EXTENSIONES.xlsm

Since not clear how you want it, it enables you to search both EXTENSION and NUMERO for partial match.

Please Login or Register  to view this content.

thank you very much y had hard time to figured it out ... you codes works perfect and is the exact way it should be