Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List Validation and Format
Hi, I have cell validation working on my spreadsheet whereby when I click on a cell, a list of contents (named range) is presented for the user to select which product is required... no problems here Due to the list being so long (500 products) I would like to use 'type ahead' type functionality... for example if I want to select the a product beginning with P I can simple press P and the list would jump to products beginning with P, as it stands at present I have to scroll down using the mouse the product that I am searching for. Is this possible within Excel ? Many thanks -- breadvan579 ------------------------------------------------------------------------ breadvan579's Profile: http://www.excelforum.com/member.php...o&userid=15193 View this thread: http://www.excelforum.com/showthread...hreadid=498062 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation List Length | Excel Worksheet Functions | |||
Symbols in Data Validation List | Excel Worksheet Functions | |||
data validation list drop down text format too small | Excel Worksheet Functions | |||
Format Validation Cells | Excel Discussion (Misc queries) | |||
Custom Format and Data Validation Q | Excel Worksheet Functions |