Character Map Shortcuts, How To

[Kent]

For Excel users the character map is found way way out in the back 40 i
Start/Programs/Accessories/System Tools/Character Map. Once there I ca
choose a symbol then copy and paste to my worksheet. There must be a
easier way to grab a fraction or other symbol that doesn't have
keyboard shortcut assigned to it. In MSWord the Character Map is foun
in Insert/Symbol and is real easy to use (compared to Excel). (1) I
there a way to get a shortcut to the Character Map on the toolbar i
Excel? (2) Where can I find a llst of keyboard shortcuts for th
fractions and math symbols shown in the character map? (3) Is there
way to create user assigned keyboard shortcuts to symbols shown in th
Character Map

 

[Jason Morin]

MVP Chip Pearson has a free add-in called "Symbolizer"
that you can download. It's the Excel equivalent of
MSWord's Insert > Symbol.

www.cpearson.com/excel/chars.htm

HTH
Jason
Atlanta, GA

 

[Gord Dibben]

Kent

Place this macro in your Personal.xls then add a button to your toolbar to run
it.

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

If need help with macros and coding post back or see David McRitchie's
"getting started with macros" site.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Gord Dibben Excel MVP