Symbols in UserForms

  • Thread starter Thread starter Matt Andrzejewski
  • Start date Start date
M

Matt Andrzejewski

Hey Gang:

I'm trying to figure out if I can enter symbols in text boxes in
UserForms. Any ideas?

Specifically, I'm generating an addin of statistical utilities and would
like to use the Greek symbols for mean (mu) and standard deviation
(little sigma), among others.
 
The best way would be to have a button that inserts it for you. So the
onclick code for the Mu button would say something like:

Textbox1.Value = chr(181)

To see all the chr codes, use this code. The row number it's on is the
code number:

Sub ListCodes()
For x = 1 To 255
Range("A" & x).Value = Chr(x)
Next x
End Sub
 
If the font is Symbol you can.

if you want mixed fonts, then you would need to handle the formatting of
these entries in code through some type of interface.

Regards,
Tom Ogilvy
 
Back
Top