VBA/Excel/Access/Word/Data Type Functions/Chr

Материал из VB Эксперт
Перейти к: навигация, поиск

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>