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,

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)



"SupperDuck" <(E-Mail Removed)> wrote in message
news:B5081677-AD33-4DA1-9879-(E-Mail Removed)...
> 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,
>

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.

"SupperDuck" wrote:

> 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,
>

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


"SupperDuck" wrote:

> 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,
>