ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Symbols in UserForms (https://www.excelbanter.com/excel-programming/272028-symbols-userforms.html)

Matt Andrzejewski

Symbols in UserForms
 
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.





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Mark Bigelow

Symbols in UserForms
 
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

---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Tom Ogilvy

Symbols in UserForms
 
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

"Matt Andrzejewski" wrote in message
...
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.





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!




Matt Andrzejewski

Symbols in UserForms
 
Thanks Mark and Tom, for the help.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


All times are GMT +1. The time now is 02:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com