Using ascii code in Excel UserForm Textbox

[Oseitutuakrasi]

Dear All,
Admittedly, I'm not sure if this is possible. I can directly enter an ascii character (such as a % sign) into a Textbox by using the Numlock keypads with the ALT key.
That is fine. But I want this to happen automatically when I activate the form. This is what I have done:
UserForm1.Activate()
Sendkeys "{Numlock}", True ' To activate pressing the NumLock key
Sendkeys ("%8373") ' I am told that the % simulates the ALT key. So, I am pressing the ALT key as I enter 8373
End Sub

I was hoping that the above code will simulate pressing the NumLock key, then press (and hold down) the ALT as I enter the code 8373
However, when the form opens the text box contains only 373. The 8 is missing and the character I was expecting does not appear. I have the feeling that the ALT key does not stay down, but I could be wrong. Any help please?

Regards,
Sam

 

[Akuini]

You can use ChrW function:

TextBox1.Text = ChrW(8373)

 

[Oseitutuakrasi]

You can use ChrW function:

TextBox1.Text = ChrW(8373)

What a LEGEND you are, Akuini. Thanks million times and more
Regards,
Samuel

 

[Akuini]

You're welcome, glad to help & thanks for the feedback.

 

[Akuini]

@Oseitutuakrasi
Just additional info, if you want to know the code number of a unicode character, you can put the character in a cell and then use UNICODE function, like this:

Book1
	A	B
1	▼	9660
2	▲	9650
3	◆	9670
4	₵	8373
Sheet5

Cell Formulas
Range	Formula
B1:B4	B1	=UNICODE(A1)