View Single Post
  #2   Report Post  
Myrna Larson
 
Posts: n/a
Default

I believe you need to create a macro that shows that dialog, and attach your
shortcut key to the macro. The macro needs just a single line

Sub ShowCFDialog()
Application.Dialogs(xlDialogConditionalFormatting) .Show
End Sub

Then in Tools/Macro/Macros, select this macro, click the Options button to
assign the shortcut key.

On Wed, 9 Feb 2005 00:49:41 -0800, "Moshe"
wrote:

Hello,

I would like to use KeyBindings in Excel like we have
in Word. My purpose is creating a shortcut (e.g Ctrl+J)
for a command in Excel (e.g FormatCondition).
In other word, each time I will press Ctrl+J i will run
the FormatCondition dialog will appear.

Is there any way to do it ?

With thanks,
Moshe