Data Validation - In cell drop Down List

[VandyBill]

My Data Validatio drop down has 30,000 rows. I need to do the following

1.Increase the number of rows shown from 8 to 50
2.Allow users to type in the drop down to filter their search. For example
when they are in the drop down and type "B" it brings up those list choices
that start with "B".

Any help is greatly appreciated

 

[Gizmo63]

Hey,

Pt 1 - as far as I know there is no way to increase the number of rows but
someone may be able to correct me on that.

Pt2 - Can't do it with validation but you can if you embed a combo box with
it's appropriate coding to load it with the selection options and what to do
with the selection.

If you want to avoid any coding you could introduce a 2 stage process where
dropdown 1 is 'Select starting letter' (A-Z) and then show a second dropdown
to display only options beginning with that letter.
This can be done without code.

HTH

Giz