VBAå
±æ12ç§æ°æ®ç±»åã
åå«æ¯ï¼æ°æ®ç±»åãå符串åãå¸å°åãæ´æ°åãé¿æ´æ°åãå精度åãå精度åãæ¥æåãè´§å¸åãå°æ°ç¹åãåä½åãå¯å对象åã
1ï¼VBAå 许使ç¨æªå®ä¹çåéï¼é»è®¤æ¯åä½åéã
2ï¼å¨æ¨¡åéç¨è¯´æé¨ä»½ï¼å å ¥ Option Explicit è¯å¥å¯ä»¥å¼ºè¿«ç¨æ·è¿è¡åéå®ä¹ã
3ï¼åéå®ä¹è¯å¥ååéä½ç¨å
Dim åéas ç±»åå®ä¹ä¸ºå±é¨åéï¼å¦ Dim xyz as integer
Private åéas ç±»åå®ä¹ä¸ºç§æåéï¼å¦ Private xyz as byte
Public åéas ç±»åå®ä¹ä¸ºå ¬æåéï¼å¦ Public xyz as single
Global åéas ç±»åå®ä¹ä¸ºå ¨å±åéï¼å¦ Globlal xyz as date
Static åéas ç±»åå®ä¹ä¸ºéæåéï¼å¦ Static xyz as double
ä¸è¬åéä½ç¨åçååæ¯ï¼é£é¨ä»½å®ä¹å°±å¨é£é¨ä»½èµ·ä½ç¨ï¼æ¨¡åä¸å®ä¹åå¨è¯¥æ¨¡åé£ä½ç¨ã