Using the Chr Function and Constants to Enter Special Characters in a String : Chr « Data Type Functions « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. Data Type Functions
3. Chr

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 

 

Related examples in the same category