1ãOption Explicitãå½ä½¿ç¨Option Explicitæ¶ï¼å¿
é¡»å¨æ¨¡åä¸çææè¿ç¨å£°ææ¯ä¸ä¸ªåéï¼å¦åä¼åºç°è¯æ³é误并ä¸è½è¢«ç¼è¯ãè¿æ ·åç好å¤æ¯ï¼å®è½æ¶é¤ç¨åºä¸å 为éæ¼åéåè导è´ç¨åºé误ï¼æ以è§æ使ç¨æ¤é项ãèªå¨è®¾å®çæ¹æ³ï¼å¨VBAç¼è¾å¨å·¥å
·èåä¸é项éçç¼è¾å¨éå¡ä¸çè¦æ±å£°æåéé项éä¸å³å¯ãè¿ä¸ªæ¯æ¬¡æå
¥æ°æ¨¡åæ¶ä¼èªå¨æå
¥æ¤å£°æã
ãã2ãOption Private Moduleãå½ä½¿ç¨æ¤è®¾å®æ¶ï¼æ¨¡åä¸ç代ç å°æ 记为ç§æï¼è¿æ ·å¨å®å¯¹è¯æ¡ä¸å°±ä¸è½çå°è¿äºä»£ç ï¼ä¹å°±æ¯å¨Excel主çé¢çå·¥å
·/å®/å®ç对è¯æ¡ä¸ä¸ä¼æ¾ç¤ºç§æçåç¨åºå称ï¼è¿ä¹é²æ¢äºæ¨¡åçå
容被å
¶å®å·¥ç¨å¼ç¨ï¼ä¸è¿å¨åä¸å·¥ç¨ä¸çå
¶å®æ¨¡åä»ç¶æ¯å¯ç¨çã
ãã3ãOption Compare {Binary | Text | Database}ãç¨äºå£°æå符串æ¯è¾æ¶æç¨ç缺çæ¯è¾æ¹æ³ãå¦æ模åä¸æ²¡æ Option Compare è¯å¥ï¼å缺ççææ¬æ¯è¾æ¹æ³æ¯ Binaryã
ããOption Compare Binary æ¯æ ¹æ®å符çå
é¨äºè¿å¶è¡¨ç¤ºè导åºçä¸ç§æåºé¡ºåºæ¥è¿è¡å符串æ¯è¾ãå¨ Microsoft Windows ä¸ï¼æåºé¡ºåºç±ä»£ç 页确å®ãå
¸åçäºè¿å¶æåºé¡ºåºå¦ä¸ä¾æ示ï¼
ããA < B < E < Z < a < b < e < z < _ < _ < _ < _ < _ < ?
ããOption Compare Text æ ¹æ®ç±ç³»ç»åºåç¡®å®çä¸ç§ä¸åºå大å°åçææ¬æåºçº§å«æ¥è¿è¡å符串æ¯è¾ãå½ä½¿ç¨ Option Compare Text 对ç¸åå符æåºæ¶ï¼ä¼äº§çä¸è¿°ææ¬æåºçº§å«ï¼
ãã(A=a) < ( _=_) < (B=b) < (E=e) < (_=_) < (Z=z) < (_=_)ã
ããOption Compare Database åªè½å¨ Microsoft Access ä¸ä½¿ç¨ãå½éè¦å符串æ¯è¾æ¶ï¼å°æ ¹æ®æ°æ®åºçåºå ID ç¡®å®çæåºçº§å«è¿è¡æ¯è¾ã
ãã4ãOption Base {0 | 1}ãç¨æ¥å£°ææ°ç»ä¸æ ç缺çä¸çã
ãã注æ DimãPrivateãPublicãReDim 以å Static è¯å¥ä¸ç To åå¥æä¾äºä¸ç§æ´çµæ´»çæ¹å¼æ¥æ§å¶æ°ç»çä¸æ ãä¸è¿ï¼å¦æ没æä½¿ç¨ To åå¥æ¾å¼å°æå®ä¸çï¼åå¯ä»¥ä½¿ç¨ Option Base å°ç¼ºçä¸ç设为 1ãä½¿ç¨ Array å½æ°æ ParamArray å
³é®åå建çæ°ç»çä¸ç为 0ï¼Option Base 对 Array æ ParamArray ä¸èµ·ä½ç¨ã
ããOption Base è¯å¥åªå½±åä½äºå
å«è¯¥è¯å¥ç模åä¸çæ°ç»ä¸ç
温馨提示:答案为网友推荐,仅供参考