Changing value of a label

[Inimicum]

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

[peet]

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

that was ugly coding

[Mc Brain]

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

[Ping]

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

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

[Inimicum]

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.