Insert a symbol using VBA
Simplest way is just to memorise all the 65k character codes in Hex format,
but you could cheat and embrace with &Hxxxx&
Regards,
Peter T
"RyanH" wrote in message
...
How did you know that 25BA = 9658?
--
Cheers,
Ryan
"Gary''s Student" wrote:
Argument needs decimal, not hex:
Sub dural()
ActiveCell.Value = ChrW(9658)
End Sub
--
Gary''s Student - gsnu200804
"RyanH" wrote:
Here is the symbol I am trying to insert: ?. Here is the properties of
it:
Arial, Geometric Shapes, Character Code 25BA, Unicode(hex).
When ever I use this code the line below shades red, why?
ActiveCell.Value = ChrW(25BA)
--
Cheers,
Ryan
|