LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default letter recognition in drop down lists

How do I get first letter recognition in a drop-down list without having to
use combo boxes?

I have about 500 rows, and on each row a selection has to be made in a cell
from a drop down list. Instead of having to scroll through the list, i would
like to type in the first few letters of the data item and the list to
recognise which item i'm trying to get...

help please!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop Down Lists: Allow option of adding own data if not in drop do ruperthouse Excel Worksheet Functions 8 July 21st 09 07:29 PM
How to create 2 dependent drop down lists from 1 original drop dow Caroline Excel Discussion (Misc queries) 5 May 1st 09 02:19 PM
Drop down lists that auto create and then filter the next drop down list [email protected] Excel Worksheet Functions 2 September 30th 07 11:53 AM
how do I use one drop-list to modify another drop-lists options? [email protected] Excel Discussion (Misc queries) 3 September 9th 07 05:46 PM
Multiple lists with repeated values for dependet drop down lists mcmanusb Excel Worksheet Functions 1 September 29th 06 12:13 AM


All times are GMT +1. The time now is 05:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"