Link to home
Start Free TrialLog in
Avatar of Rayne
RayneFlag for United States of America

asked on

DropDown with available fileds change

Hello All,

Can anyone direct me to the EE question or resource where its possible to create a doprdown where the dropDown fileds change based on what user enter like for example

myRange has these values

aaa
aa
aerty
aaafgggh
bbb
b45
bbhj
cc
cccc
cccccc
cgh
d45
ddd
d567

It might be a combo-box or something...so when the user enters say [a] in the combobox, the combo-box filed only shows up all the values that start with [a] like ....

aaa
aa
aerty
aaafgggh

Thank you
Rayne
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Actually, you need conditional data validation. Debra calls it dependent data validation and shows that here:

http://www.contextures.com/xlDataVal02.html
Hi Dreamboat,

where've you been all these years?

As far as I read the question, the crux is to have type-ahead or autocomplete. Out of the box Excel data validation does not do that, but the combo box with the settings outlined in the contextures.com article does.

cheers, teylyn
Thanks, Teylyn. I'm stupid. Didn't RTFQ---I skipped this part:
create a doprdown where the dropDown fileds change based on what user enter like for example

When my range of values isn't that large, I have been known to type them into cells above the data validation box, give that name a range, and hide the rows. No combobox or code required.
Avatar of Rayne

ASKER

Thank you teylyn