Is it possible to do data validation in cells with a search in excel?

Question

Visual Basic

Hello!
Is it possible to make a dropdown list in cells with the ability to search in it?
I'm not interested in calling combox or the like.
You can insert a list into a cell using validation, but is it possible to search in this list when entering in a CELL?
Or is it possible to somehow track what the user enters in a CELL in real time, and not in forms or boxes?
Excel itself can do this if, for example, you have a table and you enter the values ​​\u200b\u200bthat are already in it, and then it already offers what was scored above. Is it possible to implement this using your list located on another sheet or in an array?

Ideally, if possible, then search for similarity implemented in search engines (Google, Yandex) - when you enter a value, a list of options appears. I would like to click on a cell, start entering a value, and he would offer an option from those characters that are entered.
I have not been able to find any functions to track user input in real time, only after the data in the cells has been changed. That is, I need to enter data, press enter, and only after that a drop-down list will be formed.
Or is this not possible with VBA?
Or is it possible to somehow bind the combox strictly to the cell, so that when its geometric parameters change, the combox also changes?