Character Map Shortcuts, How To

K

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top