close
常用ASCII CHR碼對照
因為在寫VBA的時候，常常有些特殊符號無法寫入程式碼，所以用ASCII來代替。
例如：
"→Chr(34)來解決問題
&→Chr(38)
| Chr(0) | Null | Chr(48) | 0 | Chr(78) | N | Chr(108) | l |
| Chr(8) | 退格 | Chr(49) | 1 | Chr(79) | O | Chr(109) | m |
| Chr(9) | Tab | Chr(50) | 2 | Chr(80) | P | Chr(110) | n |
| Chr(10) | 换行 | Chr(51) | 3 | Chr(81) | Q | Chr(111) | o |
| Chr(12) | 换页 | Chr(52) | 4 | Chr(82) | R | Chr(112) | p |
| Chr(13) | Enter | Chr(53) | 5 | Chr(83) | S | Chr(113) | q |
| Chr(22) | 粘贴 | Chr(54) | 6 | Chr(84) | T | Chr(114) | r |
| Chr(26) | 撤销 | Chr(55) | 7 | Chr(85) | U | Chr(115) | s |
| Chr(27) | Esc | Chr(56) | 8 | Chr(86) | V | Chr(116) | t |
| Chr(28) | 文件分隔符 | Chr(57) | 9 | Chr(87) | W | Chr(117) | u |
| Chr(29) | 分组符 | Chr(58) | : | Chr(88) | X | Chr(118) | v |
| Chr(30) | 記錄分離符號 | Chr(59) | ; | Chr(89) | Y | Chr(119) | w |
| Chr(31) | 單元分隔符號 | Chr(60) | < | Chr(90) | Z | Chr(120) | x |
| Chr(32) | 空格SPACE | Chr(61) | = | Chr(91) | [ | Chr(121) | y |
| Chr(33) | ! | Chr(62) | > | Chr(92) | \ | Chr(122) | z |
| Chr(33) | ! | Chr(63) | ? | Chr(93) | ] | Chr(123) | { |
| Chr(34) | “ | Chr(64) | @ | Chr(94) | ^ | Chr(124) | | |
| Chr(35) | # | Chr(65) | A | Chr(95) | _ | Chr(125) | } |
| Chr(36) | $ | Chr(66) | B | Chr(96) | ` | Chr(126) | ~ |
| Chr(37) | % | Chr(67) | C | Chr(97) | a | Chr(127) | 删除 |
| Chr(38) | & | Chr(68) | D | Chr(98) | b | Chr(128) | € |
| Chr(39) | ‘ | Chr(69) | E | Chr(99) | c | ||
| Chr(40) | ( | Chr(70) | F | Chr(100) | d | ||
| Chr(41) | ) | Chr(71) | G | Chr(101) | e | ||
| Chr(42) | * | Chr(72) | H | Chr(102) | f | ||
| Chr(43) | + | Chr(73) | I | Chr(103) | g | ||
| Chr(44) | , | Chr(74) | J | Chr(104) | h | ||
| Chr(45) | – | Chr(75) | K | Chr(105) | i | ||
| Chr(46) | . | Chr(76) | L | Chr(106) | j | ||
| Chr(47) | / | Chr(77) | M | Chr(107) | k |
全站熱搜
留言列表
旅行這個地球 (9)
{{ article.title }}