Visual Basic for Applications Tips And Tricks

by MD on 2009/09/26

1. Line feed
For line feed use vbCrLf which is Carriage Return & Line Feed
or you can simply use Chr(13) or better is Chr$(13)

A. Use the Chr() and Asc() functions to convert between the numerical and string representations of VBA\’s character code set
B. Use the Asc() function to convert a character to its numerical representation

Here is the list of all the character code
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 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 ~

Posted via email from mukeshdak’s posterous

You may also like:

{ 1 comment… read it below or add one }

real estate mutual funds October 6, 2009 at 19:13

There’s good info here. I did a search on the topic and found most people will agree with your blog. Keep up the good work mate! :)

Leave a Comment

Previous post:

Next post: