How to get the squared symbol to display in a string

Question

I m trying to get    to show in a string  As an example my output should be inside a ActiveX Textbox and should read R     50   I ve tried the following two statements    Selection Characters Text    R amp ChrW  amp HB2  amp        amp  variable   but this displays a 0 as the output in the Textbox  And this   Selection Characters Text    R        amp  variable   also displays a 0

User · Answer

I create equations with random numbers in VBA and for x squared put in x^2.

I read each square (or textbox) text into a string.

I then read each character in the string in turn and note the location of the ^ ("hats")'s in each.

Say the hats were at positions 4, 8 and 12.

I then "chop out" the first hat - the position of the character to be superscripted is now 4, the position of the other hats is now 7 and 11. I chop out the second hat, the character to superscript is now at 7 and the hat has moved to 10. I chop out the last hat .. the superscript character is now position 10.

I now select each character in turn and change the font to superscript.

Thus I can fill a whole spreadsheet with algebra using ^ and then call a routine to tidy it up.

For big powers like x to the 23 I build x^2^3 and the above routine does it.

User · Answer

No need to get too complicated  If all you need is    then use the unicode representation   http   en wikipedia org wiki Unicode subscripts and superscripts   which is how I assume you got the    to appear in your question

User · Answer

Not sure what kind of text box you are refering to  However  I m not sure if you can do this in a text box on a user form   A text box on a sheet you can though   Sheets  Sheet1   Shapes  TextBox 1   TextFrame2 TextRange Text    R2    amp  variable Sheets  Sheet1   Shapes  TextBox 1   TextFrame2 TextRange Characters 2  1  Font Superscript   msoTrue   And same thing for an excel cell  Sheets  Sheet1   Range  A1   Characters 2  1  Font Superscript   True   If this isn t what you re after you will need to provide more information in your question   EDIT  posted this after the comment sorry

[vba] How to get the squared symbol (²) to display in a string

Examples related to vba

Examples related to excel

Examples related to excel-2007