Character Set

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.