ASCII CODE of a character...

[Guest]

Hi,

I use =code function in excel to see the ascii code for a character. But
when i try to use the "code" function, it crashes.

Could you please advise the code to see the ascii code?

Thanks and regards,

 

[Chip Pearson]

In VBA, use the Asc function.

Debug.Print Asc("A"), Hex(Asc("A"))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)

 

[Guest]

If you just want to see what the ASCII character is for a keyboard character,
you can type <ascii character set> in VBA help and it will bring up a menu
for 0-127 and 128- End.

 

[Guest]

hey

well im not sure i know how to do it through code, but maybe this'll help:

Go to Insert - Symbol..

scroll through them and click on the one you're looking for.
at the bottom of this window, it tells the character code.
to the right of it, theres a drop down menu thingy that allows you to switch
between viewing the
ASCII(hex), ASCII(decimal), and UNICODE(hex)
code for a character.

i'm not sure if this helped you