Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert 1/3 as fraction
Howdee all.
Hope everyone is getting along. I'm trying to insert a 1/3 character in some code that I'm using for a macro. While I could easily type one, forward slash, and three, (1 / 3), I'd rather use the option as in alt + 0188, where I get a ¼ form of the fraction. I've found the one third fraction in the symbol map, but I see no key strokes to access it, for entry into the code for my macro. I.e., on the character map, it shows as U + 2153, Vulgar fraction one third. So, my question is: Does anyone know of keystrokes that will allow me to access this character? Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
got it....
I found what I was looking for.
Thank you. turns out if you want to access "fancier" characters, you have to use chrW(&Hn) where the n = the vulgar fraction value. In my case the n = 2153, so I set it to: chrW(&H2153) and I get one third exactly as I desire. I'll definitely be testing others in that list too. Best. "Steve" wrote: Howdee all. Hope everyone is getting along. I'm trying to insert a 1/3 character in some code that I'm using for a macro. While I could easily type one, forward slash, and three, (1 / 3), I'd rather use the option as in alt + 0188, where I get a ¼ form of the fraction. I've found the one third fraction in the symbol map, but I see no key strokes to access it, for entry into the code for my macro. I.e., on the character map, it shows as U + 2153, Vulgar fraction one third. So, my question is: Does anyone know of keystrokes that will allow me to access this character? Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert 1/3 as fraction
This will reference the 1/3 character that you want...
ChrW(8531) For example... Range("A1").Value = ChrW(8531) -- Rick (MVP - Excel) "Steve" wrote in message ... Howdee all. Hope everyone is getting along. I'm trying to insert a 1/3 character in some code that I'm using for a macro. While I could easily type one, forward slash, and three, (1 / 3), I'd rather use the option as in alt + 0188, where I get a ¼ form of the fraction. I've found the one third fraction in the symbol map, but I see no key strokes to access it, for entry into the code for my macro. I.e., on the character map, it shows as U + 2153, Vulgar fraction one third. So, my question is: Does anyone know of keystrokes that will allow me to access this character? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show fraction as fraction even if answer is 1 | Charts and Charting in Excel | |||
how to add 3/4 as a fraction | Excel Discussion (Misc queries) | |||
Text fraction to fraction format | Excel Worksheet Functions | |||
Fraction | Excel Programming | |||
How do I change fraction to fraction characters? | Excel Worksheet Functions |