Private Sub Form_Load()
Dim lReturn As Long
lReturn = InStr(1, "我是中国人", "是")
Debug.Print Mid("我是中国人", lReturn, 1)
End Sub
Dim lReturn As Long
lReturn = InStr(1, "我是中国人", "是")
Debug.Print Mid("我是中国人", lReturn, 1)
End Sub
调试欢乐多
Dim lReturn As Long
Dim sCutStr As String
Dim sFindStr As String
sCutStr = "我是中国人"
sFindStr = "是"
lReturn = InStr(1, sCutStr, sFindStr)
Debug.Print Mid(sCutStr, 1, lReturn - 1) & Mid(sCutStr, lReturn + 1)
End Sub
返回 Variant (Long),指定一字符串在另一字符串中最先出现的位置。
start: 开始的位置
string1: 一字符串
string2: 另一字符串
MyStr=Replace("我是中国人","是")
dim MyStr as string
MyStr=Replace("我是中国人","是","")