Debra Dalgleish:
http://contextures.com/xlDataVal08.html#Larger

And not possible using data|validation.

But it is possible with a combobox from the control toolbox toolbar.

breadvan579 wrote:

what was the work around

Also, is it possible to 'type ahead' so when typing P the pick list
will jump to all selections that begin with the letter P

--
breadvan579
------------------------------------------------------------------------
breadvan579's Profile: http://www.excelforum.com/member.php...o&userid=15193
View this thread: http://www.excelforum.com/showthread...hreadid=497772

--

Dave Peterson