Only accept integers in a text box with linked spin button

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

Please Login or Register  to view this content.

Any help would be greatly appreciated. Thanks!

Hi nathansav,

The code above was from something else I got help with about a month ago, thread here:

http://www.excelforum.com/excel-prog...ric-input.html

I'm now working on something different that can only accept integers (whereas the previous application could handle any numerical input).

I've tried Int() and CInt() to overwrite the text box after all the other conditions have been fulfilled but I can't figure it out.

Many Thanks

Assuming you have your global variable called prevvalue already setup in a module, you can use this code to do what you're looking for:

Please Login or Register  to view this content.

^That's great thanks. I put an extra argument in to reject negative numbers (sorry, forgot to mention that) and it works a treat. Many Thanks