Forum Discussion

taufiq6121's avatar
taufiq6121
Copper Contributor
Jun 09, 2022
Solved

How to type superscript in Excel macro?

Hello, I am new to writing Excel macros and really appreciate your help.   I am trying to write a macro to process all worksheets in an Excel file and import the data into one single worksheet. Ho...
excel
Macros and VBA
  • taufiq6121's avatar
    taufiq6121
    Jun 10, 2022

    Dear HansVogelaar 

     

    Thank you very much for your suggestion regarding the language. I managed to get the solution.

     

    By changing the Language for non-Unicode Programs to English (United States) in the Control Panel, the superscript and other symbols can be written in the VBA

     

    My default was Japanese (Japan) and even English (United Kingdom) was unsuccessful.

     

    Here's also the link that I referred to

     

    https://answers.microsoft.com/en-us/msoffice/forum/all/excel-2019-open-excel-2010-vba-with-strange-symbol/99fbad9d-282f-4da5-a19f-12f306363d1b 

     

    I really appreciate your help by responding to my question.

     

    Please have a good day.

     

     

taufiq6121's avatar
taufiq6121
Copper Contributor
Jun 10, 2022

Dear HansVogelaar 

 

Thank you very much for your suggestion regarding the language. I managed to get the solution.

 

By changing the Language for non-Unicode Programs to English (United States) in the Control Panel, the superscript and other symbols can be written in the VBA

 

My default was Japanese (Japan) and even English (United Kingdom) was unsuccessful.

 

Here's also the link that I referred to

 

https://answers.microsoft.com/en-us/msoffice/forum/all/excel-2019-open-excel-2010-vba-with-strange-symbol/99fbad9d-282f-4da5-a19f-12f306363d1b 

 

I really appreciate your help by responding to my question.

 

Please have a good day.

 

 

Resources