I want to use a Function Key to start a VBA

[geno32080]

Good Morning Team Excel,
I have a spread sheet set up with command buttons to run different tasks, Is there a way to set function keys to trigger those command buttons? IE F2. The idea is to be able to navigate thru the sheet without using the mouse.
Thank you

 

[SanjayGMusafir]

Good Morning Team Excel,
I have a spread sheet set up with command buttons to run different tasks, Is there a way to set function keys to trigger those command buttons? IE F2. The idea is to be able to navigate thru the sheet without using the mouse.
Thank you

You can assign keyboard shortcut to a macro to run. But assigning a function key can cause some malfunctioning in the system as "F2" key is a pre-assigned key

 

[6StringJazzer]

It is easy to use CTRL combinations for a macro, that's built in. Go to the Developer panel, Macros, select a VBA Sub name, then Options to set a CTRL shortcut.

But using function keys is going to require something much more complicated, I think. You would have to trap key press events, and look for those function keys then call the desired Sub from there. I'm not even sure you can capture functions keys. I've never done it and cannot find anything in a search to indicate what codes it would return.