[USERFORM] Dynamic searchable user form.

I have names in COL A and contact number in COL B . I have a userform with two textbox and a commandbutton which will add new enrty. I want the both textbox to act as search box. If i type name in textbox1 or number in textbox2 then it should show me suggestions automatically. If my name matches with existing name then textbox 2 shld be auto filled with corresponding number and same for textbox2 if result matches then fill textbox1 with name. If i type Surname it shld display results (not only left search).

NOTE:- Both columns will have blanks zeroes and duplicate entries. [Can also use combobox]

Try the attached file. Most of the names is column A of the file you posted had leading spaces which I have removed. The userform has three new buttons. Enter a name in TextBox1 and click the FIND button. Click the CLEAR button to clear the text boxes. Enter a number in TextBox2 and click the FIND button. Click the CLEAR button if you want to do another search. The EXIT button closes the userform.

I have found partial solution and implemented in my workbook. I have added 2 listbox and it works fine but problem is duplicates ( Example :- Owen) . Also how do i implement the below line of code untill last non empty row in col A. Suppose last non empty row is 199 then i want

Please Login or Register  to view this content.

Formula used in h2 is (implemented using vba)

"=IFERROR(VLOOKUP(ROW(H1),F2:G1000,2,0),"")"

I want One more line of code that is if textbox lose focus then listbox.visible=false.