Keyboard shortcuts

[Voodoodan]

Hi,

Does anyone know how I can create a keyboard shortcut, say Ctrl+J and
Ctrl+L, so that I can insert a tick or cross via the Windings font
(alt+0252, alt+0251) in a worksheet, please?

Thanks,
Dan.

 

[Ron de Bruin]

If you use your macro recorder you get this

Sub Macro1()
With Selection.Font
.Name = "Wingdings"
End With
ActiveCell.FormulaR1C1 = "ü"
End Sub

Assign a shortcut to the macro in the Alt-F8 dialog(options)

 

[Voodoodan]

Perfect!!

Thanks Ron.