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.

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.

--
Kevin Backmann


"aftamath" wrote:

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.

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?
--
Sincerely, Michael Colvin


"Kevin B" wrote:

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.

--
Kevin Backmann


"aftamath" wrote:

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.

Rows 1 thru 32 don't correspond to characters.
--
Gary''s Student


"Michael" wrote:

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?
--
Sincerely, Michael Colvin


"Kevin B" wrote:

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.

--
Kevin Backmann


"aftamath" wrote:

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.

Thanks very much Gary's Student. I'll try again.
--
Sincerely, Michael Colvin


"Gary''s Student" wrote:

Rows 1 thru 32 don't correspond to characters.
--
Gary''s Student


"Michael" wrote:

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?
--
Sincerely, Michael Colvin


"Kevin B" wrote:

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.

--
Kevin Backmann


"aftamath" wrote:

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.