software

How come I cannot type a letter such as j and have the list in my drop
down box go to the j section of employees such as John Adams. I have a
list of employees for a weekly schedule.--
jayd77
------------------------------------------------------------------------
jayd77's Profile: www.excelforum.com/member.php...oamp;userid=19048
View this thread: www.excelforum.com/showthread...hreadid=493255If you use a combo box from the Control toolbox, you can set its
MatchEntry property, so the entry will autocomplete as it's typed.

There's an example here that uses a combo box to show a data validation
list:

www.contextures.com/xlDataVal10.html

jayd77 wrote:
gt; How come I cannot type a letter such as j and have the list in my drop
gt; down box go to the j section of employees such as John Adams. I have a
gt; list of employees for a weekly schedule.
gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html