Find the code that similar with data base

**yukioh** · 02-01-2013, 02:51 AM

Hi all friend

please help me

**HaHoBe** · 02-02-2013, 06:22 AM

Hi, yukioh,

maybe something like this can get close to what you want:

Please Login or Register  to view this content.

Ciao,
Holger

**yukioh** · 02-03-2013, 04:39 AM

Thank you for your help HaHoBe,
your code is working, now i try to run it, and it see some duplicated code,
it is possible that when i changed word "PENSION" then code still working like i change "PENSION" to "EMPLOYEE" or other words...

**HaHoBe** · 02-03-2013, 04:50 AM

Hi, yukioh,

you could use the split function if there will always be something you don´t want to search for as first item in the cell and work the array like used in

Please Login or Register  to view this content.

except that you start the loop with either 0 or LBound(var). If you use 1 you could put in any item you want and need not care for the name or the length of the item but may loose a search if nothing preceeds the company name.

Ciao,
Holger

**yukioh** · 02-03-2013, 05:55 AM

How to do HaHoBe
i don't know much about VBA

**HaHoBe** · 02-03-2013, 07:24 AM

Hi, yukioh,

you may alter the code like this

Please Login or Register  to view this content.

And if you are a bit curious about a different way to maybe solve the problem you may have a look at Searching Using Soundex Codes and the demo workbook.

Ciao,
Holger