Mega Code Archive

 

Categories / VisualBasic Script / Data Type Functions

 

Using the Chr Function and Constants to Enter Special Characters in a String

VBA Character Codes and Character Constants          Code                   Character          Chr(9)                 Tab          Chr(10)                Line-feed         Chr(11)                Soft return (Shift+Enter)         Chr(12)                Page break         Chr(13)                Carriage return         Chr(13) + Chr(10)      Carriage return/line-feed combination         Chr(14)                Column break         Chr(34)                Double straight quotation marks ('')         Chr(39)                Single straight quote mark/apostrophe (')         Chr(145)               Opening single smart quotation mark (')         Chr(146)               Closing single smart quotation mark/ apostrophe (')         Chr(147)               Opening double smart quotation mark (")         Chr(148)               Closing double smart quotation mark (")         Chr(149)               Bullet         Chr(150)               En dash         Chr(151)               Em dash       Sub Char()     MsgBox vbTab & vbCr End Sub