Signature (Visual Basic / VBA)
VB Expr. Keyboard Meaning
Chr$(9) Ctrl-I Tab
Chr$(10) Ctrl-J Line Feed
Chr$(11) Ctrl-K Horizontal Tab
Chr$(12) Ctrl-L Form Feed
Chr$(13) Ctrl-M Carriage Return
Code Examples
Chr$(AscAmpersand) = "&"
Chr$(AscApostrophe) = "'"
Chr$(AscAsterisk) = "*"
Chr$(AscAt) = "@"
Chr$(AscBackquote) = "`"
Chr$(AscBackslash) = "\"
Chr$(AscBackspace) = Chr$(8)
Chr$(AscCaret) = "^"
Chr$(AscColon) = ":"
Chr$(AscComma) = ","
Chr$(AscCR) = Chr$(13) = vbCr
Chr$(AscDegrees) = Chr$(176)
Chr$(AscDollarSign) = "$"
Chr$(AscDoubleQuote) = """"
AscEOF = -1
Chr$(AscEquals) = "="
Chr$(AscEscape) = Chr$(27)
Chr$(AscExclamation) = "!"
Chr$(AscGreaterThan) = ">"
Chr$(AscLeftBrace) = "{"
Chr$(AscLeftBracket) = "["
Chr$(AscLeftParen) = "("
Chr$(AscLowerCaseA) = "a"
Chr$(AscLowerCaseF) = "f"
Chr$(AscLowerCaseZ) = "z"
Chr$(AscLessThan) = "<"
Chr$(AscLF) = Chr$(10) = vbLf
Chr$(AscMinus) = "-"
Chr$(AscNil) = Chr$(0)
Chr$(AscNine) = "9"
Chr$(AscNumberSign) = "#"
Chr$(AscOne) = "1"
Chr$(AscPercent) = "%"
Chr$(AscPeriod) = "."
Chr$(AscPlus) = "+"
Chr$(AscQuestionMark) = "?"
Chr$(AscRightBrace) = "}"
Chr$(AscRightBracket) = "]"
Chr$(AscRightParen) = ")"
Chr$(AscSemicolon) = ";"
Chr$(AscSlash) = "/"
Chr$(AscSpace) = " "
Chr$(AscTab) = Chr$(9)
Chr$(AscTilde) = "~"
Chr$(AscUnderline) = "_"
Chr$(AscUpperCaseA) = "A"
Chr$(AscUpperCaseF) = "F"
Chr$(AscUpperCaseZ) = "Z"
Chr$(AscVerticalBar) = "|"
Chr$(AscZero) = "0"
EveryCharacterOfType(CharTypeAlNum) = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz"
EveryCharacterOfType(CharTypeAlpha) = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz"
EveryCharacterOfType(CharTypeCarriage) = Chr$(9) + Chr$(10) + Chr$(11) + Chr$(12) + Chr$(13)
EveryCharacterOfType(CharTypeCntrl) = Chr$(0) + Chr$(1) + ....
EveryCharacterOfType(CharTypeControl) = Chr$(0) + Chr$(1) + ....
EveryCharacterOfType(CharTypeDigit) = "0123456789"
EveryCharacterOfType(CharTypeGraph) = "!""#$\%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~"
EveryCharacterOfType(CharTypeHexadecimal) = "0123456789ABCDEFabcdef"
EveryCharacterOfType(CharTypeLower) = "abcdefghijklmnopqrstuvwxyz"
EveryCharacterOfType(CharTypeNone) = ""
EveryCharacterOfType(CharTypePrint) = " !""#$\%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~"
EveryCharacterOfType(CharTypePunctuation) = "!""#$\%&'()*+,-./:;<=>?@[\]^_`{|}~"
EveryCharacterOfType(CharTypeSpace) = Chr$(9) + Chr$(10) + Chr$(11) + Chr$(12) + Chr$(13) + Chr$(32) + Chr$(160)
EveryCharacterOfType(CharTypeUpper) = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
EveryCharacterOfType(CharTypeWhitespace) = Chr$(32) + Chr$(160)
"B" = Control character
"C" = Carriage control character
"D" = Numeric digit
"L" = Lower-case character
"M" = Lower-case and hexadecimal numeric character
"N" = No classification
"P" = Punctuation character
"S" = Whitespace character
"U" = Upper-case character
"W" = Upper-case and hexadecimal numeric character
"X" = Hexadecimal digit
Notes & Version History
| Note | This Class is automatically initialized with the definitions for the ANSI/Windows character set. |
| ASCIIValueConstants Enum | Global Constants of US ASCII values for certain characters, etc. |
| AscAmpersand | US ASCII value of the ampersand ("&") character. |
| AscApostrophe | US ASCII value of the apostrophe ("'") character. Also known as the single-quote character. Formerly available as AscSingleQuote. |
| AscAsterisk | US ASCII value of the asterisk ("*") character. Also known as the star or multiplication sign. |
| AscAt | US ASCII value of the at-sign ("@") character. |
| AscBackquote | US ASCII value of the back-quote ("`") character. The key to the left of "1" on US 101-key keyboards. |
| AscBackslash | US ASCII value of the back-slash ("\") character. |
| AscBackspace | US ASCII value of the backspace ({Ctrl}+H) character. Causes printers and terminals to move the cursor back one space. |
| AscCaret | US ASCII value of the up-caret ("^") character. |
| AscColon | US ASCII value of the colon (":") character. |
| AscComma | US ASCII value of the comma (",") character. |
| AscCR | "ASCII Carriage Return" US ASCII value of the carriage return ({Ctrl}+M) character. Formerly available as AscCarriageReturn. |
| AscDegrees | US ASCII value of the temperature degrees symbol. The symbol resembles a superscript circle. |
| AscDollarSign | US ASCII value of the dollar sign ("$") character. |
| AscDoubleQuote | US ASCII value of the double-quote ('"') character. |
| AscEOF | "ASCII End Of File" Special definition which represents end-of-file conditions within stream input routines. Is currently defined (like UNIX) at -1. |
| AscEquals | US ASCII value of the equal sign ("=") character. |
| AscEscape | US ASCII value of the Escape key. |
| AscExclamation | US ASCII value of the exclamation point ("!") (exclamation sign) character. Formerly available as AscBang. |
| AscGreaterThan | US ASCII value of the greater-than sign (">") character. |
| AscLeftBrace | US ASCII value of the left brace ("{") character. |
| AscLeftBracket | US ASCII value of the left bracket ("[") character. |
| AscLeftParen | "ASCII Left Parenthesis" US ASCII value of the left parenthesis ("(") character. |
| AscLowerCaseA | US ASCII value of the lower-case letter "a" |
| AscLowerCaseF | US ASCII value of the lower-case letter "f" |
| AscLowerCaseZ | US ASCII value of the lower-case letter "z" |
| AscLessThan | US ASCII value of the less-than sign ("<") character. |
| AscLF | "ASCII Line Feed" US ASCII value of the line feed ({Ctrl}+J) character. Also known as NL or New Line. Formerly available as AscLineFeed. |
| AscMinus | US ASCII value of the minus sign ("-") character. Also known as dash or hyphen. |
| AscNil | US ASCII value of the nil (Chr$(0)) character. Is defined as zero (0). |
| AscNine | US ASCII value of the character representing the number nine ("9"). |
| AscNumberSign | US ASCII value of the number sign ("#") character. Also known as the pound sign. Formerly available as AscPound. |
| AscOne | US ASCII value of the character representing the number one ("1"). |
| AscPercent | US ASCII value of the percent sign ("%") character. |
| AscPeriod | US ASCII value of the period (".") character. Also known as dot. Formerly available as AscDot. |
| AscPlus | US ASCII value of the plus sign ("+") character. |
| AscQuestionMark | US ASCII value of the question mark ("?") character. |
| AscRightBrace | US ASCII value of the right brace ("}") character. |
| AscRightBracket | US ASCII value of the right bracket ("]") character. |
| AscRightParen | "ASCII Right Parenthesis" US ASCII value of the right parenthesis (")") character. |
| AscSemicolon | US ASCII value of the right semi-colon (";") character. |
| AscSlash | US ASCII value of the slash ("/") character. Also known as the divide sign. |
| AscSpace | US ASCII value of the space (" ") character. |
| AscTab | US ASCII value of the tab ({Ctrl}+I) character. Usually advances a terminal or printer to the next preset tab stop. |
| AscTilde | US ASCII value of the tilde ("~") character. Sometimes used to represent approximate values. |
| AscUnderline | US ASCII value of the underline ("_") character. |
| AscUpperCaseA | US ASCII value of the upper-case letter "A" |
| AscUpperCaseF | US ASCII value of the upper-case letter "F" |
| AscUpperCaseZ | US ASCII value of the upper-case letter "Z" |
| AscVerticalBar | US ASCII value of the vertical-bar ("|") character. |
| AscZero | US ASCII value of the character representing the number zero ("0"). |
| CharacterTypeConstants Enum | Constants for the character classifications recognized by the functions like IsAlpha and IsDigit . |
| CharTypeAlNum | "Character Type Alphanumeric" Property whose value represents alphanumeric (alphabetic and numeric) characters ("0"..."9", "A"..."Z", "a"..."z", accented alphabetic characters, etc.) in calls to functions like EveryCharacterOfType . |
| Note | Example would also include some accented characters not shown here. |
| Definition | ctCharTypeDigit Or ctCharTypeAlpha |
| CharTypeAlpha | "Character Type Alphabetic" Property whose value represents alphabetic characters ("A"..."Z", "a"..."z", accented alphabetic characters, etc.) in calls to functions like EveryCharacterOfType . |
| Note | Example would also include some accented characters not shown here. |
| Definition | ctCharTypeLower Or ctCharTypeUpper |
| CharTypeCarriage | "Character Type Carriage Control" Property whose value represents carriage control type characters (carriage return, line feed, form feed, etc.) in calls to functions like EveryCharacterOfType . |
| CharTypeCntrl | "Character Type Control" Property whose value represents all control characters (Control+A, Control+B, ..., Control+Z) in calls to functions like EveryCharacterOfType . |
| Definition | ctCharTypeControl Or ctCharTypeCarriage |
| CharTypeControl | "Character Type Control Non-Carriage" Property whose value represents control characters (Control+A, Control+B, ..., Control+Z) which are NOT also carriage control characters in calls to functions like EveryCharacterOfType . |
| CharTypeDigit | "Character Type Numeric Digit" Property whose value represents numeric digit characters ("0", "1", "2", ... "9") in calls to functions like EveryCharacterOfType . |
| CharTypeGraph | "Character Type Graphical" Property whose value represents alphanumeric ("0".."9", "A".."Z", "a".."z") and punctuation characters (",", ";", "'", etc.) in calls to functions like EveryCharacterOfType . |
| Note | Example would also include many characters not shown here. |
| Definition | ctCharTypeAlNum Or ctCharTypePunctuation |
| CharTypeHexadecimal | "Character Type Hexadecimal Digit" Property whose value represents hexadecimal digit characters ("0", "1", "2", ... "9", "A"..."F", "a"..."f") in calls to functions like EveryCharacterOfType . |
| Definition | ctCharTypeDigit Or ctCharTypeHexadecimal |
| Definition | ctCharTypeLower Or ctCharTypeHexadecimal |
| Definition | ctCharTypeUpper Or ctCharTypeHexadecimal |
| CharTypeLower | "Character Type Lower Case Alphabetic" Property whose value represents lower-case characters ("a"..."z", accented lower-case characters, etc.) in calls to functions like EveryCharacterOfType . |
| Note | Example would also include some accented characters not shown here. |
| CharTypeNone | "Character Type None" Property whose value represents characters with no separately-specified type in calls to functions like EveryCharacterOfType . |
| CharTypePrint | "Character Type Printable" Property whose value represents printable characters--that is "graph" characters (alphanumerics and punctuation) and whitespace characters (Chr$(32) and Chr$(160)) in calls to functions like EveryCharacterOfType . |
| Note | Example would also include many characters not shown here. |
| Definition | ctCharTypeGraph Or ctCharTypeWhitespace |
| CharTypePunctuation | "Character Type Punctuation" Property whose value represents punctuation/symbol characters (",", ".", ";", etc.) in calls to functions like EveryCharacterOfType . |
| Note | Example would also include many other characters not shown here. |
| CharTypeSpace | "Character Type Space" Property whose value represents space type characters--that is carriage control characters (carriage return, line feed, etc.) and whitespace characters (Chr$(32) and Chr$(160)) in calls to functions like EveryCharacterOfType . |
| Definition | ctCharTypeCarriage Or ctCharTypeWhitespace |
| CharTypeUpper | "Character Type Upper Case Alphabetic" Property whose value represents upper-case characters ("a"..."z", etc.) in calls to functions like EveryCharacterOfType . |
| Note | Example would also include some accented characters not shown here. |
| CharTypeWhitespace | "Character Type White Space" Property whose value represents whitespace characters (Chr$(32) and Chr$(160)) in calls to functions like EveryCharacterOfType . |
| ctCTYPE_ANSI, ctCTYPE_USASCII | Constants which define the classification of characters within specific character sets. |
| Character Type Codes | (See the CType Property) |
| CharacterTable | These functions return strings containing formatted character tables. They can be printed in the Debug window, and they may be useful for testing other string functions. |
See Also
StringWords Class →
CharacterArrays Class →
SortOrders Class →
StringExtras Class →
CharacterTypes Class →
GlobalConstants Class →
IsAlNum Function →
EveryCharacterOfType Function →
IsAlpha Function →
IsCarriage Function →
IsCntrl Function →
IsDigit Function →
IsGraph Function →
IsXDigit Function →
IsLower Function →
IsPrint Function →
IsPunct Function →
IsSpace Function →
IsUpper Function →