Integer only textbox?

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

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



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

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.
>
>
>
> [email protected] wrote:
> > Can I set a textbox (on a form) to accept only integer values? If so
> > how?
> > TIA

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


[email protected] 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.
> >
> >
> >
> > [email protected] wrote:
> > > Can I set a textbox (on a form) to accept only integer values? If so
> > > how?
> > > TIA