Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert a symbol using VBA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert a symbol using VBA
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert a symbol using VBA
Hi,
You need to let it know it's a hex value ActiveCell.Value = ChrW(&H25BA) Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "RyanH" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert a symbol using VBA
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert a symbol using VBA
I put 25BA in cell A1 and in cell A2:
=HEX2DEC(A1) -- Gary''s Student - gsnu200804 "RyanH" wrote: 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert a symbol using VBA
How did you know that 25BA = 9658?
In the Immediate Window of VBA.... ?&H25BA -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Type a symbol useing shortcut keys rather the insert a symbol | Excel Discussion (Misc queries) | |||
Insert Symbol in VBA | Excel Programming | |||
Insert symbol | Excel Discussion (Misc queries) | |||
insert a therefore symbol | New Users to Excel | |||
I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) |