Dynamic chart dropdown help

[Redder Lurtz]

Hi,

I've created a set of dynamic charts dependent on the selection of a single customer from a list of around 1200. Is there a way of selecting the supplier by hitting the first letter of the customer to take the user to, for instance, customers beginning with "S"? It's a bit of a pain having to manually scroll through the whole list. Also, is there a way of making the font size larger in the selection cell?

Many thanks.

[Pete_UK]

Debra Dalgleish shows how you can do that using a Combo box. You can check it out here:

http://www.contextures.com/xlDataVal10.html

Hope this helps.

Pete

[newdoverman]

Contextures has what you are looking for.
Video demonstration: https://www.youtube.com/watch?v=vOOuSe_s6pQ

Detailed instructions and VBA code to make this work:
http://www.contextures.com/xlDataVal14.html#intro