Text Boxes

[k209310]

On a text box on a userform is there any way to restrict the user to enteronly numerical values and possibly a . (decimal) using VBA?

 

[Fizzio]

A few ways
- Set the field format to single / double in the table
- Set the validation format for the control in form design eg >0 for instance
- Use the isnumeric(me.nameofcontrol) method in the before_Update procedure of the control.

The choice, as they say, is yours