{"id":11386,"date":"2022-09-11T18:29:45","date_gmt":"2022-09-11T09:29:45","guid":{"rendered":"https:\/\/prodskill.com\/?p=11386"},"modified":"2022-10-11T11:42:21","modified_gmt":"2022-10-11T02:42:21","slug":"excel-vba-lecture-8-datatype","status":"publish","type":"post","link":"https:\/\/prodskill.com\/zh\/excel-vba-lecture-8-datatype\/","title":{"rendered":"Excel VBA\u6559\u7a0b\uff08\u516b\uff09\uff1aExcel VBA\u8bed\u8a00\u57fa\u7840\u2014\u2014\u6570\u636e\u7c7b\u578b\u3001\u6570\u636e\u7ed3\u6784"},"content":{"rendered":"<p>\u5728\u672c\u6587\u4e2d\uff0c\u6211\u4eec\u5c06\u4e86\u89e3 Excel VBA \u8bed\u8a00\u57fa\u7840\u77e5\u8bc6\u4e2d\u7684\u6570\u636e\u7c7b\u578b\u548c\u63d0\u4f9b\u7684\u6570\u636e\u7ed3\u6784\u3002<\/p>\n\n\n\n<p>\u8fd9\u662f\u4e0a\u4e00\u7bc7\u6587\u7ae0\u7684\u5ef6\u7eed\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/\">Excel VBA\u6559\u7a0b\uff08\u4e03\uff09\uff1aExcel VBA\u8bed\u8a00\u57fa\u7840\u2014\u2014\u8bed\u6cd5<\/a><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;\u76ee\u5f55&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\u5207\u6362\u76ee\u5f55\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">\u5207\u6362<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-8-datatype\/#33_%EC%9E%90%EB%A3%8C%ED%98%95\" >3.3.\u6570\u636e\u7c7b\u578b<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-8-datatype\/#331_%EA%B8%B0%EB%B3%B8_%EC%9E%90%EB%A3%8C%ED%98%95\" >3.3.1.\u57fa\u672c\u6570\u636e\u7c7b\u578b<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-8-datatype\/#%EA%B8%B0%EB%B3%B8_%EC%9E%90%EB%A3%8C%ED%98%95_%EB%AA%A9%EB%A1%9D\" >\u57fa\u672c\u6570\u636e\u7c7b\u578b\u5217\u8868<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-8-datatype\/#Variant_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%98%95%EC%8B%9D\" >\u53d8\u4f53\u6570\u636e\u7c7b\u578b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-8-datatype\/#User-defined%EC%82%AC%EC%9A%A9%EC%9E%90_%EC%A0%95%EC%9D%98_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%98%95%EC%8B%9D\" >\u7528\u6237\u81ea\u5b9a\u4e49\u6570\u636e\u7c7b\u578b<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-8-datatype\/#332_%EC%9E%90%EB%A3%8C%EA%B5%AC%EC%A1%B0\" >3.3.2.\u6570\u636e\u7ed3\u6784<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-8-datatype\/#Array\" >\u5927\u6279<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-8-datatype\/#Collection\" >\u6536\u85cf<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-8-datatype\/#Dictionary\" >\u5b57\u5178<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"3.3._\uc790\ub8cc\ud615\"><span class=\"ez-toc-section\" id=\"33_%EC%9E%90%EB%A3%8C%ED%98%95\"><\/span>3.3.\u6570\u636e\u7c7b\u578b<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3.3.1._\uae30\ubcf8_\uc790\ub8cc\ud615\"><span class=\"ez-toc-section\" id=\"331_%EA%B8%B0%EB%B3%B8_%EC%9E%90%EB%A3%8C%ED%98%95\"><\/span>3.3.1.\u57fa\u672c\u6570\u636e\u7c7b\u578b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u4e0b\u8868\u603b\u7ed3\u4e86 VB\uff08\u6216 VBA\uff09\u652f\u6301\u7684\u6570\u636e\u7c7b\u578b\u3002\u4e0b\u9762\u6e90\u7801\u7684\u8868\u5185\u5bb9\u4e2d\uff0cCollection\u548cDictionary\u5728\u201c\u6570\u636e\u7ed3\u6784\u201d\u4e2d\u5206\u522b\u89e3\u91ca\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"\uae30\ubcf8_\uc790\ub8cc\ud615_\ubaa9\ub85d\"><span class=\"ez-toc-section\" id=\"%EA%B8%B0%EB%B3%B8_%EC%9E%90%EB%A3%8C%ED%98%95_%EB%AA%A9%EB%A1%9D\"><\/span>\u57fa\u672c\u6570\u636e\u7c7b\u578b\u5217\u8868<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u8d44\u6e90\uff1a&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/data-type-summary\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/data-type-summary<\/a><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>\u6570\u636e\u683c\u5f0f<\/strong><\/td><td><strong>\u5b58\u50a8\u5bb9\u91cf<\/strong><\/td><td><strong>\u8303\u56f4<\/strong><\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/boolean-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">\u5e03\u5c14\u503c<\/a><\/strong><\/td><td>2\u4e2a\u5b57\u8282<\/td><td><strong>\u771f\u7684<\/strong>&nbsp;\u6216\u8005&nbsp;<strong>\u9519\u8bef\u7684<\/strong><\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/byte-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">\u5b57\u8282<\/a><\/strong><\/td><td>1\u5b57\u8282<\/td><td>0 ~ 255<\/td><\/tr><tr><td><strong>\u6536\u85cf<\/strong><\/td><td>\u672a\u77e5<\/td><td>\u672a\u77e5<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/currency-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">\u8d27\u5e01<\/a><\/strong>&nbsp;\uff08\u7f29\u653e\u6574\u6570\uff09<\/td><td>8\u5b57\u8282<\/td><td>-922,337,203,685,477.5808 ~ 922,337,203,685,477.5807<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/date-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">\u65e5\u671f<\/a><\/strong><\/td><td>8\u5b57\u8282<\/td><td>100\u5e741\u67081\u65e5\u81f39999\u5e7412\u670831\u65e5<br>(100-01-01 ~ 9999-12-31)<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/decimal-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">\u5341\u8fdb\u5236<\/a><\/strong><\/td><td>14\u5b57\u8282<\/td><td>+\/-79,228,162,514,264,337,593,543,950,335 \u6ca1\u6709\u5c0f\u6570\u70b9<br><br>+\/-7.9228162514264337593543950335 \u5c0f\u6570\u70b9\u53f3\u8fb9 28 \u4f4d<br><br>\u6700\u5c0f\u7684\u975e\u96f6\u6570\u662f+\/-0.0000000000000000000000000001<\/td><\/tr><tr><td><strong>\u5b57\u5178<\/strong><\/td><td>\u672a\u77e5<\/td><td>\u672a\u77e5<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/double-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">\u53cc\u500d\u7684<\/a><\/strong>&nbsp;\uff08\u53cc\u7cbe\u5ea6\u6d6e\u70b9\u6570\uff09<\/td><td>8\u5b57\u8282<\/td><td>-1.79769313486231E308 \u5230 -4.94065645841247E-324 \u4e3a\u8d1f\u503c<br><br>4.94065645841247E-324 \u5230 1.79769313486232E308 \u4e3a\u6b63\u503c<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/integer-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">\u6574\u6570<\/a><\/strong><\/td><td>2\u4e2a\u5b57\u8282<\/td><td>-32,768 \u81f3 32,767<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/long-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">\u957f<\/a><\/strong>&nbsp;\uff08\u957f\u6574\u578b\uff09<\/td><td>4\u5b57\u8282<\/td><td>-2,147,483,648 \u81f3 2,147,483,647<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/longlong-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">\u9f99\u9f99<\/a><\/strong>&nbsp;(LongLong \u6574\u6570)<\/td><td>8\u5b57\u8282<\/td><td>-9,223,372,036,854,775,808\u81f39,223,372,036,854,775,807<br><br>\u4ec5\u5728 64 \u4f4d\u5e73\u53f0\u4e0a\u6709\u6548\u3002<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/longptr-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">\u957f\u6307\u9488<\/a><\/strong>&nbsp;\uff0832 \u4f4d\u7cfb\u7edf\u4e0a\u4e3a\u957f\u6574\u6570\uff0c64 \u4f4d\u7cfb\u7edf\u4e0a\u4e3a LongLong \u6574\u6570\uff09<\/td><td>\u5728 32 \u4f4d\u7cfb\u7edf\u4e0a\u4e3a 4 \u4e2a\u5b57\u8282<br><br>64 \u4f4d\u7cfb\u7edf\u4e0a\u4e3a 8 \u4e2a\u5b57\u8282<\/td><td>-2,147,483,648 \u5230 2,147,483,647 \u5728 32 \u4f4d\u7cfb\u7edf\u4e0a<br><br>-9,223,372,036,854,775,808 \u5230 9,223,372,036,854,775,807 \u5728 64 \u4f4d\u7cfb\u7edf\u4e0a<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/object-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">\u76ee\u7684<\/a><\/strong><\/td><td>4\u5b57\u8282<\/td><td>\u4efb\u4f55&nbsp;<strong>\u76ee\u7684<\/strong>&nbsp;\u53c2\u8003<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/single-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">\u5355\u8eab\u7684<\/a><\/strong>&nbsp;\uff08\u5355\u7cbe\u5ea6\u6d6e\u70b9\u6570\uff09<\/td><td>4\u5b57\u8282<\/td><td>-3.402823E38 \u5230 -1.401298E-45 \u4e3a\u8d1f\u503c<br><br>1.401298E-45 \u5230 3.402823E38 \u5bf9\u4e8e\u6b63\u503c<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/string-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">\u7ec6\u7ef3<\/a><\/strong>&nbsp;\uff08\u53ef\u53d8\u957f\u5ea6\uff09<\/td><td>10 \u4e2a\u5b57\u8282 + \u5b57\u7b26\u4e32\u957f\u5ea6<\/td><td>0 \u5230\u5927\u7ea6 20 \u4ebf<\/td><\/tr><tr><td><strong>\u7ec6\u7ef3<\/strong>&nbsp;\uff08\u56fa\u5b9a\u957f\u5ea6\uff09<\/td><td>\u5b57\u7b26\u4e32\u957f\u5ea6<\/td><td>1 \u81f3\u5927\u7ea6 65,400<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/variant-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">\u53d8\u4f53<\/a><\/strong>&nbsp;\uff08\u5e26\u6570\u5b57\uff09<\/td><td>16\u5b57\u8282<\/td><td>\u8303\u56f4\u5185\u7684\u4efb\u4f55\u6570\u503c&nbsp;<strong>\u53cc\u500d\u7684<\/strong><\/td><\/tr><tr><td><strong>\u53d8\u4f53<\/strong>&nbsp;\uff08\u5e26\u5b57\u7b26\uff09<\/td><td>22 \u5b57\u8282 + \u5b57\u7b26\u4e32\u957f\u5ea6\uff0864 \u4f4d\u7cfb\u7edf\u4e0a\u4e3a 24 \u5b57\u8282\uff09<\/td><td>\u4e0e\u53ef\u53d8\u957f\u5ea6\u76f8\u540c\u7684\u8303\u56f4&nbsp;<strong>\u7ec6\u7ef3<\/strong><\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/how-to\/user-defined-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">\u7528\u6237\u81ea\u5b9a\u4e49<\/a><\/strong>&nbsp;\uff08\u4f7f\u7528&nbsp;<strong>\u7c7b\u578b<\/strong>)<\/td><td>\u5143\u7d20\u6240\u9700\u7684\u6570\u91cf<\/td><td>\u6bcf\u4e2a\u5143\u7d20\u7684\u8303\u56f4\u4e0e\u5176\u6570\u636e\u7c7b\u578b\u7684\u8303\u56f4\u76f8\u540c\u3002<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u5176\u4e2d\uff0c\u4f7f\u7528\u9891\u7387\u6700\u9ad8\u7684\u6570\u636e\u7c7b\u578b\u6709Int\u3001Long\u3001String\u3001Boolean\u3002<\/p>\n\n\n\n<p>\u53d8\u4f53\u548c\u7528\u6237\u5b9a\u4e49\u7684\u6570\u636e\u7c7b\u578b\u5c06\u5728\u4e0b\u9762\u8fdb\u4e00\u6b65\u89e3\u91ca\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Variant_\ub370\uc774\ud130_\ud615\uc2dd\"><span class=\"ez-toc-section\" id=\"Variant_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%98%95%EC%8B%9D\"><\/span><strong>\u53d8\u4f53\u6570\u636e\u7c7b\u578b<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u53d8\u4f53\u6570\u636e\u7c7b\u578b\u662f\u4e00\u79cd\u7279\u6b8a\u7684\u6570\u636e\u7c7b\u578b\uff0c\u53ef\u4ee5\u5b58\u50a8\u548c\u5904\u7406\u591a\u79cd\u6570\u636e\u7c7b\u578b\u3002\u5982\u679c\u5728\u58f0\u660e\u53d8\u91cf\u65f6\u7701\u7565\u6570\u636e\u7c7b\u578b\uff0c\u5219\u5c06\u5176\u6307\u5b9a\u4e3a Variant \u6570\u636e\u7c7b\u578b\u3002\u6709\u5173 Variant \u6570\u636e\u683c\u5f0f\u7684\u66f4\u591a\u4fe1\u606f\uff0c\u8bf7\u53c2\u9605\u4ee5\u4e0b URL\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/variant-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/variant-data-type<\/a><\/p>\n\n\n\n<p>\u8981\u68c0\u67e5 Variant \u53d8\u91cf\u5728\u6267\u884c\u671f\u95f4\u5b58\u50a8\u7684\u6570\u636e\u7c7b\u578b\uff0c\u8bf7\u4f7f\u7528 VarType \u51fd\u6570\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/vartype-function\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/vartype-function<\/a><\/p>\n\n\n\n<p><strong>\u5efa\u9020<\/strong><\/p>\n\n\n\n<p><strong>\u53d8\u91cf\u7c7b\u578b(<\/strong><em>\u53d8\u91cf\u540d<\/em><strong>)<\/strong><\/p>\n\n\n\n<p>\u57fa\u672c\u7684&nbsp;<em>\u53d8\u91cf\u540d<\/em>&nbsp;\u53c2\u6570\u662f\u5305\u542b\u53d8\u91cf\u7684 Variant\uff0c\u4e0d\u5305\u62ec\u7528\u6237\u5b9a\u4e49\u7c7b\u578b\u7684\u53d8\u91cf\u3002<\/p>\n\n\n\n<p><strong>\u8fd4\u56de<\/strong><strong>\u5f62\u5f0f<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>\u4e00\u4e2a\u5e38\u6570<\/strong><\/td><td><strong>\u4ef7\u503c<\/strong><\/td><td><strong>\u89e3\u91ca<\/strong><\/td><\/tr><tr><td><strong>vb\u7a7a<\/strong><\/td><td>0<\/td><td><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/glossary\/vbe-glossary#empty\" target=\"_blank\" rel=\"noreferrer noopener\">\u7a7a\u7684<\/a>\uff08\u672a\u521d\u59cb\u5316\uff09<\/td><\/tr><tr><td><strong>vbNull<\/strong><\/td><td>1<\/td><td><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/glossary\/vbe-glossary#null\" target=\"_blank\" rel=\"noreferrer noopener\">\u65e0\u6548\u7684<\/a>\uff08\u65e0\u53ef\u7528\u6570\u636e\uff09<\/td><\/tr><tr><td><strong>vb\u6574\u6570<\/strong><\/td><td>2<\/td><td>\u672c\u8d28<\/td><\/tr><tr><td><strong>vb\u957f<\/strong><\/td><td>3<\/td><td>\u957f\u6574\u6570<\/td><\/tr><tr><td><strong>vb\u5355\u8eab<\/strong><\/td><td>4<\/td><td>\u5355\u7cbe\u5ea6\u6d6e\u70b9\u6570<\/td><\/tr><tr><td><strong>vb\u53cc\u7cbe\u5ea6<\/strong><\/td><td>5<\/td><td>\u53cc\u7cbe\u5ea6\u6d6e\u70b9\u6570<\/td><\/tr><tr><td><strong>vb\u8d27\u5e01<\/strong><\/td><td>6<\/td><td>\u8d27\u5e01\u4ef7\u503c<\/td><\/tr><tr><td><strong>\u65e5\u671f<\/strong><\/td><td>7<\/td><td>\u65e5\u671f\u503c<\/td><\/tr><tr><td><strong>vb\u5b57\u7b26\u4e32<\/strong><\/td><td>8<\/td><td>\u7ec6\u7ef3<\/td><\/tr><tr><td><strong>vb\u5bf9\u8c61<\/strong><\/td><td>9<\/td><td>\u4e2a\u4eba<\/td><\/tr><tr><td><strong>vb\u9519\u8bef<\/strong><\/td><td>10<\/td><td>\u9519\u8bef\u503c<\/td><\/tr><tr><td><strong>vb\u5e03\u5c14\u503c<\/strong><\/td><td>11<\/td><td>\u5e03\u5c14\u503c<\/td><\/tr><tr><td><strong>vb\u53d8\u4f53<\/strong><\/td><td>12<\/td><td><strong>\u53d8\u4f53<\/strong>\uff08\u53d8\u4f53&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/glossary\/vbe-glossary#array\" target=\"_blank\" rel=\"noreferrer noopener\">\u5b89\u6392<\/a>\u4ec5\u4f7f\u7528\uff09<\/td><\/tr><tr><td><strong>vb\u6570\u636e\u5bf9\u8c61<\/strong><\/td><td>13<\/td><td>\u6570\u636e\u8bbf\u95ee\u5bf9\u8c61<\/td><\/tr><tr><td><strong>vb\u5c0f\u6570<\/strong><\/td><td>14<\/td><td>\u5341\u8fdb\u5236\u503c<\/td><\/tr><tr><td><strong>vb\u5b57\u8282<\/strong><\/td><td>17<\/td><td>\u5b57\u8282\u503c<\/td><\/tr><tr><td><strong>vb\u6570\u7ec4<\/strong><\/td><td>8192<\/td><td>\u5b89\u6392<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Variant\u6570\u636e\u683c\u5f0f\u6211\u4e2a\u4eba\u7528\u7684\u4e0d\u662f\u5f88\u597d\uff0c\u4e3b\u8981\u662f\u4e00\u6b21\u6027\u8bfb\u5199sheet\u6570\u636e\u7684\u65f6\u5019\u4f7f\u7528\u3002\u5173\u4e8e\u5982\u4f55\u4f7f\u7528\u53d8\u4f53\u6570\u7ec4\u8bfb\u5199\u5927\u91cfsheet\u6570\u636e\uff0c\u53ef\u4ee5\u53c2\u8003\u4e0b\u9762\u7684\u6587\u7ae0\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/zh\/excel-vba-coding-pattern-range-loop-read\/\">VBA \u7f16\u7801\u6a21\u5f0f\uff1a\u8303\u56f4\u5faa\u73af\u8bfb\u53d6<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/zh\/excel-vba-coding-pattern-range-loop-write\/\">VBA \u7f16\u7801\u6a21\u5f0f\uff1a\u8303\u56f4\u5faa\u73af\u5199\u5165<\/a><\/p>\n\n\n\n<p>\u8fd9\u662f\u4f7f\u7528 Variant \u6570\u636e\u7c7b\u578b\u7684\u793a\u4f8b\u4ee3\u7801\u3002\u5b83\u8868\u660e\u5b83\u53ef\u4ee5\u5904\u7406\u6574\u6570\u3001\u5b57\u7b26\u4e32\u3001\u5b9e\u6570\u548c\u65e5\u671f\u6570\u636e\u7c7b\u578b\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">Sub VariantTest()\n    Dim a As Variant '\ub370\uc774\ud130 \ud615\uc2dd\uc744 \uc0dd\ub7b5\ud558\uba74 Variant \ud615\uc2dd\uc784\n    a = 1: Debug.Print a\n    a = \"1\": Debug.Print a\n    a = 1.1: Debug.Print a\n    a = CDate(\"2021-07-31\"): Debug.Print a\nEnd Sub<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"User-defined(\uc0ac\uc6a9\uc790_\uc815\uc758)_\ub370\uc774\ud130_\ud615\uc2dd\"><span class=\"ez-toc-section\" id=\"User-defined%EC%82%AC%EC%9A%A9%EC%9E%90_%EC%A0%95%EC%9D%98_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%98%95%EC%8B%9D\"><\/span><strong>\u7528\u6237\u81ea\u5b9a\u4e49\u6570\u636e\u7c7b\u578b<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u60a8\u53ef\u4ee5\u58f0\u660e\u548c\u4f7f\u7528\u7528\u6237\u5b9a\u4e49\u7684\u6570\u636e\u7c7b\u578b\u3002\u4f7f\u7528\u7c7b\u4f3c\u4e8e C \u8bed\u8a00\u4e2d\u7684 &#039;struct&#039; \u7684 &#039;Type&#039; \u5173\u952e\u5b57\u58f0\u660e\u7528\u6237\u5b9a\u4e49\u7684\u6570\u636e\u7c7b\u578b\u3002\u7528\u6237\u5b9a\u4e49\u7684\u6570\u636e\u7c7b\u578b\u4e0d\u662f\u5bf9\u8c61\uff0c\u6240\u4ee5\u5728\u58f0\u660e\u65f6\uff0c\u4f1a\u521b\u5efa\u4e00\u4e2a\u5b9e\u4f8b\uff0c\u5206\u914d\u5185\u5b58\uff0c\u5e76\u53ef\u4ee5\u8f93\u5165\u503c\u3002<\/p>\n\n\n\n<p>\u6709\u5173\u7528\u6237\u5b9a\u4e49\u6570\u636e\u683c\u5f0f\u7684\u66f4\u591a\u4fe1\u606f\uff0c\u8bf7\u53c2\u9605\u4ee5\u4e0b URL\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/how-to\/user-defined-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/how-to\/user-defined-data-type<\/a><\/p>\n\n\n\n<p>\u7528\u6237\u81ea\u5b9a\u4e49\u6570\u636e\u7c7b\u578b\u7684\u793a\u4f8b\u4ee3\u7801\u5982\u4e0b\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">Type EmployeeRecord    ' \uc0ac\uc6a9\uc790 \uc815\uc758 \ud615\uc2dd\uc744 \ub9cc\ub4ed\ub2c8\ub2e4.\n    ID As Integer    ' \ub370\uc774\ud130 \ud615\uc2dd\uc758 \uc694\uc18c\ub97c \uc815\uc758\ud569\ub2c8\ub2e4.\n    Name As String\n    Address As String\n    Phone As Long\n    HireDate As Date\nEnd Type\n\nSub CreateRecord()\n    Dim MyRecord As EmployeeRecord    ' \ubcc0\uc218\ub97c \uc120\uc5b8\ud569\ub2c8\ub2e4.\n    MyRecord.ID = 12003    ' \uc694\uc18c\uc5d0 \uac12\uc744 \ud560\ub2f9\ud569\ub2c8\ub2e4.\n    MyRecord.Name = \"Andy\"\n    MyRecord.HireDate = CDate(\"2021-07-31\")\nEnd Sub<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3.3.2._\uc790\ub8cc\uad6c\uc870\"><span class=\"ez-toc-section\" id=\"332_%EC%9E%90%EB%A3%8C%EA%B5%AC%EC%A1%B0\"><\/span>3.3.2.\u6570\u636e\u7ed3\u6784<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5e38\u7528\u7684\u6570\u636e\u7ed3\u6784\u5305\u62ec Array\u3001Collection \u548c Dictionary\u3002\u8ba9\u6211\u4eec\u9010\u4e00\u770b\u770b\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Array\"><span class=\"ez-toc-section\" id=\"Array\"><\/span><strong>\u5927\u6279<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u5b83\u6709\u56fa\u5b9a\u6570\u91cf\u7684\u9879\u76ee\u3002\u7531\u4e8e\u5b83\u4e0d\u662f\u5bf9\u8c61\uff0c\u56e0\u6b64\u58f0\u660e\u5b83\u4f1a\u521b\u5efa\u4e00\u4e2a\u5b9e\u4f8b\u3002\u58f0\u660e\u65f6\u53ef\u4ee5\u6307\u5b9a\u7ef4\u6570\u548c\u6bcf\u4e2a\u7ef4\u7684\u4e0b\u9650\u548c\u4e0a\u9650\uff0c\u4e5f\u53ef\u4ee5\u5728\u6267\u884c\u8fc7\u7a0b\u4e2d\u52a8\u6001\u6539\u53d8\u6570\u7ec4\u7684\u7ef4\u6570\u548c\u8303\u56f4\u3002\u5982\u679c\u53ea\u6307\u5b9a\u9879\u76ee\u6570\u800c\u4e0d\u6307\u5b9a\u6bcf\u4e2a\u7ef4\u5ea6\u7684\u4e0b\u9650\u548c\u4e0a\u9650\uff0c\u5219\u4e0b\u9650\u9ed8\u8ba4\u4e3a 0\u3002\u5982\u679c\u4f7f\u7528 Option Base 1\uff0c\u5219\u9ed8\u8ba4\u4e0b\u9650\u4e3a 1\u3002<\/p>\n\n\n\n<p>\u58f0\u660e\u793a\u4f8b\u4ee3\u7801<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">Dim DayArray(50)\nDim Matrix(3, 4) As Integer\nDim MyMatrix(1 To 5, 4 To 9, 3 To 5) As Double<\/pre>\n\n\n\n<p>\u58f0\u660e\u6bcf\u4e2a\u7ef4\u5ea6\u7684\u4e0b\u9650\/\u4e0a\u9650\uff0c\u68c0\u67e5\uff1a\u4f7f\u7528LBound\u3001UBound<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">Dim A(1 To 100, 0 To 3, -3 To 4) \nLBound(A, 1) ->  1,  UBound(A, 1) -> 100 ' 1\ucc28\uc6d0 \ud558\ud55c\/\uc0c1\ud55c\nLBound(A, 2) ->  0,  UBound(A, 2) -> 3   ' 2\ucc28\uc6d0 \ud558\ud55c\/\uc0c1\ud55c\nLBound(A, 3) -> -3,  UBound(A, 3) -> 4   ' 3\ucc28\uc6d0 \ud558\ud55c\/\uc0c1\ud55c<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p>\u7ef4\u5ea6\u5927\u5c0f\u66f4\u6539\uff1a\u4f7f\u7528 Redim \u8bed\u53e5\u66f4\u6539\u52a8\u6001\u6570\u7ec4\u7684\u7ef4\u5ea6\u5927\u5c0f\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">Dim MyArray() As Integer ' \ub3d9\uc801 \ubc30\uc5f4\uc744 \uc120\uc5b8\ud569\ub2c8\ub2e4. \nRedim MyArray(5) ' 5\uac1c\uc758 \uc694\uc18c\ub97c \ud560\ub2f9\ud569\ub2c8\ub2e4. \nRedim Preserve MyArray(15) ' 15\uac1c\uc758 \uc694\uc18c\ub85c \ud06c\uae30\ub97c \ubcc0\uacbd\ud569\ub2c8\ub2e4.<\/pre>\n\n\n\n<p>\u9879\u76ee\u5faa\u73af\uff08\u4e0b\u4e00\u4e2a\uff09<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"5-7\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">'Split &amp; Trim \ucc98\ub9ac\nPublic Function SplitTrim(aExpression As String, aDelimeter As String) As String()\n    Dim saOut() As String, i As Integer\n    saOut = Split(aExpression, aDelimeter)\n    For i = LBound(saOut) To UBound(saOut)\n        saOut(i) = Trim(saOut(i))\n    Next i\n\n    SplitTrim = saOut\nEnd Function<\/pre>\n\n\n\n<p>\u521d\u59cb\u5316\uff1a\u7528Erase\u8bed\u53e5\u521d\u59cb\u5316\u6570\u7ec4\u53d8\u91cf\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">' \ubc30\uc5f4 \ubcc0\uc218\ub97c \uc120\uc5b8\ud569\ub2c8\ub2e4.\nDim NumArray(10) As Integer    ' \uc815\uc218 \ubc30\uc5f4\uc785\ub2c8\ub2e4.\nDim StrVarArray(10) As String    ' \ubcc0\uc218 \ubb38\uc790\uc5f4 \ubc30\uc5f4\uc785\ub2c8\ub2e4.\nDim StrFixArray(10) As String * 10    ' \uace0\uc815 \ubb38\uc790\uc5f4 \ubc30\uc5f4\uc785\ub2c8\ub2e4.\nDim VarArray(10) As Variant    ' Variant \ubc30\uc5f4\uc785\ub2c8\ub2e4.\nDim DynamicArray() As Integer    ' \ub3d9\uc801 \ubc30\uc5f4\uc785\ub2c8\ub2e4.\nReDim DynamicArray(10)    ' \uc800\uc7a5 \uacf5\uac04\uc744 \ud560\ub2f9\ud569\ub2c8\ub2e4.\nErase NumArray    ' 0\uc73c\ub85c \uc9c0\uc815\ub41c \uac01 \uc694\uc18c\uc785\ub2c8\ub2e4.\nErase StrVarArray    ' \uae38\uc774\uac00 0\uc778 \ubb38\uc790\uc5f4 (\"\")\ub85c \uc9c0\uc815\ub41c \uac01 \uc694\uc18c\uc785\ub2c8\ub2e4.    \nErase StrFixArray    ' 0\uc73c\ub85c \uc9c0\uc815\ub41c \uac01 \uc694\uc18c\uc785\ub2c8\ub2e4.\nErase VarArray    ' Empty\ub85c \uc9c0\uc815\ub41c \uac01 \uc694\uc18c\uc785\ub2c8\ub2e4.\nErase DynamicArray    ' \ubc30\uc5f4\uc5d0 \uc758\ud574 \uc0ac\uc6a9\ub418\ub294 \ube48 \uba54\ubaa8\ub9ac\uc785\ub2c8\ub2e4.<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Collection\"><span class=\"ez-toc-section\" id=\"Collection\"><\/span><strong>\u6536\u85cf<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Collection \u7c7b\u7c7b\u4f3c\u4e8e\u52a8\u6001\u6570\u7ec4\u3002\u53ef\u4ee5\u6dfb\u52a0\u548c\u5220\u9664\u6570\u91cf\u53ef\u53d8\u7684\u72ec\u7279\u9879\u76ee\u3002\u56e0\u4e3a\u5b83\u662f\u4e00\u4e2a\u5bf9\u8c61<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/set-statement\" target=\"_blank\" rel=\"noreferrer noopener\">\u653e<\/a>\u201d\u548c\u201c\u65b0\u5efa\u201d\u5173\u952e\u5b57\u6765\u521b\u5efa\u5b9e\u4f8b\u3002\u5728 Visual Basic \u8bed\u8a00\u4e2d\uff0c\u5f53\u521b\u5efa\u5bf9\u5bf9\u8c61\u7684\u5f15\u7528\u6216\u5206\u914d\u65b0\u5f15\u7528\u65f6\uff0c\u5fc5\u987b\u201c<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/set-statement\" target=\"_blank\" rel=\"noreferrer noopener\">\u653e<\/a>\u5fc5\u987b\u4f7f\u7528\u201d\u5173\u952e\u5b57\uff0c\u4e3a\u53d8\u91cf\u8d4b\u503c\u65f6\u4e0d\u9700\u8981\u201cSet\u201d\u5173\u952e\u5b57\u3002\u60a8\u9700\u8981\u533a\u5206\u5904\u7406\u5bf9\u8c61\u548c\u53d8\u91cf\u4ee5\u907f\u514d\u8bed\u6cd5\u9519\u8bef\u3002\u4f60\u53ef\u80fd\u7ecf\u5e38\u72af\u9519\uff0c\u6240\u4ee5\u8981\u5c0f\u5fc3\u3002<\/p>\n\n\n\n<p>\u96c6\u5408\u5bf9\u8c61\u58f0\u660e\u3001\u5b9e\u4f8b\u521b\u5efa\u3001\u9879\u6dfb\u52a0\u7b49\u5404\u4e2a\u4efb\u52a1\u7684\u4ee3\u7801\u89c1\u4e0b\u8868\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>\u4efb\u52a1<\/strong><\/td><td><strong>\u793a\u4f8b\u4ee3\u7801<\/strong><\/td><\/tr><tr><td>\u5ba3\u8a00<\/td><td>Dim o Col As \u7cfb\u5217<\/td><\/tr><tr><td>\u5b9e\u4f8b\u521b\u5efa<\/td><td>\u8bbe\u7f6e oCol = \u65b0\u96c6\u5408<\/td><\/tr><tr><td>\u5728\u58f0\u660e\u7684\u540c\u65f6\u521b\u5efa\u5b9e\u4f8b<\/td><td>Dim o Col \u4f5c\u4e3a\u65b0\u7cfb\u5217<\/td><\/tr><tr><td>\u65b0\u589e\u9879\u76ee<\/td><td>oCol.Add \u201cApple\u201d<\/td><\/tr><tr><td>\u6309\u7d22\u5f15\u8bbf\u95ee\u9879\u76ee<\/td><td>oCol(1)<\/td><\/tr><tr><td>\u4e1c\u897f\u7684\u4e2a\u6570<\/td><td>oCol.Count<\/td><\/tr><tr><td>\u9879\u76ee\u5faa\u73af\uff08\u5bf9\u4e8e\uff09<\/td><td>\u6697 l \u4e00\u6837\u957f<br>\u5bf9\u4e8e l = 1 \u5230 oCol.Count<br>&nbsp;&nbsp;&nbsp;&nbsp;\u8c03\u8bd5\u6253\u5370 oCol(l)<br>\u4e0b\u4e00\u4e2a<\/td><\/tr><tr><td>\u9879\u76ee\u5faa\u73af\uff08\u6bcf\u4e2a\uff09<\/td><td>\u660f\u6697\u7684\u6c34\u679c\u4f5c\u4e3a\u53d8\u4f53<br>\u5bf9\u4e8e oCol \u4e2d\u7684\u6bcf\u4e2a\u6c34\u679c<br>&nbsp;&nbsp;&nbsp;&nbsp;\u8c03\u8bd5.\u6253\u5370\u6c34\u679c<br>\u4e0b\u4e00\u4e2a<\/td><\/tr><tr><td>\u5220\u9664\u9879\u76ee\uff08\u6307\u5b9a\u7d22\u5f15\uff09<\/td><td>oCol.Remove(1)<\/td><\/tr><tr><td>\u5220\u9664\u5b9e\u4f8b<\/td><td>\u8bbe\u7f6e oCol = \u65e0<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u4f7f\u7528 Collection \u7684\u793a\u4f8b\u4ee3\u7801\u5982\u4e0b\u3002\u4f5c\u4e3a\u53c2\u8003\uff0c\u96c6\u5408\u4e2d\u7684\u9879\u76ee\u4ece 1 \u5f00\u59cb\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">Sub CollectionTest()\n    Dim oCol As Collection\n    Set oCol = New Collection\n    \n    oCol.Add \"Apple\"\n    oCol.Add \"Strawberry\"\n    oCol.Add \"Lemon\"\n    oCol.Add \"Banana\"\n    \n    Debug.Print oCol(1)\n    Debug.Print oCol.Item(1)\n    Debug.Print \"----------\"\n\n    Dim l As Long\n    For l = 1 To oCol.Count\n        Debug.Print oCol(l)\n    Next\n\n    Debug.Print \"----------\"\n\n    oCol.Remove (1)\n\n    Dim fruit As Variant\n    For Each fruit In oCol\n        Debug.Print fruit\n    Next\n\n    Set oCol = Nothing\nEnd Sub\n\n'\ucd9c\ub825\nApple\nApple\n----------\nApple\nStrawberry\nLemon\nBanana\n----------\nStrawberry\nLemon\nBanana<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Dictionary\"><span class=\"ez-toc-section\" id=\"Dictionary\"><\/span><strong>\u5b57\u5178<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u53ef\u4ee5\u7ba1\u7406 Key-Value \u7ed3\u6784\u7684\u53ef\u53d8\u552f\u4e00\u9879\u76ee\uff0c\u5e76\u52a8\u6001\u6dfb\u52a0\/\u5220\u9664\u9879\u76ee\u3002<\/p>\n\n\n\n<p>\u5b83\u662f\u4e00\u79cd\u7c7b\u4f3c\u4e8ePython\u8bed\u8a00\u4e2d\u7684Dictionary\u3001C++\u4e2d\u7684HashMap\u3001Java\u4e2d\u7684HashMap\u7684\u6570\u636e\u7ed3\u6784\u3002\u6309\u952e\u503c\u8bbf\u95ee\u65f6\uff0c\u6027\u80fd\u4e3a O(1)\u3002<\/p>\n\n\n\n<p>\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u4e0d\u63d0\u4f9b\u5b57\u5178\u7c7b\u3002\u8981\u5728\u65e9\u671f\u7ed1\u5b9a\u65b9\u6cd5\u4e2d\u4f7f\u7528\u5b83\uff0c\u60a8\u5fc5\u987b\u9996\u5148\u53c2\u8003\u201cMicrosoft Scripting Runtime\u201d\u3002\u8981\u5728\u540e\u671f\u7ed1\u5b9a\u65b9\u6cd5\u4e2d\u4f7f\u7528\uff0c\u8bf7\u901a\u8fc7 CreateObject \u521b\u5efa\u4e00\u4e2a\u5b9e\u4f8b\u5e76\u4f7f\u7528\u5b83\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png\"><img loading=\"lazy\" decoding=\"async\" width=\"524\" height=\"338\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png\" alt=\"Dictionary class \uc0ac\uc6a9\uc744 \uc704\ud55c &quot;Microsoft Scripting Runtime&quot; \ucc38\uc870 \ucd94\uac00\" class=\"wp-image-11388\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png 524w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95-300x194.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95-36x23.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95-48x31.png 48w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\" \/><\/a><figcaption>\u6dfb\u52a0\u4e86\u4f7f\u7528 Dictionary \u7c7b\u7684\u201cMicrosoft Scripting Runtime\u201d\u53c2\u8003<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\u5b57\u5178\u5bf9\u8c61\u58f0\u660e\u3001\u5b9e\u4f8b\u521b\u5efa\u3001\u9879\u6dfb\u52a0\u7b49\u5404\u4e2a\u4efb\u52a1\u7684\u4ee3\u7801\u89c1\u4e0b\u8868\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>\u4efb\u52a1<\/strong><\/td><td><strong>\u793a\u4f8b\u4ee3\u7801<\/strong><\/td><\/tr><tr><td>\u58f0\u660e\uff08\u63d0\u524d\u7ea6\u675f\uff09<\/td><td>Dim oDic \u4f5c\u4e3a\u5b57\u5178<\/td><\/tr><tr><td>\u5b9e\u4f8b\u521b\u5efa\uff08\u65e9\u671f\u7ed1\u5b9a\uff09<\/td><td>\u8bbe\u7f6e oDic = \u65b0\u8bcd\u5178<\/td><\/tr><tr><td>\u58f0\u660e\uff08\u540e\u671f\u7ed1\u5b9a\uff09<\/td><td>\u4f5c\u4e3a\u5bf9\u8c61\u7684\u4e8c\u5143\u8bba<\/td><\/tr><tr><td>\u5b9e\u4f8b\u521b\u5efa\uff08\u540e\u671f\u7ed1\u5b9a\uff09<\/td><td>\u8bbe\u7f6e oDic = CreateObject(\u201cScripting.Dictionary\u201d)<\/td><\/tr><tr><td>\u65b0\u589e\u9879\u76ee<\/td><td>oDic.Add \u201c\u82f9\u679c\u201d, 50<\/td><\/tr><tr><td>\u66f4\u6539\u503c<\/td><td>oDic(\u201c\u82f9\u679c\u201d) = 60<\/td><\/tr><tr><td>\u83b7\u53d6\u4ef7\u503c<\/td><td>appleCount = oDic(\u201c\u82f9\u679c\u201d)<\/td><\/tr><tr><td>\u68c0\u67e5\u5bc6\u94a5\u662f\u5426\u5b58\u5728<\/td><td>oDic.Exists(\u201c\u82f9\u679c\u201d)<\/td><\/tr><tr><td>\u5220\u9664\u9879\u76ee<\/td><td>oDic.Remove(\u201c\u82f9\u679c\u201d)<\/td><\/tr><tr><td>\u5220\u9664\u6240\u6709\u9879\u76ee<\/td><td>oDic.RemoveAll<\/td><\/tr><tr><td>\u4e1c\u897f\u7684\u4e2a\u6570<\/td><td>oDic.\u8ba1\u6570<\/td><\/tr><tr><td>\u9879\u76ee\u5faa\u73af\uff08\u6bcf\u4e2a\uff09<\/td><td>\u53d8\u6697\u952e\u4f5c\u4e3a\u53d8\u4f53<br>\u5bf9\u4e8e oDic \u4e2d\u7684\u6bcf\u4e2a\u952e\u3002\u952e<br>&nbsp;&nbsp;&nbsp;&nbsp;Debug. \u6253\u5370\u5bc6\u94a5\uff0coDic(key)<br>\u4e0b\u4e00\u952e<\/td><\/tr><tr><td>\u9879\u76ee\u5faa\u73af\uff08\u5bf9\u4e8e\uff0c\u4ec5\u9650\u65e9\u671f\u7ed1\u5b9a\uff09<\/td><td>\u6697 l \u4e00\u6837\u957f<br>\u5bf9\u4e8e l = 0 \u81f3 oDic.Count -1<br>&nbsp;&nbsp;&nbsp;&nbsp;\u8c03\u8bd5.\u6253\u5370 oDic.Keys(l), oDic.Items(l)<br>\u4e0b\u4e00\u4e2a<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u4f7f\u7528 Dictionary \u7684\u793a\u4f8b\u4ee3\u7801\u5982\u4e0b\u3002\u4f5c\u4e3a\u53c2\u8003\uff0c\u5b57\u5178\u4e2d\u7684\u9879\u76ee\u4ece 0 \u5f00\u59cb\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"23-24\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">Sub DictionaryTest()\n    Dim oDic As Dictionary\n    Set oDic = New Dictionary\n\n    oDic.Add \"A\", \"Apple\"\n    oDic.Add \"S\", \"Strawberry\"\n    oDic.Add \"L\", \"Lemon\"\n    oDic.Add \"B\", \"Banana\"\n\n    Debug.Print oDic(\"A\")\n    Debug.Print oDic.Items(0)\n    Debug.Print \"----------\"\n\n    Dim l As Long\n    For l = 0 To oDic.Count - 1\n        Debug.Print oDic.Items(l)\n    Next\n    \n    Debug.Print \"----------\"\n    \n    oDic.Remove (\"A\")\n\n    Dim key As Variant, fruit As String\n    For Each key In oDic.Keys\n        fruit = oDic(key)\n        Debug.Print fruit\n    Next\n\n    Set oDic = Nothing\nEnd Sub\n\n'\ucd9c\ub825\nApple\nApple\n----------\nApple\nStrawberry\nLemon\nBanana\n----------\nStrawberry\nLemon\nBanana<\/pre>\n\n\n\n<p>For\u5faa\u73af\u8bed\u53e5\u67e5\u627eDictionary\u5bf9\u8c61\u65f6\uff0c\u5305\u542b\u952e\u503c\u7684\u53d8\u91cf\u53ea\u80fd\u662fVariant\u6216Object\u7c7b\u578b\u3002\u5728\u4e0a\u9762\u7684\u793a\u4f8b\u4e2d\uff0c\u7b2c 23 \u548c 24 \u884c\u7684\u4ee3\u7801\u4f7f\u7528\u4e86 Variant \u683c\u5f0f\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u5728\u672c\u6587\u4e2d\uff0c\u6211\u4eec\u4e86\u89e3\u4e86 VBA \u6570\u636e\u7c7b\u578b\u548c\u6570\u636e\u7ed3\u6784\u3002\u7279\u522b\u662f Collection \u548c Dictionary \u5f88\u53ef\u80fd\u88ab\u9891\u7e41\u4f7f\u7528\uff0c\u6240\u4ee5\u8bf7\u719f\u6089\u5b83\u4eec\u3002\u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u5c06\u770b\u770b\u7f16\u5199 VBA \u4ee3\u7801\u65f6\u9700\u8981\u4e86\u89e3\u7684\u64cd\u4f5c\u65b9\u6cd5\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>&lt;&lt;\u76f8\u5173\u6587\u7ae0\u4e00\u89c8&gt;&gt;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-preface\/\">\u5f00\u59cb Excel VBA \u8bfe\u7a0b\u3002 \uff08\u8bb2\u5ea7\u9884\u544a\uff0c\u58ee\u4e3e\u3002\u4e3a\u4ec0\u4e48\u6211\u4eec\u63a8\u8350 Excel VBA\uff09<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-1-overview\/\">Excel VBA\u8bfe\u7a0b\uff08\u4e00\uff09\uff1aExcel VBA\u6982\u8ff0<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-2-basic\/\">Excel VBA\u6559\u7a0b\uff08\u4e8c\uff09\uff1aExcel VBA\u57fa\u7840<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-3-object-model\/\">Excel VBA\u6559\u7a0b\uff08\u4e09\uff09\uff1aExcel\u5bf9\u8c61\u6a21\u578b<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-4-handling-object-model\/\">Excel VBA\u6559\u7a0b\uff08\u56db\uff09\uff1a\u4f7f\u7528Excel\u5bf9\u8c61\u6a21\u578b<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-5-excel-file-extension-vbe-font\/\">Excel VBA\u6559\u7a0b\uff08\u4e94\uff09\uff1aExcel\u6587\u4ef6\u6269\u5c55\u540d\u3001VBE\u3001\u5b57\u4f53\u8bbe\u7f6e<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-6-variable\/\">Excel VBA\u6559\u7a0b\uff08\u516d\uff09\uff1aExcel VBA\u8bed\u8a00\u57fa\u7840-\u53d8\u91cf<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/\">Excel VBA\u6559\u7a0b\uff08\u4e03\uff09\uff1aExcel VBA\u8bed\u8a00\u57fa\u7840\u2014\u2014\u8bed\u6cd5<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-8-datatype\/\">Excel VBA\u6559\u7a0b\uff08\u516b\uff09\uff1aExcel VBA\u8bed\u8a00\u57fa\u7840\u2014\u2014\u6570\u636e\u7c7b\u578b\u3001\u6570\u636e\u7ed3\u6784<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-9-how-to\/\">Excel VBA\u6559\u7a0b\uff08\u4e5d\uff09\uff1aExcel VBA How-To<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-10-self-developed-tools\/\">Excel VBA\u6559\u7a0b\uff08\u5341\uff09\uff1a\u4e0eExcel VBA\u4e00\u8d77\u5f00\u53d1\u548c\u4f7f\u7528\u7684\u5de5\u5177<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-toc\/\">Excel VBA \u8bfe\u7a0b\u7684\u5b8c\u6574\u76ee\u5f55<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>\u5728\u672c\u6587\u4e2d\uff0c\u6211\u4eec\u5c06\u4e86\u89e3 Excel VBA \u8bed\u8a00\u57fa\u7840\u77e5\u8bc6\u4e2d\u7684\u6570\u636e\u7c7b\u578b\u548c\u63d0\u4f9b\u7684\u6570\u636e\u7ed3\u6784\u3002\u8fd9\u662f\u4e0a\u4e00\u7bc7\u6587\u7ae0\u7684\u5ef6\u7eed\u3002 Excel VBA \u8bb2\u5ea7\uff08\u4e03\uff09\uff1a\u57fa\u672cExcel VBA \u8bed\u8a00-\u8bed\u6cd53.3\u3002\u6570\u636e\u7c7b\u578b 3.3.1\u3002\u57fa\u672c\u6570\u636e\u7c7b\u578b \u4e0b\u8868\u603b\u7ed3\u4e86 VB\uff08\u6216 VBA\uff09\u652f\u6301\u7684\u6570\u636e\u7c7b\u578b\u3002\u6536\u85cf\uff0c...<\/p>","protected":false},"author":1,"featured_media":11388,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[17],"class_list":["post-11386","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-vba-tutorial","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure) - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \uc790\ub8cc\ud615(Data type)\uacfc \uc81c\uacf5\ub418\ub294 \uc790\ub8cc\uad6c\uc870(Data structure)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Variant, User-defined \ub370\uc774\ud130 \ud615\uc2dd\uacfc Array, Collection, Dictionary\uc5d0 \ub300\ud574 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-8-datatype\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure) - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \uc790\ub8cc\ud615(Data type)\uacfc \uc81c\uacf5\ub418\ub294 \uc790\ub8cc\uad6c\uc870(Data structure)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Variant, User-defined \ub370\uc774\ud130 \ud615\uc2dd\uacfc Array, Collection, Dictionary\uc5d0 \ub300\ud574 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-8-datatype\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-11T09:29:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-11T02:42:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png\" \/>\n\t<meta property=\"og:image:width\" content=\"524\" \/>\n\t<meta property=\"og:image:height\" content=\"338\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure)\",\"datePublished\":\"2022-09-11T09:29:45+00:00\",\"dateModified\":\"2022-10-11T02:42:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/\"},\"wordCount\":763,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png\",\"keywords\":[\"\uc5d1\uc140VBA\"],\"articleSection\":[\"\uc5d1\uc140 VBA \uac15\uc88c\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/\",\"url\":\"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/\",\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure) - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png\",\"datePublished\":\"2022-09-11T09:29:45+00:00\",\"dateModified\":\"2022-10-11T02:42:21+00:00\",\"description\":\"\uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \uc790\ub8cc\ud615(Data type)\uacfc \uc81c\uacf5\ub418\ub294 \uc790\ub8cc\uad6c\uc870(Data structure)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Variant, User-defined \ub370\uc774\ud130 \ud615\uc2dd\uacfc Array, Collection, Dictionary\uc5d0 \ub300\ud574 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#primaryimage\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png\",\"width\":524,\"height\":338},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prodskill.com\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/prodskill.com\/ko\/#website\",\"url\":\"https:\/\/prodskill.com\/ko\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/prodskill.com\/ko\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\"},\"url\":\"https:\/\/prodskill.com\/zh\/author\/proda\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel VBA \u8bfe\u7a0b\uff088\uff09\uff1aExcel VBA \u8bed\u8a00\u57fa\u7840 - \u6570\u636e\u7c7b\u578b\u3001\u6570\u636e\u7ed3\u6784 - \u751f\u4ea7\u529b\u6280\u80fd","description":"\u672c\u6587\u4ecb\u7ecd Excel VBA \u7684\u57fa\u7840\u77e5\u8bc6\uff0c\u5305\u62ec\u6570\u636e\u7c7b\u578b\u548c\u63d0\u4f9b\u7684\u6570\u636e\u7ed3\u6784\u3002\u60a8\u5c06\u4e86\u89e3\u53d8\u4f53\u3001\u7528\u6237\u5b9a\u4e49\u6570\u636e\u7c7b\u578b\u3001\u6570\u7ec4\u3001\u96c6\u5408\u548c\u5b57\u5178\u3002.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prodskill.com\/zh\/excel-vba-lecture-8-datatype\/","og_locale":"zh_CN","og_type":"article","og_title":"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure) - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \uc790\ub8cc\ud615(Data type)\uacfc \uc81c\uacf5\ub418\ub294 \uc790\ub8cc\uad6c\uc870(Data structure)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Variant, User-defined \ub370\uc774\ud130 \ud615\uc2dd\uacfc Array, Collection, Dictionary\uc5d0 \ub300\ud574 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/zh\/excel-vba-lecture-8-datatype\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-11T09:29:45+00:00","article_modified_time":"2022-10-11T02:42:21+00:00","og_image":[{"width":524,"height":338,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"Zerom","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"9 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure)","datePublished":"2022-09-11T09:29:45+00:00","dateModified":"2022-10-11T02:42:21+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/"},"wordCount":763,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png","keywords":["\uc5d1\uc140VBA"],"articleSection":["\uc5d1\uc140 VBA \uac15\uc88c"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/","url":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/","name":"Excel VBA \u8bfe\u7a0b\uff088\uff09\uff1aExcel VBA \u8bed\u8a00\u57fa\u7840 - \u6570\u636e\u7c7b\u578b\u3001\u6570\u636e\u7ed3\u6784 - \u751f\u4ea7\u529b\u6280\u80fd","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png","datePublished":"2022-09-11T09:29:45+00:00","dateModified":"2022-10-11T02:42:21+00:00","description":"\u672c\u6587\u4ecb\u7ecd Excel VBA \u7684\u57fa\u7840\u77e5\u8bc6\uff0c\u5305\u62ec\u6570\u636e\u7c7b\u578b\u548c\u63d0\u4f9b\u7684\u6570\u636e\u7ed3\u6784\u3002\u60a8\u5c06\u4e86\u89e3\u53d8\u4f53\u3001\u7528\u6237\u5b9a\u4e49\u6570\u636e\u7c7b\u578b\u3001\u6570\u7ec4\u3001\u96c6\u5408\u548c\u5b57\u5178\u3002.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png","width":524,"height":338},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure)"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"\u751f\u4ea7\u529b\u6280\u80fd","description":"\u5143\u601d\u7ef4\uff0c\u5143\u5de5\u4f5c","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"\u6cfd\u7f57\u59c6","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/zh\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts\/11386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/comments?post=11386"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts\/11386\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/media\/11388"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/media?parent=11386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/categories?post=11386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/tags?post=11386"}],"curies":[{"name":"\u53ef\u6e7f\u6027\u7c89\u5242","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}