Jaafar Tribak has created a very elegant solution ... :wink:
see attached ...
Hope this will help
That solution didnt help because what I want is a dynamic list that for every letter typed it filter the list range to only show the possible matches, but seeing how your file worked it may have show me how I can fix my problem, but i dont know if its possible to do it.
Lets me explain what i understood of the problem
My dynamic list range works by for every letter that is typed in the combobox it changes the value in the linked cell, and using the value of the linked cell it update the dynamic range list to only show the possibles matches.
If I use the arrow keys to move through the combobox list the linked cell get the full value of the option in the dropdown list therefore updating the dynamic range list and since this new value only have one match it exclude all the other options.
To fix this problem I tought in this solution, if the key pressed is not an arrow key then all the changes are sent to the linked cell, but if the arrow key is used it stop sending the values to the linked cell to allow the user to move through the list and when he founds its he press Enter and then the selected value is sent to the linked cell.
Anyone knows if this is possible?