asked on how to do this Excel search box Soundex Search
i have downloaded the attached file from https://optionexplicitvba.com/2013/05/04/the-excel-lab-soundex-search/
i need help with modification of this, so that instead of this box and chart, i just have a search box and when i type something it gives me the list of possible soundex match and then once i click on the desired one, it just puts that value in my search box.
i hope this is easy.
soundex.xlsm
i need help with modification of this, so that instead of this box and chart, i just have a search box and when i type something it gives me the list of possible soundex match and then once i click on the desired one, it just puts that value in my search box.
i hope this is easy.
soundex.xlsm
Microsoft ExcelVBAMicrosoft Office
Last Comment
Martin Liss
So right now on the sheet you have a textbox, a listbox and a chart. I understand that you want to remove the chart but I'm not sure of what else you want to do. Are you saying that for example if you typed "win" in the textbox and then you selected "Edwin" from the listbox, that you want "Edwin" to replace the "win" in the textbox?
I just saw that you have a couple of userforms, so I guess I need a better explanation of what you want to have happen.
ASKER
sorry Martin for confusion.
i have attached clean copy without user forms.
here is a gif link that shows what i need.
http://gph.is/2noKGOf
soundex.xlsm
i have attached clean copy without user forms.
here is a gif link that shows what i need.
http://gph.is/2noKGOf
soundex.xlsm
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
best solution.
thanks Martin.
thanks Martin.
You're welcome and I'm glad I was able to help.
If you expand the “Full Biography” section of my profile you'll find links to some articles I've written that may interest you.
Marty - Microsoft MVP 2009 to 2016
Experts Exchange MVE 2015
Experts Exchange Top Expert Visual Basic Classic 2012 to 2016
If you expand the “Full Biography” section of my profile you'll find links to some articles I've written that may interest you.
Marty - Microsoft MVP 2009 to 2016
Experts Exchange MVE 2015
Experts Exchange Top Expert Visual Basic Classic 2012 to 2016