Character Set

[Guest]

Where can I find a complete list of all the character codes in VBA. eg.
Chr(10) is sn enter or new line. I like the list that VBA Help shows.

 

[Guest]

Open the VB Editor (Alt + F11) click on Help, click on the Answer Wizard tab
in the Help dialog box and type in ANSI for a listing of ANSI characters.

You could also fill column A, starting at row 1, in a spreadsheet with the
numbers 1 through 256 and in column B enter the formula =CHAR(A1) and copy it
down to B256 to have a handy reference sheet.

 

[Guest]

Hi Kevin. I tried your suggestion, but for some reason all I'm getting is a
little square on the left edge of each cell in column B. Any idea why?

 

[Guest]

Rows 1 thru 32 don't correspond to characters.

 

[Guest]

Thanks very much Gary's Student. I'll try again.