Integer only textbox?
 

Can I set a textbox (on a form) to accept only integer values? If so
how?
TIA

Integer only textbox?
 

Create an _AfterUpdate() routine for your text box and then check if
its an integer in your code.



wrote:
Can I set a textbox (on a form) to accept only integer values? If so
how?
TIA

Integer only textbox?
 

Okay, I was afraid it wouldn't be as simple as a property value.

Thank you.
ImpulseBlue wrote:
Create an _AfterUpdate() routine for your text box and then check if
its an integer in your code.



wrote:
Can I set a textbox (on a form) to accept only integer values? If so
how?
TIA

Integer only textbox?
 

If the tool must use a userform then you are stuck with setting up
events for it, but if you had the input in a cell on a worksheet then
you could use simple Data Validation and set it to only whole
numbers.... just some thoughts


wrote:
Okay, I was afraid it wouldn't be as simple as a property value.

Thank you.
ImpulseBlue wrote:
Create an _AfterUpdate() routine for your text box and then check if
its an integer in your code.



wrote:
Can I set a textbox (on a form) to accept only integer values? If so
how?
TIA