I have created an Excel worksheet (97) and need to enter
a "tick" in several cells. In Word, you can apply a
short-cut to a symbol so you can enter it quickly but I
can't find a similar function in Excel. Is it possible
to use shortcuts and, if so, how do you create them?
Excel Misc >> Automatically inserting symbols
Here's a macro to do the job:-
'---------------------------------------
Sub TICK()
ActiveCell.Value = Chr(252)
With ActiveCell.Font