May I ask if you are using Excel 2007?
This works fine in the vba editor, but I've never gotten keyboard shortcuts
to work in 2007 on a worksheet.
On a worksheet, the Alt key brings up the shortcut keys on the ribbon.

I've never understood this part of the documentation in Excel 2007.
I've never gotton it to work. Anyone figure it out?
I am "assuming" this is for inserting a character in a cell.

<copy...

Title: "Insert a symbol, fraction, or special character"

Use the keyboard to insert a Unicode character code in a document:

If you know the character code, you can enter the code in your document and
then press ALT+X to convert it into a character. For example, press 002A and
then press ALT+X to produce *. The reverse also works. To display the
Unicode character code for a character that is already in your document,
place the insertion point directly after the character and press ALT+X.

<end of copy

--
Dana DeLouis
Windows XP & Excel 2007


"Joel" wrote in message
...
rick: Character map program will not get you all the characters. Only
printerable chararacter are available. Control character can only be put
in
dociments using the ALT key stroke approach.

"Rick Rothstein (MVP - VB)" wrote:

I almost never found out how to type in special characters on my laptop,
so
I'll pass this along in case others are having the same problem. At
least,
this is the way it works on my Dell laptop.

1. Press and release the NumLock key to turn NumLock on
2. Hold down the Fn+Alt keys
3. Type in the numeric code using the letter keys with the small
numbers
(on my PC, these are blue numbers on the m,j,k,l,u,i,o,7,8 and 9
keys)
4. Release the Fn+Alt keys
5. To resume normal typing, press and release NumLock to turn it off

Or, while maybe not as convenient, you could click Start button, click on
the Accessories item and find the Character Map program in there,
double-click (in order) on the characters you want, then click the Copy
button... you can then paste those characters into your document.

Rick