Search in Data validation

[sasuke]

Help on how to have a search function in every cell that has data validation. Please, Thank You

 

[p45cal]

You want to find all cells that have data validation?
Select a single cell on the sheet, press F5 on the keyboard, click Special…, choose Data validation and click OK.

 

[Chihiro]

If you mean searchable validation list. You will need to combine it with ComboBox control and use vba. See link for details.

http://www.contextures.com/xlDataVal10.html

 

[Nebu]

Hi:

Here is something similar I did a while back.

http://forum.chandoo.org/threads/multiple-dropdown-lists-with-same-data.25687/#post-153717

Thanks

 

[sasuke]

If you mean searchable validation list. You will need to combine it with ComboBox control and use vba. See link for details.

http://www.contextures.com/xlDataVal10.html

this link is for auto fill, i want when i typed "a" all the lists that has letter "a" must be seen at the lists

 

[sasuke]

You want to find all cells that have data validation?
Select a single cell on the sheet, press F5 on the keyboard, click Special…, choose Data validation and click OK.

no sir, i want to have a search function in the data validation

 

[sasuke]

Hi:

Here is something similar I did a while back.

http://forum.chandoo.org/threads/multiple-dropdown-lists-with-same-data.25687/#post-153717

Thanks

oww, thanks sir, thats what i want, but i dont know how to do it with my file, can you do that to me sir? this is a big help

 

[Nebu]

Hi:

Find the attached. I have done it for Months drop down.

Thanks

 

[sasuke]

Hi:

Find the attached. I have done it for Months drop down.

Thanks

Thumbs Up, Genius

 

[sasuke]

Hi:

Find the attached. I have done it for Months drop down.

Thanks

can you explain how it works sir? thank you thank u

 

[sasuke]

Hi:

Find the attached. I have done it for Months drop down.

Thanks

sir, do you have video tutorial for this? so that i can easily understand how it works

 

[sasuke]

Hi:

Find the attached. I have done it for Months drop down.

Thanks

why i cant create 2 or more search function in data validation?

 

[sasuke]

any help to create 2 or more search function(columns) in data validation?

 

[Nebu]

Hi:

Here is a link that explains how to do searchable drop-down.

http://trumpexcel.com/2013/10/excel-drop-down-list-with-search-suggestions/

Thanks