Hello,
I use a form with a combo box to find out a name from a (long) list.
Column A contains NAMES
Column B contains first NAMES
Most of the time the search works fine when use enters few letters composing the searched name.
ie : if i look for Mr CLARCK Paul entering CL immediately highlights CLARK and all is done.
I do not know how to manage specifics cases when column A contains duplicates names,
ie : CLARK Paul and CLARK John
Here , column A has duplicates 'CLARK' but column hasn't.
In the case we are in name duplication, tying-in 'CL' will highlight the FIRST 'CLARK' from the list.
Then, the 2sd 'CLARK' can't be easyly found , here user has to manually browse all the list from the combobox to find it out.
Is there a way to manage duplicated in column A, would a second combobox for first names be usefull ?
Another important thing for me is to return the row number associated to the NAME selected in the combobox.
Here is attached my file :
COMBOBOX search.xlsm
Thanks for your help and have an happy end of year.
I use a form with a combo box to find out a name from a (long) list.
Column A contains NAMES
Column B contains first NAMES
Most of the time the search works fine when use enters few letters composing the searched name.
ie : if i look for Mr CLARCK Paul entering CL immediately highlights CLARK and all is done.
I do not know how to manage specifics cases when column A contains duplicates names,
ie : CLARK Paul and CLARK John
Here , column A has duplicates 'CLARK' but column hasn't.
In the case we are in name duplication, tying-in 'CL' will highlight the FIRST 'CLARK' from the list.
Then, the 2sd 'CLARK' can't be easyly found , here user has to manually browse all the list from the combobox to find it out.
Is there a way to manage duplicated in column A, would a second combobox for first names be usefull ?
Another important thing for me is to return the row number associated to the NAME selected in the combobox.
Here is attached my file :
COMBOBOX search.xlsm
Thanks for your help and have an happy end of year.