KeyBindings like Word.

M

Moshe

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
 
M

Myrna Larson

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.
 
Top