Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a check to allow user to input numerics from the numeric pad
Private Sub txtZip_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, _
ByVal Shift As Integer) ' Pass through only digits. If KeyCode < 48 Or KeyCode 57 Then KeyCode = 0 Beep End If ' As I found out the numerics from the numeric pad range from 0x60 to 0x69 ' Could someone show me how to set up a valid check for them ? If KeyCode < "0x60" Or KeyCode "0x69" Then KeyCode = 0 Beep End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a user input query so it can be added on the switchboard? | Excel Discussion (Misc queries) | |||
Check user input | Excel Programming | |||
check is input textboxes is numeric on userform | Excel Programming | |||
Check a user-input value against a list of values? | Excel Programming | |||
create a user input form | Excel Programming |