I need a list in Column C of a worksheet, from say c20:c5000, in the list is values from a10000:a110000.

However is there anyway I can get the list to have something like a smarttag option. When I type M, marketing would appear, or the first value with m. Having a list that has a thousand values in it, trying to find a value at w is slower than typing it.

Would appreciate any help.

I know that with a userform and using an

.additem "Marketing"

allows when choosing to just hit m, and marketing pops up.

Thanks Josh