Link to home
Start Free TrialLog in
Avatar of Flora Edwards
Flora EdwardsFlag for Sweden

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
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

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.
Avatar of Flora Edwards

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
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
best solution.

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