MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Insert symbols

  Asked By: Dai    Date: Aug 15    Category: MS Office    Views: 1414

This may be the same as the question on Japanese characters which I was unable
to answer.

I can insert a right pointing black triangle in a cell by using insert/symbol
and selecting the character unicode 25BA, and clicking insert. If I record a
macro it only inserts a question mark. How can I create a macro to insert
this symbol. I want to put it in a toolbar so I can insert it with one click.



2 Answers Found

Answer #1    Answered By: Charlie Evans     Answered On: Aug 15

I think I have the answer, It is to use chrW with the decimal equivalent of
the unicode.

Answer #2    Answered By: Jawna Mohammad     Answered On: Aug 15

Do something like the following:
ActiveCell.Value = "u"
With Selection.Font
.Name = "Wingdings 3"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
All I have done is to define the font as well. The above gives a solid
right-pointing large arrow.

Didn't find what you were looking for? Find more on Insert symbols Or get search suggestion and latest updates.