And if you want the same effect, but without a macro:
flying window key - r (to show the windows start button|run dialog)
type
charmap
and hit enter.
Gord Dibben wrote:
The Character Map can be brought up in Excel.
Not as nice as Chip's add-in or the InsertSymbol with 2002 and beyond.
Sub CharMap()
Dim taskID As Variant
On Error Resume Next
taskID = Shell("start charmap.exe")
If Err < 0 Then _
MsgBox "CHARMAP.EXE is not installed on your machine."
End Sub
Assign to a button or shortcut key.
Gord Dibben Excel MVP
On Wed, 13 Apr 2005 16:12:21 -0500, Dave Peterson
wrote:
MS added it in xl2002.
But Chip Pearson has a couple of versions (depending on what you're running) at:
http://www.cpearson.com/excel/download.htm
(look for Symbolizer and make sure you get the correct version)
KKilpatrick wrote:
There is currently no easy way to insert a symbol such as a degree sign in
Excel. It would be much easier to have a function like Insert Symbol from
Word to do this as one is typing rather than cut & paste from Word or using
the Character Map from Windows (outside of Excel).
--
Dave Peterson