Spin Button linked to text box needs to only accept numeric input

[TPDave]

Hi All,

I have a form with a text box that can either be typed into or controlled with a spin button, I have the following code for the spin button to align the two items:

Please Login or Register  to view this content.

This works fine for numbers (you can type a number and then increase or decrease it with the buttons or overwrite a number reached with the buttons) but if you accidentally hit any other key on the keyboard or delete the number in the text box I get an error and am thrown back into the VBA editor. Obviously I need this to be a little more robust for the end users so would appreciate any help in getting the code to ignore text input and allow the number in the text box to be deleted without breaking the form.

Thanks

[nathansav]

ISNUMERIC will check that its a numeric value

[TPDave]

Hi Nathansav,

How would I incorporate that into the code? I'm a complete VBA n00b!

[nathansav]

I would personally do it in a way where i have the previous value taken to a variable

Please Login or Register  to view this content.

[TPDave]

Thanks nathansav!

I played around a bit and used the following:

Please Login or Register  to view this content.

The only issue is the error box comes up twice if a letter is typed, i'll have to figure that out separately though.

[nathansav]

may be beacuse you will always have nothin in prevvalue, you need to put the check for me.rejectedbox.text<>"" in the change and also set the prev value to be me.rejectedbox.text, like mine prevvalue = Me.TextBox1.Text

[TPDave]

Aah, gotcha. Thanks