Recently I learned how to create global constants. Great! However … there is a small problem.
Some special characters in texts need to be created by using the chr() function. For example I use chr(8220) to create double left quotes and chr(8221) to create double right quotes. Now if I want to quote something in a text I do it like this:
MsgBox("Hello " & chr(8220) & "John" & chr(8221) & ".")
This is not very readable, so I wanted to use constants:
REM Top op Document Global Const LQ = chr(8220) Global Const RQ = chr(8221) REM Somewhere else in the document MsgBox("Hello " & LQ & "John" & RQ & ".")
However, this is not working because assigning the chr() function to a constant is not accepted and results in an error. Is there another way to globally assign special characters? Help needed …