Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello NG,
Please tell me why the sendkeys statement does not work here in my code. Also, why is it that when I press backspace it does not trigger the keypress event even though the help file said that it will trigger the event. TIA Jon-jon Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Select Case KeyAscii Case 48 To 57 'Nos 0 - 9 Exit Sub Case Else Application.EnableEvents = False SendKeys "{BACKSPACE}", True Application.EnableEvents = True MsgBox "Please enter numeric character only." End Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
event vba | Excel Worksheet Functions | |||
VBA Event | Excel Discussion (Misc queries) | |||
event | Excel Discussion (Misc queries) | |||
Which cell was the activecell before a keypress | Excel Worksheet Functions | |||
Event Question | Excel Programming |