Automatically inserting symbols

  • Thread starter Thread starter Louise
  • Start date Start date
L

Louise

Dear all

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?

Thanks.

Louise
 
Here's a macro to do the job:-
'---------------------------------------
Sub TICK()
ActiveCell.Value = Chr(252)
With ActiveCell.Font
.Name = "Wingdings"
.Size = 10
.Bold = True
End With
End Sub
'----------------------------------------
 
Back
Top