data validation question

bam12

Well-known Member
Joined
Dec 6, 2004
Messages
983
I have a data validation list, my question is

Hope i can describe what i want to do

If you begin to enter data inthe cell that it will bring bring up the closest entry

Example if i have Cattle in the list and i start to type cattle in that cell when i click on c it will bring up the first work with C.

Is this possible?

Thanks in advance for any help
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,222
I have not seen that functionality in a native data validation setting. You can achieve what you describe by placing an activex combobox on the sheet instead of data validation, and setting its MatchEntry property to 0-fmMatchEntryFirstLetter.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,911
Messages
5,575,001
Members
412,633
Latest member
simon_elvin
Top