Form - Changing Range by SpinButton
Hi
I want to change the Range.Value by SpinButton but it doesn't work
What can be the problem?
Private Sub SpinButton1_SpinUp()
Counter.Value = Counter.Value + 0.5
Label17.Caption = Label14.Caption - Counter.Value
Sheets("List3").Range("F2").Value = Val(Label17.Caption)
' This alternative also doesn't work
' TextBox2.Value = TextBox1.Value + Counter.Value
End Sub
The procedure changes Label.caption but doesn't change the textbox.value
Are there any form sample macros available on the internet?
Thanks for the tips
|