Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to read sign "/" on the textbox?

Posted on 2011-09-08
3
Medium Priority
?
341 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:Whing Dela Cruz
  • 2
3 Comments
 
LVL 49

Accepted Solution

by:
Martin Liss earned 2000 total points
ID: 36506931
Dim strParts() As String

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

strParts(0) is "ab"
strParts(1) is  "cd"
etc
0
 
LVL 49

Assisted Solution

by:Martin Liss
Martin Liss earned 2000 total points
ID: 36506953
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
 

Author Closing Comment

by:Whing Dela Cruz
ID: 36507198
Thanks! Its working....
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question