I WANT TO MAKE keyboard shortcut FOR COMMAND BUTTON
FOR EXAMPLE
WHEN I HIT ON DELETE ON KEYBOARD
IT HIT COMMAND BUTTON ON EXCEL SHEET
THANKS
I WANT TO MAKE keyboard shortcut FOR COMMAND BUTTON
FOR EXAMPLE
WHEN I HIT ON DELETE ON KEYBOARD
IT HIT COMMAND BUTTON ON EXCEL SHEET
THANKS
Have you looked at Application.OnKey?
You can also assign a shortcut via the Macros dialog (Alt+F8). Enter the name of the macro, and press Options to select a shortcut key (Ctrl + letter or number key, or Ctrl+Shift + letter or number key)
Please don't type in all caps.
Entia non sunt multiplicanda sine necessitate
sorry what do you mean by application.onkey
i can't make the code of command button to be macro
could you tell me how to do that
Instead of an ActiveX control, just write a sub in a standard code module:
Then assign a keyboard shortcut as described in the prior post.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks