Length limitation with accepting numeric value in text box - VBA User Form

[MrBaral]

Dear Experts,

How we can set condition for text box of user form that accepts only numeric or alpha-bate values with character limitation like should accept only 10 characters.
Let me know the coding.
Thanks

 

[Norie]

You can set the MaxLength of a textbox to limit the no of characters that can be entered in it but to restrict the type of characters you would need to write code.