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