Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Apr 2001
    Location
    NOLA
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert Unicode? (2002 SP 1)

    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)

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Insert Unicode? (2002 SP 1)

    There's no direct way I know of, but Rory clued me to <!post=this,144039>this<!/post> VBA method.
    -John ... I float in liquid gardens
    UTC -7DS

  3. #3
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Insert Unicode? (2002 SP 1)

    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:
    __________________________________________________ ____
    <img src=/S/nun.gif border=0 alt=nun width=20 height=20> Sister Dory
    Our Lady of Perpetual Help, Holstein Falls, Wisconsin, USA

  4. #4
    Lounger
    Join Date
    Apr 2001
    Location
    NOLA
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert Unicode? (2002 SP 1)

    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?

  5. #5
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Insert Unicode? (2002 SP 1)

    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.
    __________________________________________________ ____
    <img src=/S/nun.gif border=0 alt=nun width=20 height=20> Sister Dory
    Our Lady of Perpetual Help, Holstein Falls, Wisconsin, USA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •