How to read sign "/" on the textbox?

I have textbox name text1.text it has a words "ab/cd/mm s/"  i want to read them separately.How? My point is i want to read the text separately by slush "/" is it possible?

Private Sub Command1_Click()
Dim a As String, b As String, c As String
MsgBox a & vbNewLine & b & vbNewLine & c
End Sub
Whing Dela CruzAsked:
Who is Participating?
 
Martin LissConnect With a Mentor Older than dirtCommented:
Dim strParts() As String

strParts = Split(Text1.Text, "/")

strParts(0) is "ab"
strParts(1) is  "cd"
etc
0
 
Martin LissConnect With a Mentor Older than dirtCommented:
If you have a variable number of slashes then


Private Sub Command1_Click()
Dim strParts() As String
Dim lngIndex As Long

strParts = Split(Text1.Text, "/")

For lngIndex = 0 To UBound(strParts)
    Debug.Print strParts(lngIndex)
Next

End Sub

Open in new window

0
 
Whing Dela CruzAuthor Commented:
Thanks! Its working....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.