VBA functions with respect to Unicode characters

Which VBA function is the most congruent with the Unicode set of characters.
Unicode character link: https://unicode-table.com/en/
Unicode identification is by U+**** where * is an alpha-numeric character.
By congruent, I mean that the last 4 alpha-numeric characters from Unicode must equal the last 4 alpha-numeric characters of the VBA function.
So far I am using ChrW(&H****).
Is ChrW() the most suitable with all the variations in computing, most of which I don't really know, but one is the operating system which could be Windows/Mac/Linux.

As an example, the symbol "@" has Unicode identification of "U+0040" and VBA equivalent is "ChrW(&H0040)". The leading 2 zeros actually drop off.

Thanks for providing this input.