VBA function: chr / chrW

chr

chr(n) converts the ascii code n to a (single character) string. The opposite function is asc("x").

option explicit

sub main() ' {

    dim charNo as integer

    for charNo = asc("a") to asc("z")
        debug.print "chr(" & charNo & ") = " & chr(charNo)
    next charNo

end sub ' }

Github repository about-VBA, path: /functions/chr/asc_chr.bas

The Excel equivalent of chr seems to be =char(…) (in German: =zeichen(…))

chrW

chrW(u) is similar to chr. However, it accepts the range 0 - 65535 as input parameter and produces a Unicode character.

The Excel equivalent of chrW seems to be =uniChar(…) (In German: =uniZeichen(…))

VBA function: chr / chrW

chr

chrW

See also