Formula Autocomplete with display trigger drop down list.

[Albert_Villena]

Hello Everyone!..

This is a bit challenging for me so i was wondering if anyone can help me out with this. I have read lots of threads about DV autocompletion and people wanting to have in it. Well my question is somewhere in the same field.

I have 2 active sheets where one is has a DV based of a source from the other sheet. But the problem with DV is that you have to scroll and look for whatever it is you have listed. What i am trying to do is have my dropdown list function as a "formula dropdown list". To explain that further, notice how you type the = sign in a cell and all the functions/formulas from A to Z pop down on a scoll list? and as you type it automatically filters the functions that match the characters you have entered. That is the exact feature i am trying to copy. Being able to search, match and select a value,text,etc without having to touch my mouse.


I pretty sure its possible due to that capability already being in excel. Any help would be greatly appreciated...