Number (decimal) delete and backspace

zezo2021

Member
Local time
Today, 06:53
Joined
Mar 25, 2021
Messages
412
Friends
I want to allow the delete and backspace and decimal to this code
If IsNumeric(Chr(KeyAscii)) <> True Then KeyAscii = 0
 
Code:
Private Sub Textbox1_KeyPress(KeyAscii As Integer)
Select Case True
Case IsNumeric(Me.Textbox1.Text & Chr(KeyAscii))
Case Chr(KeyAscii) = "." And InStr(Me.Textbox1.Text & "", ".") = 0
Case KeyAscii = 8
Case Else
    KeyAscii = 0
End Select

End Sub
 
Last edited:
Private Sub Textbox1_KeyPress(KeyAscii As Integer) Select Case True Case IsNumeric(Me.Textbox1.Text & Chr(KeyAscii)) Case Chr(KeyAscii) = "." And InStr(Me.Textbox1.Text & "", ".") = 0 Case KeyAscii = 8 Case Else KeyAscii = 0 End Select End Sub
You are good, i commend your knowledge of VBA
 

Users who are viewing this thread

Back
Top Bottom