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

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

Selected Characters from VBA"s Character Code Set

   <source lang="vb">

Character Code Character 8 backspace 9 Tab 10 linefeed 13 carriage return 32 [space] 33  ! 34 " 35 # 36 $ 37  % 38 & 39 " 40 ( 41 ) 42 * 43 + 44 , 45 - 46 . 47 / 48 0 49 1 50 2 51 3 52 4 53 5 54 6 55 7 56 8 57 9 58  : 59  ; 60 < 61 = 62 > 63  ? 64 @ 65 A 66 B 67 C 68 D 69 E 70 F 71 G 72 H 73 I 74 J 75 K 76 L 77 M 78 N 79 O 80 P 81 Q 82 R 83 S 84 T 85 U 86 V 87 W 88 X 89 Y 90 Z 91 [ 92 \ 93 ] 94 ^ 95 _ 96 " 97 a 98 b 99 c 100 d 101 e 102 f 103 g 104 h 105 i 106 j 107 k 108 l 109 m 110 n 111 o 112 p 113 q 114 r 115 s 116 t 117 u 118 v 119 w 120 x 121 y 122 z 123 { 124 | 125 } 126 ~

</source>
   
  


Use the Asc() function to convert a character to its numerical representation

   <source lang="vb">

Sub ascDemo()

   Dim num1 As Integer
   num1 = Asc("A")

End Sub

</source>
   
  


Use the Chr() and Asc() functions to convert between the numerical and string representations of VBA"s character code set

   <source lang="vb">

Sub chrDemo()

   MsgBox Chr(65)

End Sub

</source>