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