I'm using a spin button on a userform to alter an existing value (Label11) through a textbox. What I would like is to set a condition for Label27 so it can have any value as long as it's above 0 (zero).
Example:
Label27 value is 270 = Label27 value is 270
Label27 value is -22 = Label27 value is 0
[VBA]Private Sub SpinButton1_Change()
Me.TextBox1 = Format(Me.SpinButton1.Value)
Label27 = Label11 + CDbl(TextBox1.Value)
End Sub[/VBA]
Appreciate some help here...