Start typing, possible alternatives appear automatically

[CousinExcel]

Hi,

Data validation solves my need. But it is not a quick, easy way.
Is there improvement possiblities, some easier alternatives ?

I have Data Validation List for example
Master Mike H.
Master Eduardo
......
......
And assume the list has 1000 items
[although to have so much so good masters is not possible : ) ]
It is difficult to press data validation arrow, scroll down many times and
find the needed item.

When I start writing Master M in a data validation applied cell,
is it possible to see the list of all alternatives automatically.
(And to click if poosible.)

Any alternatives better than
"click validation list arrow,
see list,
scroll downs,
try to see little letters"
would be better option for me.

By the way, I apologize for the humour above (items of the sample validation
list) , and I would be very pleased if anyone would tell me if such humours
are not welcomed in the group.

Best regards,

Cousin Excel

 

[Mike H]

Hi,

On it's own data validation can't do this but you can do it with a combobox
from the Controls (ActiveX) toolbox.

There's a very good tutorial on it here. If you get stuck then post back but
the key to achieving what you want is MatchEntry set to
1-frmMatchEntryComplete


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

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.