Can I assign an ASCII character to a VBA constant?

[JenniferMurphy]

Is there any way to assign various Unicode characters to string constants in VBA? This code works.

Dim DownArrow As String
DownArrow = ChrW(&H2193)
Dim UpArrow As String
UpArrow = ChrW(&H2191)

But I was hoping for something like

Const DownArrow as String = &H2193
Const DownArrow as String = "2193"x

Thanks

 

[RoryA]

That gave me an idea.

Isn’t that what Alphafrog suggested yesterday?

 

[JenniferMurphy]

Isn’t that what Alphafrog suggested yesterday?

I guess it is. I thought he was suggesting that I put those Public constants in each function. With my solution, I only need to do it once.

Anyway, I marked that post as the solution.