[ask] auto validation match finder

sitropoticus

New Member
Joined
Mar 12, 2011
Messages
10
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...?
:rolleyes:

best regards
sitropoticus
:)
 
Last edited:

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

sitropoticus

New Member
Joined
Mar 12, 2011
Messages
10
85784571bb09f7ae989b83fa590d330bf08c13f.jpg

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

New Member
Joined
Mar 12, 2011
Messages
10

ADVERTISEMENT

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​
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,991
Messages
5,856,689
Members
431,828
Latest member
kARTIK12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top