In-Cell Drop Down Via Data Validation (Auto Search)

  • Thread starter Thread starter Coby
  • Start date Start date
C

Coby

Is there a way to program and auto search into the in-cell drop down
list which searches as the user types?

I am using data validation in cells using the in-cell dropdown feature
and want the user to be able to begin typing and have the search
narrow to the closest match in the list rather than having the user
scroll through looking for the item he/she wants to select.

This is a very common feature used in combo boxes and such, but don't
know how to do it in this instance.

Any help would be appreciated.
Thanks,
Coby.
 
Is there a way to program and auto search into the in-cell drop down
list which searches as the user types?

I am using data validation in cells using the in-cell dropdown feature
and want the user to be able to begin typing and have the search
narrow to the closest match in the list rather than having the user
scroll through looking for the item he/she wants to select.

This is a very common feature used in combo boxes and such, but don't
know how to do it in this instance.

Any help would be appreciated.
Thanks,
Coby.
Click to expand...

Great, I went to the link and it looks like I have some work to do,
but looks like that will do the trick.

Thanks,
Coby.
 
Great, I went to the link and it looks like I have some work to do,
but looks like that will do the trick.

Thanks,
Coby.
Click to expand...

This works great!!! Thanks, guys. You're awesome.

Coby.
 
Back
Top