Textbox input limitations on userform

[kellem80]

Hi,
I have a userform with 2 text boxes for users to complete. one should contain a numerical value, the other should contain the user's initials.
Is there a way to limit the entry to the text boxes so that it will only accept numbers for the numerical entry and only accept letters for the entry of the initials?
Also, when dumping the data is there a way to ensure the intitial are dumped as caps no matter how the user enters their initials?
current code to dump data is:

ws.cells(irow, 14).Value = Me.BAtxt.Value

I also have code in to make sure the text boxes are not empty, I don't want to mess with that code either.

Thanks!
Kelle

 

[Tinbendr]

Take a look at this page.

For letters, use "a" and "Z", then use UCase(Textbox1.Value) to push it to uppercase.