| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
keydown event
I'm trying to create a custom calculator on a userform.
Im using the keydown event in a textbox to capture operators from the num pad on the keyboard. everything works fine except the text value of the operator is added to the textbox. Of course I dont want this to happen. I have tried Onkey method to associate a kestroke to a procedure with no sucess application.onkey "+", "Macro" Does anyone know how to accomplish this or do I need to be more specific on what Im trying to do. TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
keydown event
I got lucky in a search and found what I was looking for
in a post reply from Ron de Bruin... in the keypress event I added: KeyAscii = 0 after the sub I wanted executed. It seems to work now. Thank You... -----Original Message----- I'm trying to create a custom calculator on a userform. Im using the keydown event in a textbox to capture operators from the num pad on the keyboard. everything works fine except the text value of the operator is added to the textbox. Of course I dont want this to happen. I have tried Onkey method to associate a kestroke to a procedure with no sucess application.onkey "+", "Macro" Does anyone know how to accomplish this or do I need to be more specific on what Im trying to do. TIA . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| event vba | Excel Worksheet Functions | |||
| VBA Event | Excel Discussion (Misc queries) | |||
| event | Excel Discussion (Misc queries) | |||
| KeyDown event on form | Excel Discussion (Misc queries) | |||
| OnTime event not firing in Workbook_Open event procedure | Excel Programming | |||
Hybrid Mode
