Adding autocomplet to a cell that is validated

  • Thread starter Thread starter kelleybr
  • Start date Start date
K

kelleybr

I'm building a spreadsheet that has validation set up in cells to
display lists so the user has to choose from the options in the
dropdown list. (Like access but without storing the information in a
database) My question, is it possible to have autocomplete work in
those fields? :confused: (Assuming you don't know what I mean by
autocomplete, just in case) If I'm choosing from a list of states and I
type in "A" in the field, Alabama, Alaska, Arkansas, Arizona come up.
I'd like the user to be able to choose from the drop down list or just
type in the field.
 
Harald is correct in stating that it can't be done ... BUT ... it can
*almost* be done.
You could almost accomplish this by building multiple drop down lists.
And if you left a blank row in your lists, users would be able to type in
any data that they wished.

Your main list should be comprised of just the letters of the alphabet,
which would then access another list of all the states that start with that
letter.

For example, if you wanted the state 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 states to choose from.

And since you left a blank row at the bottom of all of your lists, the user
will have the option to type in anything that they wished.

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!
==============================================


Unless some magic is introduced in the 2003 version, that is not possible,
sorry.
 
Back
Top