I was suggesting to use the combo box instead of the data validation drop
down but either will work.

--
Biff
Microsoft Excel MVP


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Debra Dalgleish shows how to implement Biff's solution at her site.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 01:50:56 -0400, "T. Valko"
wrote:

An alternative is to use a combo box from the control toolbox. This has a
MatchEntry property which will match the first letter typed.