Option ExplicitPrivate Sub Command1_Click() Dim Temp(0 To 10) As String Temp(1) = 123 Temp(2) = "str" Temp(3) = 3.14 Temp(4) = 65536 Temp(5) = Me.Caption Dim i As Long For i = LBound(Temp) To UBound(Temp) If Len(Temp(i)) > 0 Then If Not IsNumeric(Temp(i)) Then Debug.Print i & "--->" & Temp(i) End If Next End Sub
再用isnumeric()函数判断
Dim Temp(0 To 10) As String
Temp(1) = 123
Temp(2) = "str"
Temp(3) = 3.14
Temp(4) = 65536
Temp(5) = Me.Caption
Dim i As Long
For i = LBound(Temp) To UBound(Temp)
If Len(Temp(i)) > 0 Then
If Not IsNumeric(Temp(i)) Then Debug.Print i & "--->" & Temp(i)
End If
Next
End Sub