Hi

I need to input data in percentage format, like this: 50.5%

Which code can I use? I also want to prevent user of inputing wron
data.

Private Sub PercentTB_KeyPress(ByVal KeyAscii A
MSForms.ReturnInteger)
If ((KeyAscii < Asc("0")) Or (KeyAscii Asc("9"))) Then
If (KeyAscii < 0) Or (KeyAscii 1) Then
KeyAscii = 0
End If
End If
'MsgBox PercentTB.Value
End Su

--
Message posted from http://www.ExcelForum.com