troubleshooting Question

Extracting data from a string...HELP!

Avatar of mcanepa
mcanepa asked on
Visual Basic Classic
5 Comments1 Solution159 ViewsLast Modified:
I need to select data from a sting (in a listbox).

The string in the list box is this:
(txtEmployeeName.Text & ":" & vbTab & txtSsn.Text & ":" & vbTab & txtPieceWork.Text)

I need to extract the piecework integer (txtPieceWrk.Text)from the string in order to calculate it with the price.
So far I have this, but I keep getting error messages:
NOTE: PieceWorkPay is a private function.

  strEmplySel = lstEmployee.List(lstEmployee.ListIndex)
    intPieWrk = InStr(1, strEmplySel, ":")

    If intPieWrk > 0 Then
        sngTotal = PieceWorkPay(Mid$(strEmplySel, intPieWrk + 1))
    End If

Please Help!

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros