short cut

[fabalicious]

hi there

can anyone tell me where to define the shortcut for a macro/sub (in the
VB editor)? is it possible at all this way?

thanks

fabalicious

 

[Mike Fogleman]

Look at VB help for "OnKey Method".

Mike F

 

[fabalicious]

Thanks.

...that tells me HOW. what I still don't know is WHERE to defin
this!?

 

[Dana DeLouis]

Hello. If I understand your question...
On the Worksheet, hit Alt+F8.
Select your macro from the list.
Click "Options"

You wouldn't be the first to look for the macro shortcut key assignment from
the vba editor. :>)

 

[fabalicious]

nice!
...and straight forward actually. I was looking for it in the editor
sometimes you just don't see the obvious