Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
RE: Drop Down List More
0 views
Skip to first unread message
John Calder
Nov 24, 2009, 7:14:01 PM11/24/09
to
One way is to sort your validation list and at the beginning of the A's enter
a single A, do the same for the beginning of the B's and all the way through
to the Z's.
a single A, do the same for the beginning of the B's and all the way through
to the Z's.
Click in the cell that has the drop down validation and type in the letter
of the list you desire... say you type in an O. DO NOT hit enter... leave
the cell in the edit mode (still selected) and now hit your down arrow.
Should take you to the O which is the top of the O list of selections
Cheers
"bettyh" wrote:
> I have a drop down list, I want it to select the choice when the first letter
> is typed in. How can I do that?
> I just need the dropdown to ensure there are no typos in the answer.
Gord Dibben
Nov 25, 2009, 11:47:50 AM11/25/09
to
DV dropdowns do not have autocomplete capability.
See Debra Dalgleish's site for combining DV with a ComboBox.
http://www.contextures.on.ca/xlDataVal10.html
Gord Dibben MS Excel MVP
0 new messages