VBA for Data Validation List - Auto complete

[sunilbsrv2k]

Hi All,

I am creating a table in Excel with various fields including a column for name.
And in a different cell I am also creating a List (Data Validation) on this column NameMy question is: if there are names like Michael, Michell etc... then when I type M it should give a list of names starting with M from which one can be chosen.Also, if I enter one more letter say 'i'; it should downsize the list and give names starting with 'Mi'.
Could you please let me know if this can be accomplished and how to go about.Thanks,
​

 

[Jaafar Tribak]

https://www.extendoffice.com/documents/excel/2401-excel-drop-down-list-autocomplete.html

https://www.mrexcel.com/forum/excel-questions/851544-allow-typing-names-much-faster-2.html Posts#15 and #17

 

[sunilbsrv2k]

https://www.extendoffice.com/documents/excel/2401-excel-drop-down-list-autocomplete.html

https://www.mrexcel.com/forum/excel-questions/851544-allow-typing-names-much-faster-2.html Posts#15 and #17

Hi Jaffar,

Thanks for this wonderful code.


This is awesome.

However, if I have multiple columns, then is it possible to change the column to the required ones without opening the VBA code.

I mean, can list range be changed to any of the columns.

Thanks