+ Reply to Thread
Results 1 to 3 of 3

Making MsgBox display Japanese

  1. #1
    Registered User
    Join Date
    10-20-2005
    Location
    Ithaca, NY, USA
    MS-Off Ver
    2004 for Mac
    Posts
    63

    Making MsgBox display Japanese

    Hi, all!

    The users of a macro are going to be Japanese, so I need to make the confirmation message box (that the macro has run) be in Japanese.

    It looks from the VBA Help that you just put the Japanese text within the parentheses after "MsgBox" in the code: when it discusses the maximum length for the prompt, it says that it depends on the width of the characters. When I did that, however, although I got a message box, it was empty other than the OK button. I thought I might be going over the maximum amount of text, so I tried just a few characters and got the same result.

    Is there something else I need to do to get Japanese text into a message box?

    Thank you!

    ctap

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good evening cheaperThanAPro

    Are you using the Japanese edition of Office, or are you using a fontset to display Japanese text? If the latter, you will have to forget using a MsgBox and use a UserForm instead - one of the restrictions you face using a MsgBox is you cannot control the font to be displayed, it's a standard system font.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    10-20-2005
    Location
    Ithaca, NY, USA
    MS-Off Ver
    2004 for Mac
    Posts
    63

    Oog

    I'm using the English version of Office, with Excel set with the Microsoft Language Register to Japanese. (I tried to set VBA for Applications to Japanese, but it wouldn't let me.) My users, however, will be using the Japanese version of Office. Do I transliterate into romaji, or will the button be readable to them although it is not to me?

    Thank you!

    ctap

+ 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