Pretty sure vba doesn't support Unicode - not even with Option Compare Binary. While there are functions like ChrW that I don't know much about, they seem to be intended for converting unicode values to decimal or whatever, but the character source is usually a table or spreadsheet. Thus you likely can process the character, but not by explicitly typing it into the vba editor. The editor will represent it as ? because it's not supported.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.