A
ajliaks
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
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