Changing value of a label

OK say I have a label that is currently containing a value C102
but I want to extract that data Add 1 to it so it is now C103.

I would probably want to take only the 2-4 char's of the label which are number, and do 102+1 = 103 and then do label = "C" & (new value(103))

How would I go about doing that, I'm a little rusty when it comes to doing this.


even pointing me in right direction might help me remember the code.

Thanks

VB Code:

Private Sub Command2_Click()
    Label1.Caption = "C" & Val(Mid(Label1.Caption, 2, Len(Label1.Caption) - 1)) + 1
End Sub

:eek: that was ugly coding :)

VB Code:

Label1.Caption = "C" & Format(Mid(Label1.Caption, 2) + 1)

...and that was one of a few I could have answered...

...........if only I was faster

;)

Thanks, it was the Val command that I was trying to remember, It works, I remember you could set it up with left, mid, right I think. But Thanks again.
This is why I love this place quick responses.