Automatically inserting symbols  
Author Message
KatherineG





PostPosted: Fri Nov 14 07:17:35 CST 2003 Top

Excel Misc >> Automatically inserting symbols

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

Excel88  
 
 
BrianB





PostPosted: Fri Nov 14 07:17:35 CST 2003 Top

Excel Misc >> Automatically inserting symbols
Here's a macro to do the job:-
'---------------------------------------
Sub TICK()
ActiveCell.Value = Chr(252)
With ActiveCell.Font