VBA Form and Label Question

[UpTheArgyle]

Hi

I have a text box displaying balance (which is 50)
When a button is clicked i want the balance to reduce by 5
I just cant seem to make this happen!

Can someone give me the code to reduce the balance by 5 and display is in the text box please?

Private Sub UserForm_Activate()

Dim balance As Integer
balance = 50
txtbal.Text = balance

End Sub


Private Sub cmdstart_Click()

???????????????????????????????

End Sub



Thanks Very Much !

 

[mikerickson]

TextBox1.Text = Val(TextBox1.Text) - 5

 

[UpTheArgyle]

Perfect !! thanks very much indeed