Doh!
I remember now--- THANK YOU.
I so seldom use the chrW that I forgot all about it.
Have a great weekend.


"Gary''s Student" wrote:

Since 2153 Hex is 8531 Decimal, putting the character in a cell is as easy as:

Sub dural()
ActiveCell.Value = ChrW(8531)
ActiveCell.Font.Name = "Arial Unicode MS"
End Sub

I don't know about putting it elsewhere.
--
Gary''s Student - gsnu200853


"Steve" wrote:

morning all.
I want to insert the 1/3 character in VBA for a screen tip in my RibbonX
gallery for excel 2007. (RonDeBRuin has posted a nice article in the MSDN
library on it now. Extremely helpful for anyone who wants to make their own
gallery.)
According to Chip Pearson's webpage, I can find the code required for this
character by using =code("…“")

While the character showing here is a 1/2, I actually selected 1/3. Unicode
character U+2153 from the character map.

The answer that I get when using Chip's recommended way is 63.
however, when I then input chr(63) I only get a '?' instead of the 1/3.

So, my question is-- in the vba code window, how is it that I can insert a
character that's not from the 255 "standard" choices we have available to us?

Thank you.