Data validation

[Guest]

I have a huge list in Data Validation mostly the names.

When the cell is selected drop down menu will appear, but what i like to
know is when a type a particular letter it should go to the names starting
with that corresponding letter ( as we select the file by typing the starting
letter).

Help will be appreciated.

Thanks in advance

 

[Dave Peterson]

This isn't supported in Data|Validation.

I have a huge list in Data Validation mostly the names.

When the cell is selected drop down menu will appear, but what i like to
know is when a type a particular letter it should go to the names starting
with that corresponding letter ( as we select the file by typing the starting
letter).

Help will be appreciated.

Thanks in advance

 

[Guest]

can someone help me to have the code written for this

 

[Dave Peterson]

Maybe it's time to replace the data|validation cells with comboboxes from the
Control toolbox toolbar.

If you rightclick on one of those comboboxes (while in design mode), you can
choose properties.

You can choose .Style to be fmStyleDropDownList
and you can choose .MatchEntry to be fmMatchEntryFirstLetter