Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Given I haven't received any response I assume that my original post (quoted below) was
not clear so I'll attempt to re-phrase the question. How can I execute a macro when the user hits the "+" sign on the numeric keypad? Original post; I'd like call a macro (to re-position the cursor) when the "+" sign is pressed on the numeric keypad. After looking through the help and "playing around", the closest I can come is using an "OnKey" statement but I can't get it to; a) recognize the keypad "+" b) call a macro, *even* when I give it a key that it can recognize. ex, using the keyboard "+" sign. I tried putting the Application.OnKey "{+}", "macroname" in a workbook open event and in the Workbook module I put the "macroname" sub. (The close event resets the key.) What I get is "filename!macroname not found" (at least I know it's re-assigned the key!) So I have two problems (not to mention my lack of understanding) 1st - I'm not structuring the logic correctly (it can't locate the macro) and, 2nd - I have no idea what the code is for the keypad "+" sign. Direction? -- Regards; Rob ------------------------------------------------------------------------ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro to delete lines based on a value - Repost | Excel Discussion (Misc queries) | |||
Calling a macro from a key | Excel Programming | |||
Calling Macro by different TextBoxes | Excel Programming | |||
Macro to Delete - repost | Excel Programming | |||
Calling macro in add-in. | Excel Programming |