tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,832
- Office Version
- 365
- 2019
- Platform
- Windows
Is it possible for Excel's built-in Data Validation to filter as you type?
For example, the list is:
so when the user types ba, the data validation automatically scrolls to ba.
I know it's possible with a combobox.
Thanks
For example, the list is:
Code:
aardvark
aardwolf
abacisci
abacists
abaculus
abacuses
abalones
abampere
baaing
babble
babied
babies
babkas
baboon
baboos
babuls
so when the user types ba, the data validation automatically scrolls to ba.
I know it's possible with a combobox.
Thanks