software

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 Backmannquot;aftamathquot; wrote:

gt; Where can I find a complete list of all the character codes in VBA. eg.
gt; 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 Colvinquot;Kevin Bquot; wrote:

gt; Open the VB Editor (Alt F11) click on Help, click on the Answer Wizard tab
gt; in the Help dialog box and type in ANSI for a listing of ANSI characters.
gt;
gt; You could also fill column A, starting at row 1, in a spreadsheet with the
gt; numbers 1 through 256 and in column B enter the formula =CHAR(A1) and copy it
gt; down to B256 to have a handy reference sheet.
gt;
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;aftamathquot; wrote:
gt;
gt; gt; Where can I find a complete list of all the character codes in VBA. eg.
gt; gt; 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 Studentquot;Michaelquot; wrote:

gt; Hi Kevin. I tried your suggestion, but for some reason all I'm getting is a
gt; little square on the left edge of each cell in column B. Any idea why?
gt; --
gt; Sincerely, Michael Colvin
gt;
gt;
gt; quot;Kevin Bquot; wrote:
gt;
gt; gt; Open the VB Editor (Alt F11) click on Help, click on the Answer Wizard tab
gt; gt; in the Help dialog box and type in ANSI for a listing of ANSI characters.
gt; gt;
gt; gt; You could also fill column A, starting at row 1, in a spreadsheet with the
gt; gt; numbers 1 through 256 and in column B enter the formula =CHAR(A1) and copy it
gt; gt; down to B256 to have a handy reference sheet.
gt; gt;
gt; gt; --
gt; gt; Kevin Backmann
gt; gt;
gt; gt;
gt; gt; quot;aftamathquot; wrote:
gt; gt;
gt; gt; gt; Where can I find a complete list of all the character codes in VBA. eg.
gt; gt; gt; 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 Colvinquot;Gary''s Studentquot; wrote:

gt; Rows 1 thru 32 don't correspond to characters.
gt; --
gt; Gary''s Student
gt;
gt;
gt; quot;Michaelquot; wrote:
gt;
gt; gt; Hi Kevin. I tried your suggestion, but for some reason all I'm getting is a
gt; gt; little square on the left edge of each cell in column B. Any idea why?
gt; gt; --
gt; gt; Sincerely, Michael Colvin
gt; gt;
gt; gt;
gt; gt; quot;Kevin Bquot; wrote:
gt; gt;
gt; gt; gt; Open the VB Editor (Alt F11) click on Help, click on the Answer Wizard tab
gt; gt; gt; in the Help dialog box and type in ANSI for a listing of ANSI characters.
gt; gt; gt;
gt; gt; gt; You could also fill column A, starting at row 1, in a spreadsheet with the
gt; gt; gt; numbers 1 through 256 and in column B enter the formula =CHAR(A1) and copy it
gt; gt; gt; down to B256 to have a handy reference sheet.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Kevin Backmann
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;aftamathquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Where can I find a complete list of all the character codes in VBA. eg.
gt; gt; gt; gt; Chr(10) is sn enter or new line. I like the list that VBA Help shows.