给你,看看:
Option Explicit
Public Sub TestMe()
Dim arrInput As Variant
Dim varVar As Variant
Dim lngCounter As Long
arrInput = [{"100 mt/h","m3/t","S/C","0/700","0/25","5/31","43/47","700/1000"}]
For Each varVar In arrInput
Debug.Print varVar
Debug.Print blnCheck2Integers(varVar)
Debug.Print "------------------------------"
Next varVar
End Sub
Public Function blnCheck2Integers(ByVal strInput As String, _
Optional strDelim = "/") As Boolean
Dim arrTemp As Variant
arrTemp = Split(strInput, strDelim)
If UBound(arrTemp) <> 1 Then Exit Function
blnCheck2Integers = IsNumeric(arrTemp(0)) And IsNumeric(arrTemp(1))
End Function
按“/”拆分,然后检查这两个值是否为数字。如果值不是2,则返回false。这是控制台中的结果:
100 mt/h
False
------------------------------
m3/t
False
------------------------------
S/C
False
------------------------------
0/700
True
------------------------------
0/25
True
------------------------------
5/31
True
------------------------------
43/47
True
------------------------------
700/1000
True
------------------------------