22 | 06 | 2017

Standard Character Values

Characters (CHR) values can be used in strings for characters or actions. Characters can be used for instance to create RETURN and TAB actions.

    Sub TestCharacters()
        Dim str As String

        str = "This Line has multiple lines due to Chr(13)" & Chr(13) & _
                "Chr(13) creates a new line" & Chr(9) & " Chr(11) creates a TAB" & Chr(13) & _
                "Chr(109) creates a character '" & Chr(109) & "')"

        MessageBox.Show(str)
    End Sub

The result:

'Result of the above code'

A complete list of characters is shown below:

Character No 8 (Chr(8):     [Backspace]
Character No 9 (Chr(9): 	[Tab]               ' (vbTab) can be used to have the same result
Character No 10 (Chr(10):   [Line Feed Return]  ' (vbLf) can be used to have the same result
Character No 11 (Chr(11):   [Shift+Enter]       ' (vbVerticalTab) can be used to have the same result
Character No 12 (Chr(12):   [Page Break]        ' (vbFormFeed) can be used to have the same result
Character No 13 (Chr(13):   [Carriage Return]   ' (vbCr) can be used to have the same result
Character No 14 (Chr(14):   [Column Break]
Character No 15 (Chr(15):   [Shift In]
Character No 32 (Chr(32):  (space)
Character No 33 (Chr(33):  !
Character No 34 (Chr(34):  "
Character No 35 (Chr(35):  #
Character No 36 (Chr(36):  $
Character No 37 (Chr(37):  %
Character No 38 (Chr(38):  &
Character No 39 (Chr(39):  '
Character No 40 (Chr(40):  (
Character No 41 (Chr(41):  )
Character No 42 (Chr(42):  *
Character No 43 (Chr(43):  +
Character No 44 (Chr(44):  ,
Character No 45 (Chr(45):  -
Character No 46 (Chr(46):  .
Character No 47 (Chr(47):  /
Character No 48 (Chr(48):  0
Character No 49 (Chr(49):  1
Character No 50 (Chr(50):  2
Character No 51 (Chr(51):  3
Character No 52 (Chr(52):  4
Character No 53 (Chr(53):  5
Character No 54 (Chr(54):  6
Character No 55 (Chr(55):  7
Character No 56 (Chr(56):  8
Character No 57 (Chr(57):  9
Character No 58 (Chr(58):  :
Character No 59 (Chr(59):  ;
Character No 60 (Chr(60):  <
Character No 61 (Chr(61):  =
Character No 62 (Chr(62):  >
Character No 63 (Chr(63):  ?
Character No 64 (Chr(64):  @
Character No 65 (Chr(65):  A
Character No 66 (Chr(66):  B
Character No 67 (Chr(67):  C
Character No 68 (Chr(68):  D
Character No 69 (Chr(69):  E
Character No 70 (Chr(70):  F
Character No 71 (Chr(71):  G
Character No 72 (Chr(72):  H
Character No 73 (Chr(73):  I
Character No 74 (Chr(74):  J
Character No 75 (Chr(75):  K
Character No 76 (Chr(76):  L
Character No 77 (Chr(77):  M
Character No 78 (Chr(78):  N
Character No 79 (Chr(79):  O
Character No 80 (Chr(80):  P
Character No 81 (Chr(81):  Q
Character No 82 (Chr(82):  R
Character No 83 (Chr(83):  S
Character No 84 (Chr(84):  T
Character No 85 (Chr(85):  U
Character No 86 (Chr(86):  V
Character No 87 (Chr(87):  W
Character No 88 (Chr(88):  X
Character No 89 (Chr(89):  Y
Character No 90 (Chr(90):  Z
Character No 91 (Chr(91):  [
Character No 92 (Chr(92):  \
Character No 93 (Chr(93):  ]
Character No 94 (Chr(94):  ^
Character No 95 (Chr(95):  _
Character No 96 (Chr(96):  `
Character No 97 (Chr(97):  a
Character No 98 (Chr(98):  b
Character No 99 (Chr(99):  c
Character No 100 (Chr(100):  d
Character No 101 (Chr(101):  e
Character No 102 (Chr(102):  f
Character No 103 (Chr(103):  g
Character No 104 (Chr(104):  h
Character No 105 (Chr(105):  i
Character No 106 (Chr(106):  j
Character No 107 (Chr(107):  k
Character No 108 (Chr(108):  l
Character No 109 (Chr(109):  m
Character No 110 (Chr(110):  n
Character No 111 (Chr(111):  o
Character No 112 (Chr(112):  p
Character No 113 (Chr(113):  q
Character No 114 (Chr(114):  r
Character No 115 (Chr(115):  s
Character No 116 (Chr(116):  t
Character No 117 (Chr(117):  u
Character No 118 (Chr(118):  v
Character No 119 (Chr(119):  w
Character No 120 (Chr(120):  x
Character No 121 (Chr(121):  y
Character No 122 (Chr(122):  z
Character No 123 (Chr(123):  {
Character No 124 (Chr(124):  |
Character No 125 (Chr(125):  }
Character No 126 (Chr(126):  ~
Character No 127 (Chr(127):  
Character No 128 (Chr(128):  €
Character No 129 (Chr(129):  
Character No 130 (Chr(130):  ‚
Character No 131 (Chr(131):  ƒ
Character No 132 (Chr(132):  „
Character No 133 (Chr(133):  …
Character No 134 (Chr(134):  †
Character No 135 (Chr(135):  ‡
Character No 136 (Chr(136):  ˆ
Character No 137 (Chr(137):  ‰
Character No 138 (Chr(138):  Š
Character No 139 (Chr(139):  ‹
Character No 140 (Chr(140):  Œ
Character No 141 (Chr(141):  
Character No 142 (Chr(142):  Ž
Character No 143 (Chr(143):  
Character No 144 (Chr(144):  
Character No 145 (Chr(145):  ‘
Character No 146 (Chr(146):  ’
Character No 147 (Chr(147):  “
Character No 148 (Chr(148):  ”
Character No 149 (Chr(149):  •
Character No 150 (Chr(150):  –
Character No 151 (Chr(151):  —
Character No 152 (Chr(152):  ˜
Character No 153 (Chr(153):  ™
Character No 154 (Chr(154):  š
Character No 155 (Chr(155):  ›
Character No 156 (Chr(156):  œ
Character No 157 (Chr(157):  
Character No 158 (Chr(158):  ž
Character No 159 (Chr(159):  Ÿ
Character No 160 (Chr(160):   
Character No 161 (Chr(161):  ¡
Character No 162 (Chr(162):  ¢
Character No 163 (Chr(163):  £
Character No 164 (Chr(164):  ¤
Character No 165 (Chr(165):  ¥
Character No 166 (Chr(166):  ¦
Character No 167 (Chr(167):  §
Character No 168 (Chr(168):  ¨
Character No 169 (Chr(169):  ©
Character No 170 (Chr(170):  ª
Character No 171 (Chr(171):  «
Character No 172 (Chr(172):  ¬
Character No 173 (Chr(173):  ­
Character No 174 (Chr(174):  ®
Character No 175 (Chr(175):  ¯
Character No 176 (Chr(176):  °
Character No 177 (Chr(177):  ±
Character No 178 (Chr(178):  ²
Character No 179 (Chr(179):  ³
Character No 180 (Chr(180):  ´
Character No 181 (Chr(181):  µ
Character No 182 (Chr(182):  ¶
Character No 183 (Chr(183):  ·
Character No 184 (Chr(184):  ¸
Character No 185 (Chr(185):  ¹
Character No 186 (Chr(186):  º
Character No 187 (Chr(187):  »
Character No 188 (Chr(188):  ¼
Character No 189 (Chr(189):  ½
Character No 190 (Chr(190):  ¾
Character No 191 (Chr(191):  ¿
Character No 192 (Chr(192):  À
Character No 193 (Chr(193):  Á
Character No 194 (Chr(194):  Â
Character No 195 (Chr(195):  Ã
Character No 196 (Chr(196):  Ä
Character No 197 (Chr(197):  Å
Character No 198 (Chr(198):  Æ
Character No 199 (Chr(199):  Ç
Character No 200 (Chr(200):  È
Character No 201 (Chr(201):  É
Character No 202 (Chr(202):  Ê
Character No 203 (Chr(203):  Ë
Character No 204 (Chr(204):  Ì
Character No 205 (Chr(205):  Í
Character No 206 (Chr(206):  Î
Character No 207 (Chr(207):  Ï
Character No 208 (Chr(208):  Ð
Character No 209 (Chr(209):  Ñ
Character No 210 (Chr(210):  Ò
Character No 211 (Chr(211):  Ó
Character No 212 (Chr(212):  Ô
Character No 213 (Chr(213):  Õ
Character No 214 (Chr(214):  Ö
Character No 215 (Chr(215):  ×
Character No 216 (Chr(216):  Ø
Character No 217 (Chr(217):  Ù
Character No 218 (Chr(218):  Ú
Character No 219 (Chr(219):  Û
Character No 220 (Chr(220):  Ü
Character No 221 (Chr(221):  Ý
Character No 222 (Chr(222):  Þ
Character No 223 (Chr(223):  ß
Character No 224 (Chr(224):  à
Character No 225 (Chr(225):  á
Character No 226 (Chr(226):  â
Character No 227 (Chr(227):  ã
Character No 228 (Chr(228):  ä
Character No 229 (Chr(229):  å
Character No 230 (Chr(230):  æ
Character No 231 (Chr(231):  ç
Character No 232 (Chr(232):  è
Character No 233 (Chr(233):  é
Character No 234 (Chr(234):  ê
Character No 235 (Chr(235):  ë
Character No 236 (Chr(236):  ì
Character No 237 (Chr(237):  í
Character No 238 (Chr(238):  î
Character No 239 (Chr(239):  ï
Character No 240 (Chr(240):  ð
Character No 241 (Chr(241):  ñ
Character No 242 (Chr(242):  ò
Character No 243 (Chr(243):  ó
Character No 244 (Chr(244):  ô
Character No 245 (Chr(245):  õ
Character No 246 (Chr(246):  ö
Character No 247 (Chr(247):  ÷
Character No 248 (Chr(248):  ø
Character No 249 (Chr(249):  ù
Character No 250 (Chr(250):  ú
Character No 251 (Chr(251):  û
Character No 252 (Chr(252):  ü
Character No 253 (Chr(253):  ý
Character No 254 (Chr(254):  þ
Character No 255 (Chr(255):  ÿCharacter No 8 (Chr(8):     [Backspace]
Character No 9 (Chr(9): 	[Tab]               (vbTab)
Character No 10 (Chr(10):   [Line Feed Return]  (vbLf)
Character No 11 (Chr(11):   [Shift+Enter]       (vbVerticalTab)
Character No 12 (Chr(12):   [Page Break]        (vbFormFeed)
Character No 13 (Chr(13):   [Carriage Return]   (vbCr)
Character No 14 (Chr(14):   [Column Break]
Character No 15 (Chr(15):   [Shift In]
Character No 32 (Chr(32):  (space)
Character No 33 (Chr(33):  !
Character No 34 (Chr(34):  "
Character No 35 (Chr(35):  #
Character No 36 (Chr(36):  $
Character No 37 (Chr(37):  %
Character No 38 (Chr(38):  &
Character No 39 (Chr(39):  '
Character No 40 (Chr(40):  (
Character No 41 (Chr(41):  )
Character No 42 (Chr(42):  *
Character No 43 (Chr(43):  +
Character No 44 (Chr(44):  ,
Character No 45 (Chr(45):  -
Character No 46 (Chr(46):  .
Character No 47 (Chr(47):  /
Character No 48 (Chr(48):  0
Character No 49 (Chr(49):  1
Character No 50 (Chr(50):  2
Character No 51 (Chr(51):  3
Character No 52 (Chr(52):  4
Character No 53 (Chr(53):  5
Character No 54 (Chr(54):  6
Character No 55 (Chr(55):  7
Character No 56 (Chr(56):  8
Character No 57 (Chr(57):  9
Character No 58 (Chr(58):  :
Character No 59 (Chr(59):  ;
Character No 60 (Chr(60):  <
Character No 61 (Chr(61):  =
Character No 62 (Chr(62):  >
Character No 63 (Chr(63):  ?
Character No 64 (Chr(64):  @
Character No 65 (Chr(65):  A
Character No 66 (Chr(66):  B
Character No 67 (Chr(67):  C
Character No 68 (Chr(68):  D
Character No 69 (Chr(69):  E
Character No 70 (Chr(70):  F
Character No 71 (Chr(71):  G
Character No 72 (Chr(72):  H
Character No 73 (Chr(73):  I
Character No 74 (Chr(74):  J
Character No 75 (Chr(75):  K
Character No 76 (Chr(76):  L
Character No 77 (Chr(77):  M
Character No 78 (Chr(78):  N
Character No 79 (Chr(79):  O
Character No 80 (Chr(80):  P
Character No 81 (Chr(81):  Q
Character No 82 (Chr(82):  R
Character No 83 (Chr(83):  S
Character No 84 (Chr(84):  T
Character No 85 (Chr(85):  U
Character No 86 (Chr(86):  V
Character No 87 (Chr(87):  W
Character No 88 (Chr(88):  X
Character No 89 (Chr(89):  Y
Character No 90 (Chr(90):  Z
Character No 91 (Chr(91):  [
Character No 92 (Chr(92):  \
Character No 93 (Chr(93):  ]
Character No 94 (Chr(94):  ^
Character No 95 (Chr(95):  _
Character No 96 (Chr(96):  `
Character No 97 (Chr(97):  a
Character No 98 (Chr(98):  b
Character No 99 (Chr(99):  c
Character No 100 (Chr(100):  d
Character No 101 (Chr(101):  e
Character No 102 (Chr(102):  f
Character No 103 (Chr(103):  g
Character No 104 (Chr(104):  h
Character No 105 (Chr(105):  i
Character No 106 (Chr(106):  j
Character No 107 (Chr(107):  k
Character No 108 (Chr(108):  l
Character No 109 (Chr(109):  m
Character No 110 (Chr(110):  n
Character No 111 (Chr(111):  o
Character No 112 (Chr(112):  p
Character No 113 (Chr(113):  q
Character No 114 (Chr(114):  r
Character No 115 (Chr(115):  s
Character No 116 (Chr(116):  t
Character No 117 (Chr(117):  u
Character No 118 (Chr(118):  v
Character No 119 (Chr(119):  w
Character No 120 (Chr(120):  x
Character No 121 (Chr(121):  y
Character No 122 (Chr(122):  z
Character No 123 (Chr(123):  {
Character No 124 (Chr(124):  |
Character No 125 (Chr(125):  }
Character No 126 (Chr(126):  ~
Character No 127 (Chr(127):  
Character No 128 (Chr(128):  €
Character No 129 (Chr(129):  
Character No 130 (Chr(130):  ‚
Character No 131 (Chr(131):  ƒ
Character No 132 (Chr(132):  „
Character No 133 (Chr(133):  …
Character No 134 (Chr(134):  †
Character No 135 (Chr(135):  ‡
Character No 136 (Chr(136):  ˆ
Character No 137 (Chr(137):  ‰
Character No 138 (Chr(138):  Š
Character No 139 (Chr(139):  ‹
Character No 140 (Chr(140):  Œ
Character No 141 (Chr(141):  
Character No 142 (Chr(142):  Ž
Character No 143 (Chr(143):  
Character No 144 (Chr(144):  
Character No 145 (Chr(145):  ‘
Character No 146 (Chr(146):  ’
Character No 147 (Chr(147):  “
Character No 148 (Chr(148):  ”
Character No 149 (Chr(149):  •
Character No 150 (Chr(150):  –
Character No 151 (Chr(151):  —
Character No 152 (Chr(152):  ˜
Character No 153 (Chr(153):  ™
Character No 154 (Chr(154):  š
Character No 155 (Chr(155):  ›
Character No 156 (Chr(156):  œ
Character No 157 (Chr(157):  
Character No 158 (Chr(158):  ž
Character No 159 (Chr(159):  Ÿ
Character No 160 (Chr(160):   
Character No 161 (Chr(161):  ¡
Character No 162 (Chr(162):  ¢
Character No 163 (Chr(163):  £
Character No 164 (Chr(164):  ¤
Character No 165 (Chr(165):  ¥
Character No 166 (Chr(166):  ¦
Character No 167 (Chr(167):  §
Character No 168 (Chr(168):  ¨
Character No 169 (Chr(169):  ©
Character No 170 (Chr(170):  ª
Character No 171 (Chr(171):  «
Character No 172 (Chr(172):  ¬
Character No 173 (Chr(173):  ­
Character No 174 (Chr(174):  ®
Character No 175 (Chr(175):  ¯
Character No 176 (Chr(176):  °
Character No 177 (Chr(177):  ±
Character No 178 (Chr(178):  ²
Character No 179 (Chr(179):  ³
Character No 180 (Chr(180):  ´
Character No 181 (Chr(181):  µ
Character No 182 (Chr(182):  ¶
Character No 183 (Chr(183):  ·
Character No 184 (Chr(184):  ¸
Character No 185 (Chr(185):  ¹
Character No 186 (Chr(186):  º
Character No 187 (Chr(187):  »
Character No 188 (Chr(188):  ¼
Character No 189 (Chr(189):  ½
Character No 190 (Chr(190):  ¾
Character No 191 (Chr(191):  ¿
Character No 192 (Chr(192):  À
Character No 193 (Chr(193):  Á
Character No 194 (Chr(194):  Â
Character No 195 (Chr(195):  Ã
Character No 196 (Chr(196):  Ä
Character No 197 (Chr(197):  Å
Character No 198 (Chr(198):  Æ
Character No 199 (Chr(199):  Ç
Character No 200 (Chr(200):  È
Character No 201 (Chr(201):  É
Character No 202 (Chr(202):  Ê
Character No 203 (Chr(203):  Ë
Character No 204 (Chr(204):  Ì
Character No 205 (Chr(205):  Í
Character No 206 (Chr(206):  Î
Character No 207 (Chr(207):  Ï
Character No 208 (Chr(208):  Ð
Character No 209 (Chr(209):  Ñ
Character No 210 (Chr(210):  Ò
Character No 211 (Chr(211):  Ó
Character No 212 (Chr(212):  Ô
Character No 213 (Chr(213):  Õ
Character No 214 (Chr(214):  Ö
Character No 215 (Chr(215):  ×
Character No 216 (Chr(216):  Ø
Character No 217 (Chr(217):  Ù
Character No 218 (Chr(218):  Ú
Character No 219 (Chr(219):  Û
Character No 220 (Chr(220):  Ü
Character No 221 (Chr(221):  Ý
Character No 222 (Chr(222):  Þ
Character No 223 (Chr(223):  ß
Character No 224 (Chr(224):  à
Character No 225 (Chr(225):  á
Character No 226 (Chr(226):  â
Character No 227 (Chr(227):  ã
Character No 228 (Chr(228):  ä
Character No 229 (Chr(229):  å
Character No 230 (Chr(230):  æ
Character No 231 (Chr(231):  ç
Character No 232 (Chr(232):  è
Character No 233 (Chr(233):  é
Character No 234 (Chr(234):  ê
Character No 235 (Chr(235):  ë
Character No 236 (Chr(236):  ì
Character No 237 (Chr(237):  í
Character No 238 (Chr(238):  î
Character No 239 (Chr(239):  ï
Character No 240 (Chr(240):  ð
Character No 241 (Chr(241):  ñ
Character No 242 (Chr(242):  ò
Character No 243 (Chr(243):  ó
Character No 244 (Chr(244):  ô
Character No 245 (Chr(245):  õ
Character No 246 (Chr(246):  ö
Character No 247 (Chr(247):  ÷
Character No 248 (Chr(248):  ø
Character No 249 (Chr(249):  ù
Character No 250 (Chr(250):  ú
Character No 251 (Chr(251):  û
Character No 252 (Chr(252):  ü
Character No 253 (Chr(253):  ý
Character No 254 (Chr(254):  þ
Character No 255 (Chr(255):  ÿ

 

 

Login

Sign up now and upload your code to the website.

Help us to continue.....
Statistics
Articles View Hits
2284715
Latest Articles