Insert Unicode? (2002 SP 1)

Topic

New Reply

I know the help wizard wouldn’t lie, but…it says that you can insert a Unicode special character without opening the Insert Symbol dialog by entering the Unicode Character Code followed by Alt+x. While this works in a Word document, it doesn’t work in an Excel cell. Is there any way to do this? or to create a keyboard shortcut for a Unicode character that does not seem to have a keystroke defined. (For example, the euro has a Unicode of 20AC with a keystrok of Alt+0128, this works. The check mark has a Unicode of 2714 but no keystroke, it does not insert using the Alt+x technique described in Help)

Reply | Quote

Replies

There’s no direct way I know of, but Rory clued me to this VBA method.

Reply | Quote

Are you trying to find a way to enter a checkmark character with a shortcut? I don’t even have that character in my Insert…Symbol…unless I use the Wingding font on character:

Reply | Quote

Thanks so much. This macro works and I can create a shortcut to the macro so mission mostly accomplished. I was specifically trying to use the Bold Checkmark. This character is found in symbol under font Ariel Unicode MS Subset Dingbats. I hope I can figure out how to specify the font subset in your macro. How do you get the character count number?

Reply | Quote

I use a little macro in Word to display the number of any character I have selected. It comes in handy when I’m trying to embed an unusual character and need to do it in VB. Here it is:

Sub ShowAsciiCode()
MsgBox Str(Asc(Selection))
end sub

Enter or cut/paste the character in a Word doc, select it, then run this macro. It’ll tell you the number.

Reply | Quote