Parse text from string

[Av8tordude]

I have a userform label that will display price & percentage ...i.e. -$408.66 (-14.29%). Can someone assist in parsing out only the percentage (i.e. -14.29%) from the string so I can input it into a cell.

Thank you kindly

 

[Fluff]

How about

   Range("L1") = Left(Split(Me.Label1, "(")(1), Len(Split(Me.Label1, "(")(1)) - 1)

 

[Av8tordude]

Exellent...Thank you very much Fluff. Greatly appreciate the help and the quick response. Cheers!

 

[Fluff]

Glad to help & thanks for the feedback