+ Reply to Thread
Results 1 to 7 of 7

Unicode characters appearing as "?"

  1. #1
    Registered User
    Join Date
    06-12-2013
    Location
    Provo, Utah
    MS-Off Ver
    Excel 2007
    Posts
    4

    Unicode characters appearing as "?"

    Is there a way to have VBA actually show a unicode character such as a down or up arrow? For example, I am trying to have VBA add a caption for a command button with the following symbol (&H2191). However, when I do this, it only shows a "?". Can anybody please offer any assistance on this matter?
    Thank you.

  2. #2
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Unicode characters appearing as "?"

    Try
    Please Login or Register  to view this content.
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

  3. #3
    Registered User
    Join Date
    06-12-2013
    Location
    Provo, Utah
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Unicode characters appearing as "?"

    Yes, this works. But I'm not having any problems getting the symbols to show up in the Excel cells. I'm trying to add a caption to a command button. I wasn't able to copy/paste the symbol I wanted onto the button, so I tried using VBA to add the caption. I'm having the same problem with either method, it just shows up as a "?" on the button.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Unicode characters appearing as "?"

    I don't think controls will display Unicode characters.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Unicode characters appearing as "?"

    See the link below
    http://office.microsoft.com/en-gb/ex...010167539.aspx
    You will have to check the character map on your computer.
    Basically ALT + character number and possibly an X.
    Inserts fine on a form button for me.

  6. #6
    Registered User
    Join Date
    06-12-2013
    Location
    Provo, Utah
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Unicode characters appearing as "?"

    Quote Originally Posted by WasWodge View Post
    See the link below
    http://office.microsoft.com/en-gb/ex...010167539.aspx
    You will have to check the character map on your computer.
    Basically ALT + character number and possibly an X.
    Inserts fine on a form button for me.
    And how about on an ActiveX button?

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Unicode characters appearing as "?"

    Previous post.
    http://www.excelforum.com/excel-prog...vex-label.html

    Forms control on worksheet will as will shapes.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1