Public Fuction GetStrReNum(SrcStr As String,FindStr as string)as long
Dim Num as long
Dim TempPos as long
Num=0
TempPos=1
Do
TempPos=InStr(TempPos,SrcStr,FindStr)
If TempPos=0 then exit do
Num=Num+1
Loop
GetStrReNum=Num
End Function
Dim Num as long
Dim TempPos as long
Num=0
TempPos=1
Do
TempPos=InStr(TempPos,SrcStr,FindStr)
If TempPos=0 then exit do
Num=Num+1
Loop
GetStrReNum=Num
End Function
dim astr() as string
dim i as long astr=split(str,"|")
i=ubound(astr)-1 *****这个就是啦!
所以不需要-1