Character Map Help

[Patrick Jackman]

Using Character Map, I can copy and paste a "Black Up-Pointing Triangle"
(Arial, U+25B2) into the caption of label control. How can I paste this
character in VBA?

Patrick
=-=-=-=-=-=-=-=-=-=-=-=-=-
Patrick Jackman
Vancouver, BC

 

[Dirk Goldgar]

Using Character Map, I can copy and paste a "Black Up-Pointing Triangle"
(Arial, U+25B2) into the caption of label control. How can I paste this
character in VBA?

It's a double-byte character with the decimal value 9650. You have to use
the ChrW() function to represent it. For example,

Me.Label1.Caption = "This is the character: " & ChrW(9650)

Of course, the control must have its FontName property set to Arial, or some
other font that includes this character.

 

[Patrick Jackman]

Thanks very much Dirk.

I see that typing ?Hex(9650) into the immediate window will yeild
25B2

Is there a function to go the otherway; to convert a Hex value to decimal?

Patrick.

 

[Dirk Goldgar]

Thanks very much Dirk.

I see that typing ?Hex(9650) into the immediate window will yeild
25B2

Is there a function to go the otherway; to convert a Hex value to decimal?

In the Immediate Window:

?&H25B2
9650

If you happen to have the hexadecimal value as a string, you can use the
Val() function to convert it:

S = "&H25B2" : ?Val(S)
9650

 

[Patrick Jackman]

Much appreciated Dirk. I'll be able to use this for years.

Patrick.