[ask] auto validation match finder

[sitropoticus]

i have searching in this forum with keywords: data,validation,auto,fill and doesn't met any thread that fulfill my needs, so i post my own question...

i have a very large database of people's name and i have made my own expendable validation without a macro; but i want to make a macro that could pop-up my user forms (this user form is used to show any suggestions when i start typing; i.e. when i type "A" then comes a list of suggestions such as: "Andy", "Arnold", and so on the name that starts with "A")

ps: i've seen all the data validation tricks from this site; still; it doesn't match my needs...
could anybody help, please...?

best regards
sitropoticus
​

 

[sitropoticus]

please.....

 

[sitropoticus]

*bumping*

 

[sitropoticus]

i've just upload my example screenshot about my question
i want when i start typing "A" in "Insert Name" tab, then the "Suggestions" tab will display my list of choices so i can find and click any name ( it is also sorted A to Z )

hope it will help you to understand my question, because i'm not sure if my english was right...

best regards,
Sitropoticus​

 

[sitropoticus]

i have a very large database of people's name and i have made my own expendable validation without a macro; but i want to make a macro that could pop-up my user forms (this user form is used to show any suggestions when i start typing; i.e. when i type "A" then comes a list of suggestions such as: "Andy", "Arnold", and so on the name that starts with "A")

i'm asking the wrong question...
i need a macro to lookup any value i input in my "Insert Name" tab from cell A2 - A9, sort it A to Z, and also remove any duplicates available...

sorry if it's confusing you guys, thanks...

best regards,
sitropoticus​

 

[sitropoticus]

*bumping*

 

[sitropoticus]

bumping

 

[sitropoticus]

please

 

[sitropoticus]

please

 

[sitropoticus]

help please...