Short listing the Data Validation List

[Asoka Walpitagama - Brandix College IT]

I have over 4000 entries as the prd code & need to enter them on a worksheet.
By using DATA VALIDATION is there a feature to shortlist the list when
typing letters.
( Like a LOV ( List of values in Oracle Forms ))
When "C" is types only the codes starting with C will be shown

 

[L. Howard Kittle]

Try this.

Sort your validation list and at the beginning of the A's enter a single A,
do the same for the beginning of the B's and all the way through to the Z's.

Click in the cell that has the drop down validation and type in the letter
of the list you desire... say you type in an O. DO NOT hit enter... leave
the cell in the edit mode (still selected) and now hit your down arrow.

Should take you to the O which is the top of the O list of selections.

HTH
Regards,
Howard

"Asoka Walpitagama - Brandix College IT"

 

[T. Valko]

You can use a combo box from the control toolbox toolbar. It has
autocomplete capabilities.

--
Biff
Microsoft Excel MVP


"Asoka Walpitagama - Brandix College IT"