input numeric values only on textbox

**stoey** · 03-05-2009, 01:19 PM

hi,

anyone knows who can restrict the input values to numeric values only? I have 2 textboxes where the user enters employee id and numeric choice value of 1,2 and 3...I need help in making the textboxes restricted to numeric values input only. Please help me in preventing the users from entering alpha and symbols values. I appreciate any response. Thanks

Stoey

**smited01** · 03-05-2009, 01:37 PM

Do you need to use a testbox? You can do this quite easily in a cell using Data validation.

If you must use a textbox you could probably test the contents with IsText or IsNumber or IsNonText functions.

**royUK** · 03-05-2009, 01:45 PM

Is this on a userform?

**stoey** · 03-05-2009, 01:46 PM

hi,

thanks for responding...currently i have a userform which has 2 textboxes...one for entering employee id and one for entering numeric choice values of 1,2 and 3....do you an idea how to do this using macro?

thanks,

stoey

**Krishnakumar** · 03-05-2009, 02:05 PM

Hi,

Try

Please Login or Register  to view this content.

**stoey** · 03-05-2009, 02:18 PM

hi there,

thanks for the coding...it worked however, when i enter values with zero, it doesn't work....employee ids have zero values when being entered...my employee ids contains 5 digits (some includes zero number like 60740)...any idea how i can include the zero number on the set of keyascci?

thanks,

stoey

**stoey** · 03-05-2009, 02:24 PM

hi again,

thanks kris...the code you provided work well now...i change the asci value to 48 which is equals to zero...now i can use zero values on the employee ids...thanks again... however i have another problem which i think it needs to be posted on another thread...thanks a lot again.

stoey