Hi All,

I have a linked text box and spin button on a userform so the user can enter text or use the buttons and I'm having trouble barring non-integer inputs! Here's what I have so far:

Text box = NumberBox
Spin button= NumberSpin

Private Sub NumberBox_Change()

If IsNumeric(Me.NumberBox.Text) Then
Me.NumberSpin.Value = Me.NumberBox.Text
ElseIf Me.NumberBox.Text = "" Then
Me.NumberSpin.Value = False
Else
    MsgBox "Qty must be a whole number"
    Me.NumberBox.Text = prevvalue
    

End If
End Sub


Private Sub NumberSpin_Change()

If IsNumeric(Me.NumberBox.Text) Or Me.NumberBox.Text = "" Then
    Me.NumberBox.Text = Me.NumberSpin.Value
    Else
    prevvalue = Me.NumberBox.Text
End If

End Sub
Any help would be greatly appreciated. Thanks!