How to Reference Special Characters Using Excel vba

Question

I have several special characters in an excel spreadsheet. How do I reference them in Excel VBA?

The characters I need are not in the standard 255 ASCII codes.

I was thinking perhaps Chr(code) would work, but I'm not able to find the codes for the characters I need to test this.

you get it using Chr(number) function. The opposite function is called Asc(string) — Kazimierz Jawor
– Kazimierz Jawor, Commented Jan 27, 2014 at 9:35
Goto this link to understand the codes for all characters asciitable.com — Irfan Shaikh
– Irfan Shaikh, Commented Jan 27, 2014 at 9:37
Sub GetAsciiCodes() Dim i As Long For i = 1 To 255 Range("A" & i) = i Range("B" & i) = Chr(i) Next End Sub — user2140173
– user2140173, Commented Jan 27, 2014 at 9:43
Nice, but I updated the question because they are non-standard ascii characters — parap
– parap, Commented Jan 27, 2014 at 9:58
++ > The ChrW function returns a String containing the Unicode character except on platforms where Unicode is not supported, in which case, the behavior is identical to the Chr function. ++ > Chr function ++ ++ Use this web to search for unicode. ++ For ChrW, just use the numerics in HTML-code; dont use the Unicode number (idk why). — Nor.Z
– Nor.Z, Commented May 29, 2022 at 13:48

Taosique · Accepted Answer · 2014-01-27 10:08:02Z

5

User ChrW() instead of Chr() function to reference Unicode characters:

ChrW(23383) will produce 字.

Chr(23383) will throw an exception.

edited Jan 27, 2014 at 10:08

answered Jan 27, 2014 at 10:01

Taosique

7,9143 gold badges33 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Teodora · Accepted Answer · 2014-10-09 07:28:09Z

1

Use this script to see ChrW characters in F column

Sub caracter()
Dim caract As String
Dim r As Range
Dim i As Integer
caract = ChrW(633)
For i = 1 To 20000
caract = ChrW(i)
ActiveSheet.Cells(i, 6).Value = caract
Next i
End Sub

answered Oct 9, 2014 at 7:28

Teodora

111 bronze badge

Collectives™ on Stack Overflow

How to Reference Special Characters Using Excel vba

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related