VBA/Excel/Access/Word/Data Type Functions/Chr
Chr() Returns the character represented by the character code.
<source lang="vb">
Sub strDemo18()
Debug.Print Chr(65)
End Sub
</source>
Using the Chr Function and Constants to Enter Special Characters in a String
<source lang="vb">
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
</source>