PDA

View Full Version : How to identify method for an assigned shortcut?



chandansify
11-13-2011, 09:10 PM
Hi,

Is there a way to findout the method name via it's shortcut key?

Details:
e.g. A shortcut key Ctrl+Alt+F9 is assigned to an unknown function.

I want to change the functionality but I really don't know the target code? Is there a way in Excel VBA to find out the target method name using it's shortcut keys?

Thanks in advance.

CB

Aflatoon
11-14-2011, 02:39 AM
If you mean built-in shortcuts, then you can't change their code functionality, you can only point the shortcut key combination at another routine of your own.

mdmackillop
11-14-2011, 12:35 PM
Try using the macro recorder. For Ctrl+Alt+F9 I get
Sub Macro1()
'
' Macro1 Macro
'

'
Application.CalculateFull
End Sub

chandansify
11-14-2011, 10:34 PM
If you mean built-in shortcuts, then you can't change their code functionality, you can only point the shortcut key combination at another routine of your own.

Nope, I mean shortcuts pointing to custom method.

chandansify
11-14-2011, 10:39 PM
Try using the macro recorder. For Ctrl+Alt+F9 I get
Sub Macro1()
'
' Macro1 Macro
'

'
Application.CalculateFull
End Sub


This was just an example.

e.g. What if someone has assigned a shortcut to ABC method using Application.OnKey and I am not aware of it.

Now, how to findout that ABC method using that shortcut via VBA?

mdmackillop
11-15-2011, 02:07 AM
Did you try it? What was the result?

chandansify
11-15-2011, 06:13 PM
Did you try it? What was the result?

Hi,

This doesn't help in my case as I have already mentioned that I have to do this via VBA and not by recording a macro.

Thanks.