Check the help for InStr(). Or here . InStr ([start, ] string1, string2 [, compare ] ) 如果指定了compare,则必须使用start参数. The start argument is required if compare is specified.因此省去compare参数,或提供start.So leave out the compare argument, or supply start.并且您混合了字符串参数(我也经常需要提醒自己正确的顺序).And you have the string arguments mixed up (I need to remind myself of the correct order pretty often too). string1-必需.正在搜索字符串表达式. string2-必填.寻找字符串表达式. string1 - Required. String expression being searched. string2 - Required. String expression sought.所以你想要englishResult = InStr(1, englishReasonsToGoToSecondFloor, rowValue, vbTextCompare) 这篇关于我的InStr不断告诉我它不匹配的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!
09-14 08:17