How do I insert symbols using VBA?

[Guest]

Can you insert Unicode characters using VBA in EXCEL 2002? If you try to
record a macro with the menu command INSERT/SYMBOL..., you don't get much of
a clue.

 

[Tom Ogilvy]

With ActiveCell
.Value = chrw(1500)
.Font.Name = "Arial Unicode MS"
End with

 

[Guest]

Thank you, Tom

With ActiveCell
.Value = chrw(1500)
.Font.Name = "Arial Unicode MS"
End with