Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit input in a textbox
Hello NG,
I need to limit the input in a text box via the Key_Press event in VBA. I'm accepting input for hexadecimal to be converted to Decimal and Binary but I only the user to be able to input 0-9,a-f and A-F. I can get a limit with using If KeyAscii <48 OR KeyAscii 57 then KeyAscii = 0 This works but only for one set, either numbers or small letter or Caps, but not all. Does anyone know how to make a set of character to use, something like (0123456789abcdefABCDEF) Any help would be greatly appreciated. Thanks Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit input in a textbox
Jim
Try Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Select Case KeyAscii Case 48 To 57, 65 To 70, 97 To 102 Case Else KeyAscii = 0 End Select End Sub Tony -----Original Message----- Hello NG, I need to limit the input in a text box via the Key_Press event in VBA. I'm accepting input for hexadecimal to be converted to Decimal and Binary but I only the user to be able to input 0-9,a-f and A-F. I can get a limit with using If KeyAscii <48 OR KeyAscii 57 then KeyAscii = 0 This works but only for one set, either numbers or small letter or Caps, but not all. Does anyone know how to make a set of character to use, something like (0123456789abcdefABCDEF) Any help would be greatly appreciated. Thanks Jim . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit input in a textbox
ACW and Robin,
Thanks for the tips, I got it to work with the CASE version, but I have another text box that the InStr ver will work with better. Thanks again, you saved me a big headache ;-) Jim "Robin Hammond" wrote in message ... If you have the rest of the code working, something like this should do it If InStr("0123456789abcdefABCDEF", Chr(keyascii)) 0 Then MsgBox "valid character found" End If -- Robin Hammond www.enhanceddatasystems.com Check out our XspandXL add-in "James Agostinho" wrote in message ink.net... Hello NG, I need to limit the input in a text box via the Key_Press event in VBA. I'm accepting input for hexadecimal to be converted to Decimal and Binary but I only the user to be able to input 0-9,a-f and A-F. I can get a limit with using If KeyAscii <48 OR KeyAscii 57 then KeyAscii = 0 This works but only for one set, either numbers or small letter or Caps, but not all. Does anyone know how to make a set of character to use, something like (0123456789abcdefABCDEF) Any help would be greatly appreciated. Thanks Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show the input message of a data validation list on a textbox and set editable | Excel Discussion (Misc queries) | |||
Character limit in textbox | Excel Worksheet Functions | |||
excel input mask for textbox | Excel Discussion (Misc queries) | |||
Validy check in one coulmn to limit input options in another? | Excel Worksheet Functions | |||
Limit character input | Excel Programming |