ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   CHAR and CODE (https://www.excelbanter.com/excel-worksheet-functions/135804-char-code.html)

Sajit

CHAR and CODE
 
soI am trying to use the filled upright triangle in a VBA code. The VBA
editor does not show the symbol when I try to copy - paste it from the
windows character map. However I am able to copy it to an Excel sheet.

Also the code returned by the function for the triangle is 63. Whereas the
symbol returned by code 63 is the character "?"

Why does this happen so?

Sajit


Pete_UK

CHAR and CODE
 
It depends which font you are using - you may need to use one of the
symbol fonts or wingdings to see symbols rather than the normal
characters.

Hope this helps.

Pete

On Mar 21, 5:03 pm, Sajit wrote:
soI am trying to use the filled upright triangle in a VBA code. The VBA
editor does not show the symbol when I try to copy - paste it from the
windows character map. However I am able to copy it to an Excel sheet.

Also the code returned by the function for the triangle is 63. Whereas the
symbol returned by code 63 is the character "?"

Why does this happen so?

Sajit





All times are GMT +1. The time now is 10:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com