View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default Shortcut Key --- A Challenge

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....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...x2k.htm#mykeys


---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


"Deepak" wrote in message ...
I want to use CTRL+Z to pull up Insert Function Dialog window..


People its a challenge to me
Plzzzzzzzzzzzzzzzzzzz Help