Selecting from list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all
I am not an Excel expert, so forgive my ignorance. How do I configure an in-cell drop down list created via Data\Validation so that when the user types a letter, the first item beginning with that letter will be selected in the list. In other words, if the first list item beginning with 'R' is 'Rabbit', that item will be selected when the user hits the letter 'R' if the cell containing the list has the focus.
Thanks
Clive
 
Hi Clive
AFAIK you can't customize the standard data validation listbox in this
way.

Frank
 
It *can't* be done exactly as you describe ... BUT ... you can *almost*
accomplish this with multiple drop down lists.
Your main list should be comprised of just the letters of the alphabet,
which would then access another list of all the data items that start with
that letter.
For example, if you wanted the item to be displayed in E4, put your first
validation list just above it in E3, that would show the drop down list of
letters of the alphabet. Color it white.

Your main drop down list in E4 would access the now invisible choice in E3,
and present the appropriate list of items to choose from.

All the particulars to set up this type of procedure can be found on Debra
Dalgleish's web page:

http://www.contextures.com/xlDataVal02.html#Name01
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi all,
I am not an Excel expert, so forgive my ignorance. How do I configure an
in-cell drop down list created via Data\Validation so that when the user
types a letter, the first item beginning with that letter will be selected
in the list. In other words, if the first list item beginning with 'R' is
'Rabbit', that item will be selected when the user hits the letter 'R' if
the cell containing the list has the focus.
Thanks,
Clive.
 
Back
Top