In this code, I'm trying to check if the input entered by user (txtList) can be found in a list of data (txtList). The following code returns 0 (substring not found although "John Ho" and "Ho Tee Nee, John" is the exact same person. Can someone please enlighten me on how to resolve this? In this code, I'm trying to check if the input
阅读背景：
虽然substring有效，但Excel VBA InStr返回0
来源：互联网
分享到：
