Shortcut Key --- A Challenge

[Deepak]

I want to use CTRL+Z to pull up Insert Function Dialog window..


People its a challenge to me
Plzzzzzzzzzzzzzzzzzzz Help

 

[David McRitchie]

Ctrl+Z is undo, that would be a very bad choice
see shortcuts http://www.mvps.org/dmcritchie/excel/shortx2k.htm

Alt+I+F does what you want

You can install the following macro to bring up the Function Wizard
to install see http://www.mvps.org/dmcritchie/excel/getstarted.htm#havemacro
Sub FxWizard()
Application.Dialogs(xlDialogFunctionWizard).Show
End sub

To assign your own shortcut key to a macro see http://www.mvps.org/dmcritchie/excel/shortx2k.htm#mykeys