Displaying contents of a cell that contains a special symbol

The following code enters the special symbol ( a check mark) correctly in the specified cell; however, line 2 results in a Question mark being displayed in the MsgBox. Can you help me understand why? And also how to correctly display the contents of a cell that contains a special symbol?

Please Login or Register  to view this content.

Thank you

Originally Posted by JRMOURNING

The following code enters the special symbol ( a check mark) correctly in the specified cell; however, line 2 results in a Question mark being displayed in the MsgBox ....

This is because; Visual Basic Editor does not support Unicode encoding, it uses the code page of your Windows system locale. Therefore, you see a question mark, instead of a check mark.

The character code you are referring is 63 (decimal) and its corresponding character is a question mark in Visual Basic Editor's code page, which the MsgBox also uses.

You can display ASCII characters in a range of 0 - 255 which you can see from the link below.

https://www.ascii-code.com/