【开源】【原创】判断某个数据在数组中是否存在

阿杰

<font face="Verdana">Dim a(4)<br/>&nbsp;&nbsp;&nbsp; a(1) = "阿杰"<br/>&nbsp;&nbsp;&nbsp; a(2) = "马大哈"<br/>&nbsp;&nbsp;&nbsp; a(3) = "张三"<br/>&nbsp;&nbsp;&nbsp; a(4) = "小王"<br/>&nbsp;&nbsp;&nbsp; If InStr(Join(a, "&nbsp;&nbsp; "), "马大哈") &gt; 0 Then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MsgBox "存在"<br/>&nbsp;&nbsp;&nbsp; Else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MsgBox "不存在"<br/>&nbsp;&nbsp;&nbsp; End If<br/>'结果:存在</font>

有心人

不用循环，真好！

everyone

<p>其实instr最终实现方式还是循环，枚举</p>
<p>只不过这样做写出来的代码看着清爽一些而已</p>

dabian001

如果是2维数组杂办?

马大哈

<p>可能就要老实地遍历了吧....</p>