[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... :sad:

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... :sad:
could anybody help, please...?
:help:

best regards
sitropoticus
:)
 
Last edited:

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
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
 
Upvote 0
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​
 
Upvote 0

Forum statistics

Threads
1,222,143
Messages
6,164,178
Members
451,880
Latest member
2da

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
Back
Top