Only numbers in a textbox

Hi,

Is there a way for me to limit the type of characters I can put in a textbox?

I'd like to only be able to put numbers in the textbox; no letters, symbols or spaces.

Thanks

What type of textbox? On a userform or a worksheet?

userform mate...i just came up with a sort of solution (only because it was an 'on error do this' solution). but I'd still like to know how to do this, because i've seen it done before.

Well there are various ways.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

thankyou very much, you're help is appreciated greatly.