Dim b As Integerb = InputBox("输入要查找的数")For i = 0To UBound(A)If A(i)=b Then Msgbox "找到数" & b & "了,在数组索引第" & i & "的位置"End IfNext i这样就可以了,你可以把这个代码写个函数来获取返回值。
用Scripting.Dictionary对象吧Private Sub Command1_Click()Dim Dic As New Scripting.DictionaryDic.Add "XX", 0Dic.Add "YY", 0Dic.Add "ZZ", 0If Dic.Exists("ZZ") Then Print "Fi