Validation List Autocomplete

[ZenRaven]

I've seen requests on a few sites for an autocomplete solution for validation lists. Everyone here has helped me so much I thought I'd make a contribution attempt. I know this has it's shortcomings but it fulfills my current needs and should be able to be modified fairly easily for many situations. Let me know what you think.

[URL unfurl="true"]http://www.mediafire.com/?sharekey=08fac7922bece0545a3d773badf21430e04e75f6e8ebb871 [/url]

 

[ZenRaven]

I also had to add the following to to the CaptureKeys sub to get the numeric keypad

    Application.OnKey "{96}", "'ProcessKey ""0""'"
    Application.OnKey "{97}", "'ProcessKey ""1""'"
    Application.OnKey "{98}", "'ProcessKey ""2""'"
    Application.OnKey "{99}", "'ProcessKey ""3""'"
    Application.OnKey "{100}", "'ProcessKey ""4""'"
    Application.OnKey "{101}", "'ProcessKey ""5""'"
    Application.OnKey "{102}", "'ProcessKey ""6""'"
    Application.OnKey "{103}", "'ProcessKey ""7""'"
    Application.OnKey "{104}", "'ProcessKey ""8""'"
    Application.OnKey "{105}", "'ProcessKey ""9""'"

also noticed that cells have to be formatted as text. Numbers as numeric or general (implicit numeric) don't seem to accept the differently formatted individual characters. Getting uglier by the minute