is there no way wer i can assign a number as a keystroke shortcut for a macro??
eg Ctrl+1 or Ctrl+2 like this??
because my macros add the values 1to7 to a particular cell, it ll only be easy if i assign a number as shortcut. so please help
is there no way wer i can assign a number as a keystroke shortcut for a macro??
eg Ctrl+1 or Ctrl+2 like this??
because my macros add the values 1to7 to a particular cell, it ll only be easy if i assign a number as shortcut. so please help
How about:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
You could use the .OnKey method
Please Login or Register to view this content.
This example would use Ctrl-2Please Login or Register to view this content.
If this was helpful then please click the small star icon at the bottom left of my post. A little appreciation goes a long way.
it worked but one problem, its not working for the number pad keys.. y is that??
I believe that the number pad keys 0-9 are represented by the. "codes" 96-105.
So,
Would respond to 4 on the keypad.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks