Share via

Can not use KOREAN language in VBA

영웅 고 20 Reputation points
2025-12-05T05:38:46.8033333+00:00

Hello

first, I apologize that I am not good at English

AS you can see picture, I can't use korean language in VBA

Please help me

I already tried changing language to korean in control panal but it didn't work

Microsoft 365 and Office | Excel | For home | Windows
0 comments

Answer accepted by question author

  1. Kimberly Olaño 23,545 Reputation points
    2025-12-05T06:59:38.2033333+00:00

    Thanks for sharing the details. The VBA editor is old and does not fully support Unicode, but Windows can force it to use a font that supports Korean.

    Steps

    • Press Win + R, type regedit, press Enter
    • Go to:
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Visual Basic\6.0\Fonts
      If the folder Fonts does not exist, create it
      Microsoft Sans Serif MS Gothic Malgun Gothic
    • Set each value to a Korean-capable font name, for example:
      Malgun Gothic
    • Restart Excel/Word → reopen VBA.

    The VBA editor normally uses legacy ANSI fonts. Adding the font mapping forces Windows to supply a Unicode font that supports Hangul.

    See if this helps. If you need further assistance just let me know.

    Best regards,

    Kimberly

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. 영웅 고 20 Reputation points
    2025-12-05T05:46:05.22+00:00

    화면 캡처 2025-12-04 232445

    Was this answer helpful?

  2. 영웅 고 20 Reputation points
    2025-12-05T05:45:02.14+00:00

    it didn't work

    Was this answer helpful?

    0 comments
  3. Q&A Assist
    2025-12-05T05:42:57.3133333+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    To enable the use of the Korean language in VBA, follow these steps:

    1. Office Language Preferences: Open Office 2016 Language Preferences by navigating to Start > All Programs > Microsoft Office > Microsoft Office 2016 Tools. From there, add Korean as an editing language and set it as the default language for editing.
    2. Control Panel Language Settings: Ensure that the language settings in the Control Panel align with those in your Office applications. Discrepancies can lead to issues with language functionality in VBA.
    3. Language Support: Confirm that you have enabled support for the Korean language within your operating system. This may require installing additional language packs to ensure full functionality.
    4. Input Method Editor (IME): Verify that the Input Method Editor for Korean is correctly set up. You can switch between languages using the language bar available in Windows.

    If you have completed these steps and are still facing difficulties, consider checking for any broken type library references in your VBA project, as this may also affect language support.

    References:

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.