Avatar of Rayne
Rayne
Flag 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
Microsoft OfficeMicrosoft Excel

Avatar of undefined
Last Comment
Rayne

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Anne Troy

Actually, you need conditional data validation. Debra calls it dependent data validation and shows that here:

http://www.contextures.com/xlDataVal02.html
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

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
Anne Troy

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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Rayne

ASKER
Thank you teylyn