Alternative activation to mouse click

[Trident1]

I work an awful lot in MS Excel and use a considerable amount of macros, a lot of which are assigned to buttons.

Can someone please advise me how to enable the user to activate the button by pressing the return key as well as clicking on the button with the mouse?

 

[KenWright]

Do you mean assigning shortut key combos to the macros?

If so then do Tools / Macro / Macros, select the Macro and then hit the Options button on the dialog box. Now put in whatever key combo you want, and you can use keys such as SHIFT in conjunction with other keys etc.

Regards
Ken...........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[Trident1]

Hi Ken
Thanks for your reply but no...I don't think so!

What I am talking about is ....If you take a Yes/No option, like Do you want to save changes?, Microsoft have the Yes button highlighted so if you press the return key it will assume yes. Alternatively you can click the Yes key with the mouse.

I'm just wondering if I can do that in VB....