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

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

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​
 

Watch MrExcel Video

Forum statistics

Threads
1,123,143
Messages
5,599,975
Members
414,354
Latest member
Flaxarn

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