Hello Everyone:
I have a form that consist of a list box and a text field. The list box's properties has a column count of 2 with linked cell C5. The data comes from name range: =eebox!$A$2:$B$25000
The box gives me an employee ID in column 1 and the corresponding employee name in column 2. However, this has about 200 names and therefore I would like to add a search feature for the client to use. I want to search by name. however, when I put in a text field to perform the search I can only link to cell C5 where the ID is and my list box is linked to. Unfortunately, it is unlikely that the client would have this ID, they would want to search by last name.
Is there a way that I can search by employee name in column 2 and as I am typing the last name, can the box begin to show the last names as I put in letters? Do I have to use a text box or can it be done on a combo box? I am open to changing if necessary.
THanks
I have a form that consist of a list box and a text field. The list box's properties has a column count of 2 with linked cell C5. The data comes from name range: =eebox!$A$2:$B$25000
The box gives me an employee ID in column 1 and the corresponding employee name in column 2. However, this has about 200 names and therefore I would like to add a search feature for the client to use. I want to search by name. however, when I put in a text field to perform the search I can only link to cell C5 where the ID is and my list box is linked to. Unfortunately, it is unlikely that the client would have this ID, they would want to search by last name.
Is there a way that I can search by employee name in column 2 and as I am typing the last name, can the box begin to show the last names as I put in letters? Do I have to use a text box or can it be done on a combo box? I am open to changing if necessary.
THanks