Restrict values in userform boxes

[Kriptik]

I have a userform for auditing doctor performance based on an existing tool. I have 12 criteria that all need to be marked either 0,1 or 2. I know how to do this in excel using data validation but how do I it in a userform. I'm new to this and the form I have developed works but I cant guarantee the auditors will put in the right values.

Thank you in advance

 

[MickG]

Try this:-

Private [COLOR="Navy"]Sub[/COLOR] TextBox1_KeyPress(ByVal KeyAscii [COLOR="Navy"]As[/COLOR] MSForms.ReturnInteger)
 KeyAscii = KeyAscii * -CLng(Chr(KeyAscii) Like "[0-2]")
 TextBox1 = Left(KeyAscii, 0)
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Regards Mick

 

[Kriptik]

Brilliant

Thank you very much