{"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\/ja\/excel-vba-lecture-8-datatype\/","title":{"rendered":"Excel VBA\u30b3\u30fc\u30b9\uff088\uff09\uff1aExcel VBA\u8a00\u8a9e\u57fa\u672c - \u30c7\u30fc\u30bf\u578b\uff08Data type\uff09\u3001\u30c7\u30fc\u30bf\u69cb\u9020\uff08Data structure\uff09"},"content":{"rendered":"<p>\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Excel VBA\u8a00\u8a9e\u306e\u57fa\u672c\u7684\u306a\u30c7\u30fc\u30bf\u578b\uff08Data type\uff09\u3068\u63d0\u4f9b\u3055\u308c\u308b\u30c7\u30fc\u30bf\u69cb\u9020\uff08Data structure\uff09\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u524d\u306e\u8a18\u4e8b\u3067\u7d9a\u304f\u5185\u5bb9\u3060\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/ja\/excel-vba-lecture-7-syntax\/\">Excel VBA\u30b3\u30fc\u30b9\uff087\uff09\uff1aExcel VBA\u8a00\u8a9e\u57fa\u672c - \u6587\u6cd5\uff08Syntax\uff09<\/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\u6b21&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=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/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\/ja\/excel-vba-lecture-8-datatype\/#33_%EC%9E%90%EB%A3%8C%ED%98%95\" >3.3\u3002\u30c7\u30fc\u30bf\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\/ja\/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\u30c7\u30fc\u30bf\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\/ja\/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\u30c7\u30fc\u30bf\u578b\u4e00\u89a7<\/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\/ja\/excel-vba-lecture-8-datatype\/#Variant_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%98%95%EC%8B%9D\" >Variant \u30c7\u30fc\u30bf\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\/ja\/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\" >User-defined\uff08\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\uff09\u30c7\u30fc\u30bf\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\/ja\/excel-vba-lecture-8-datatype\/#332_%EC%9E%90%EB%A3%8C%EA%B5%AC%EC%A1%B0\" >3.3.2\u3002\u30c7\u30fc\u30bf\u69cb\u9020<\/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\/ja\/excel-vba-lecture-8-datatype\/#Array\" >Array<\/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\/ja\/excel-vba-lecture-8-datatype\/#Collection\" >\u30b3\u30ec\u30af\u30b7\u30e7\u30f3<\/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\/ja\/excel-vba-lecture-8-datatype\/#Dictionary\" >Dictionary<\/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\u3002\u30c7\u30fc\u30bf\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\u30c7\u30fc\u30bf\u578b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>VB\uff08\u307e\u305f\u306fVBA\uff09\u3067\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u578b\u3092\u307e\u3068\u3081\u308b\u3068\u3001\u6b21\u306e\u8868\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002\u4ee5\u4e0b\u306e\u30bd\u30fc\u30b9\u306e\u8868\u306e\u5185\u5bb9\u306e\u3046\u3061\u3001\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3001\u8f9e\u66f8\u306f\u300c\u8cc7\u6599\u69cb\u9020\u300d\u3067\u5225\u3005\u306b\u8aac\u660e\u3055\u308c\u3066\u3044\u307e\u3059\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\u30c7\u30fc\u30bf\u578b\u4e00\u89a7<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u30bd\u30fc\u30b9\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>\u30c7\u30fc\u30bf\u578b<\/strong><\/td><td><strong>\u30b9\u30c8\u30ec\u30fc\u30b8\u5bb9\u91cf<\/strong><\/td><td><strong>\u7bc4\u56f2<\/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\">Boolean<\/a><\/strong><\/td><td>2 bytes<\/td><td><strong>True<\/strong>&nbsp;\u307e\u305f\u306f&nbsp;<strong>False<\/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\">Byte<\/a><\/strong><\/td><td>1 byte<\/td><td>0 ~ 255<\/td><\/tr><tr><td><strong>\u30b3\u30ec\u30af\u30b7\u30e7\u30f3<\/strong><\/td><td>Unknown<\/td><td>Unknown<\/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\">Currency<\/a><\/strong>&nbsp;(scaled integer)<\/td><td>8 bytes<\/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\u4ed8<\/a><\/strong><\/td><td>8 bytes<\/td><td>January 1, 100, to December 31, 9999<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\">Decimal<\/a><\/strong><\/td><td>14 \u30d0\u30a4\u30c8<\/td><td>+\/-79,228,162,514,264,337,593,543,950,335 with no decimal point<br><br>+\/-7.9228162514264337593543950335 with 28 places to the right of the decimal<br><br>Smallest non-zero number is+\/-0.00000000000000000000000000001<\/td><\/tr><tr><td><strong>Dictionary<\/strong><\/td><td>Unknown<\/td><td>Unknown<\/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\">Double<\/a><\/strong>&nbsp;(double-precision floating-point)<\/td><td>8 bytes<\/td><td>-1.79769313486231E308 to -4.94065645841247E-324 for negative values<br><br>4.94065645841247E-324 to 1.79769313486232E308 for positive values<\/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\">Integer<\/a><\/strong><\/td><td>2 bytes<\/td><td>-32,768\u301c32,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\">\u9577\u3044<\/a><\/strong>&nbsp;(Long integer)<\/td><td>4 bytes<\/td><td>-2,147,483,648\u301c2,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\">LongLong<\/a><\/strong>&nbsp;(LongLong integer)<\/td><td>8 bytes<\/td><td>-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807<br><br>Valid on 64-bit platforms only.<\/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\">LongPtr<\/a><\/strong>&nbsp;(Long integer on 32-bit systems, LongLong integer on 64-bit systems)<\/td><td>4 bytes on 32-bit systems<br><br>8 bytes on 64-bit systems<\/td><td>-2,147,483,648 to 2,147,483,647 on 32-bit \u30b7\u30b9\u30c6\u30e0<br><br>-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 on 64-bit \u30b7\u30b9\u30c6\u30e0<\/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\">Object<\/a><\/strong><\/td><td>4 bytes<\/td><td>Any&nbsp;<strong>Object<\/strong>&nbsp;reference<\/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\">\u30b7\u30f3\u30b0\u30eb<\/a><\/strong>&nbsp;(single-precision floating-point)<\/td><td>4 bytes<\/td><td>-3.402823E38 to -1.401298E-45 for negative values<br><br>1.401298E-45 to 3.402823E38 for positive values<\/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\">String<\/a><\/strong>&nbsp;(variable-length)<\/td><td>10 bytes + string length<\/td><td>0 to approximately 2 billion<\/td><\/tr><tr><td><strong>String<\/strong>&nbsp;(fixed-length)<\/td><td>Length of string<\/td><td>1 to approximately 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\">Variant<\/a><\/strong>&nbsp;(with numbers)<\/td><td>16 \u30d0\u30a4\u30c8<\/td><td>Any numeric value up to the range of a&nbsp;<strong>Double<\/strong><\/td><\/tr><tr><td><strong>Variant<\/strong>&nbsp;(with characters)<\/td><td>22 bytes + string length (24 bytes on 64-bit systems)<\/td><td>Same range as for variable-length&nbsp;<strong>String<\/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\">User-defined<\/a><\/strong>&nbsp;(using&nbsp;<strong>\u30bf\u30a4\u30d7<\/strong>)<\/td><td>Number required by elements<\/td><td>The range of each element is the same as the range of its data type.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u3053\u306e\u4e2d\u3067\u6700\u3082\u3088\u304f\u4f7f\u308f\u308c\u308b\u30c7\u30fc\u30bf\u578b\u306f\u3001Int\u3001Long\u3001String\u3001Boolean\u7a0b\u5ea6\u3067\u3042\u308b\u3002<\/p>\n\n\n\n<p>\uff36\uff41\uff52\uff49\uff41\uff4e\uff54\u3001\uff35\uff53\uff45\uff52\u2212\uff44\uff45\uff46\uff49\uff4e\uff45\uff44\u30c7\u30fc\u30bf\u578b\u306b\u3064\u3044\u3066\u3001\u4ee5\u4e0b\u306b\u3055\u3089\u306b\u8aac\u660e\u3059\u308b\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>Variant \u30c7\u30fc\u30bf\u578b<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Variant\u30c7\u30fc\u30bf\u578b\u306f\u3001\u8907\u6570\u306e\u30c7\u30fc\u30bf\u578b\u3092\u4fdd\u5b58\u3057\u3066\u51e6\u7406\u3067\u304d\u308b\u7279\u5225\u306a\u30c7\u30fc\u30bf\u578b\u3067\u3059\u3002\u5909\u6570\u3092\u5ba3\u8a00\u3059\u308b\u3068\u304d\u306b\u30c7\u30fc\u30bf\u578b\u3092\u7701\u7565\u3059\u308b\u3068\u3001Variant\u30c7\u30fc\u30bf\u578b\u3068\u3057\u3066\u6307\u5b9a\u3055\u308c\u307e\u3059\u3002 Variant\u30c7\u30fc\u30bf\u578b\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u4ee5\u4e0b\u306eURL\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\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>\u5b9f\u884c\u4e2d\u306bVariant\u5909\u6570\u304c\u3069\u306e\u30c7\u30fc\u30bf\u578b\u3092\u683c\u7d0d\u3057\u3066\u3044\u308b\u304b\u3092\u78ba\u8a8d\u3059\u308b\u306b\u306f\u3001VarType\u95a2\u6570\u3092\u4f7f\u7528\u3057\u307e\u3059\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>\u69cb\u6587<\/strong><\/p>\n\n\n\n<p><strong>VarType\uff08<\/strong><em>varname<\/em><strong>)<\/strong><\/p>\n\n\n\n<p>\u5fc5\u9808\u8981\u7d20&nbsp;<em>varname<\/em>&nbsp;\u5f15\u6570\u306f\u3001\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u578b\u306e\u5909\u6570\u3092\u9664\u304f\u5909\u6570\u3092\u542b\u3080Variant\u3067\u3059\u3002<\/p>\n\n\n\n<p><strong>\u8fd4\u3059<\/strong><strong>\u30d5\u30a9\u30fc\u30de\u30c3\u30c8<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>\u5b9a\u6570<\/strong><\/td><td><strong>\u5024<\/strong><\/td><td><strong>\u8aac\u660e<\/strong><\/td><\/tr><tr><td><strong>vbEmpty<\/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\">Empty<\/a>(\u521d\u671f\u5316\u3055\u308c\u3066\u3044\u306a\u3044)<\/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\">\u30cc\u30eb<\/a>(\u6709\u52b9\u306a\u30c7\u30fc\u30bf\u306a\u3057)<\/td><\/tr><tr><td><strong>vbInteger<\/strong><\/td><td>2<\/td><td>\u6574\u6570<\/td><\/tr><tr><td><strong>vbLong<\/strong><\/td><td>3<\/td><td>\u9577\u3044\u6574\u6570<\/td><\/tr><tr><td><strong>vbSingle<\/strong><\/td><td>4<\/td><td>\u5358\u7cbe\u5ea6\u6d6e\u52d5\u5c0f\u6570\u70b9\u6570<\/td><\/tr><tr><td><strong>vbDouble<\/strong><\/td><td>5<\/td><td>\u500d\u7cbe\u5ea6\u6d6e\u52d5\u5c0f\u6570\u70b9\u6570<\/td><\/tr><tr><td><strong>vbCurrency<\/strong><\/td><td>6<\/td><td>\u901a\u8ca8\u5024<\/td><\/tr><tr><td><strong>vbDate<\/strong><\/td><td>7<\/td><td>\u65e5\u4ed8\u5024<\/td><\/tr><tr><td><strong>vbString<\/strong><\/td><td>8<\/td><td>\u6587\u5b57\u5217<\/td><\/tr><tr><td><strong>vbObject<\/strong><\/td><td>9<\/td><td>\u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/td><\/tr><tr><td><strong>vbError<\/strong><\/td><td>10<\/td><td>\u30a8\u30e9\u30fc\u5024<\/td><\/tr><tr><td><strong>vbBoolean<\/strong><\/td><td>11<\/td><td>Boolean \u5024<\/td><\/tr><tr><td><strong>vbVariant<\/strong><\/td><td>12<\/td><td><strong>Variant<\/strong>(variant&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/glossary\/vbe-glossary#array\" target=\"_blank\" rel=\"noreferrer noopener\">\u914d\u5217<\/a>\u3067\u306e\u307f\u4f7f\u7528\uff09<\/td><\/tr><tr><td><strong>vbDataObject<\/strong><\/td><td>13<\/td><td>\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/td><\/tr><tr><td><strong>vbDecimal<\/strong><\/td><td>14<\/td><td>10\u9032\u5024<\/td><\/tr><tr><td><strong>vbByte<\/strong><\/td><td>17<\/td><td>\u30d0\u30a4\u30c8\u5024<\/td><\/tr><tr><td><strong>vbArray<\/strong><\/td><td>8192<\/td><td>\u914d\u5217<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u79c1\u306f\u500b\u4eba\u7684\u306bVariant\u30c7\u30fc\u30bf\u578b\u3092\u3046\u307e\u304f\u4f7f\u7528\u305b\u305a\u3001\u30b7\u30fc\u30c8\u30c7\u30fc\u30bf\u3092\u4e00\u5ea6\u306b\u8aad\u307f\u66f8\u304d\u3059\u308b\u3068\u304d\u306b\u306e\u307f\u4e3b\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002 Variant arry\u3092\u4f7f\u7528\u3057\u3066\u5927\u91cf\u306e\u30b7\u30fc\u30c8\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u66f8\u304d\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u306f\u3001\u4ee5\u4e0b\u306e\u8a18\u4e8b\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/ja\/excel-vba-coding-pattern-range-loop-read\/\">VBA\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u30d1\u30bf\u30fc\u30f3\uff1aRange Loop - \u8aad\u307f\u53d6\u308a\uff08Read\uff09<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/ja\/excel-vba-coding-pattern-range-loop-write\/\">VBA\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u30d1\u30bf\u30fc\u30f3\uff1aRange Loop - Write<\/a><\/p>\n\n\n\n<p>Variant\u30c7\u30fc\u30bf\u578b\u3092\u4f7f\u7528\u3059\u308b\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u3067\u3059\u3002\u6574\u6570\u3001\u6587\u5b57\u5217\u3001\u5b9f\u6570\u3001\u65e5\u4ed8\u30c7\u30fc\u30bf\u578b\u3092\u3059\u3079\u3066\u51e6\u7406\u3067\u304d\u308b\u3053\u3068\u3092\u793a\u3057\u307e\u3059\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>User-defined\uff08\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\uff09\u30c7\u30fc\u30bf\u578b<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u30ab\u30b9\u30bf\u30e0\u30c7\u30fc\u30bf\u578b\u3092\u5ba3\u8a00\u3057\u3066\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002 C\u8a00\u8a9e\u306e\u300cstruct\u300d\u306b\u4f3c\u305f\u300cType\u300d\u30ad\u30fc\u30ef\u30fc\u30c9\u3067\u30ab\u30b9\u30bf\u30e0\u30c7\u30fc\u30bf\u578b\u3092\u5ba3\u8a00\u3057\u307e\u3059\u3002 User-defined \u30c7\u30fc\u30bf\u578b\u306f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u306f\u306a\u304f\u3001\u5ba3\u8a00\u3059\u308b\u3068\u3059\u3050\u306b instance \u304c\u751f\u6210\u3055\u308c\u3001\u30e1\u30e2\u30ea\u304c\u5272\u308a\u5f53\u3066\u3089\u308c\u3001\u5024\u3092\u5165\u529b\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>User-defined\u30c7\u30fc\u30bf\u578b\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u4ee5\u4e0b\u306eURL\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\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>User-defined \u30c7\u30fc\u30bf\u578b\u306e\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\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\u3002\u30c7\u30fc\u30bf\u69cb\u9020<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u3088\u304f\u4f7f\u3046\u30c7\u30fc\u30bf\u69cb\u9020\u306fArray\u3001Collection\u3001Dictionary\u304c\u3042\u308b\u3002\u305d\u308c\u305e\u308c\u306b\u3064\u3044\u3066\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Array\"><span class=\"ez-toc-section\" id=\"Array\"><\/span><strong>Array<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u56fa\u5b9a\u6570\u306e Item \u3092\u6301\u3064\u3002\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u306f\u306a\u304f\u5ba3\u8a00\u3059\u308b\u3068\u3001\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304c\u751f\u6210\u3055\u308c\u307e\u3059\u3002\u5ba3\u8a00\u6642\u306b\u6b21\u5143\u306e\u6570\u3068\u5404\u6b21\u5143\u306e\u4e0b\u9650\u3001\u4e0a\u9650\u7bc4\u56f2\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u3001\u5b9f\u884c\u6642\u306b\u52d5\u7684\u306b\u914d\u5217\u306e\u6b21\u5143\u3001\u7bc4\u56f2\u3092\u5909\u66f4\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u308b\u3002\u5404\u6b21\u5143\u306e\u4e0b\u9650\u3068\u4e0a\u9650\u3092\u6307\u5b9a\u305b\u305a\u306bitem\u306e\u6570\u3060\u3051\u3092\u6307\u5b9a\u3059\u308b\u5834\u5408\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u4e0b\u9650\u306f0\u3067\u3059\u3002 Option Base 1\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u4e0b\u9650\u306f1\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5ba3\u8a00\u306e\u4f8b\u30b3\u30fc\u30c9<\/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>\u5404\u6b21\u5143\u306e\u4e0b\u9650\u5024\/\u4e0a\u9650\u5024\u5ba3\u8a00\u3001\u78ba\u8a8d\uff1aLBound\u3001UBound\u3092\u4f7f\u7528<\/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>\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u30b5\u30a4\u30ba\u306e\u5909\u66f4\uff1aRedim\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3067\u52d5\u7684\u914d\u5217\u306e\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u30b5\u30a4\u30ba\u3092\u5909\u66f4\u3057\u307e\u3059\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>Item Loop(For Next)<\/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\u671f\u5316\uff1aErase\u6587\u3067\u914d\u5217\u5909\u6570\u3092\u521d\u671f\u5316\u3057\u307e\u3059\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>\u30b3\u30ec\u30af\u30b7\u30e7\u30f3<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u30af\u30e9\u30b9\u306f\u52d5\u7684\u914d\u5217\u3068\u4f3c\u3066\u3044\u307e\u3059\u3002\u53ef\u5909\u500b\u6570\u306e unique item \u3092 Add, Remove \u3067\u304d\u308b\u3002\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3060\u304b\u3089\u300d<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/set-statement\" target=\"_blank\" rel=\"noreferrer noopener\">\u30bb\u30c3\u30c8<\/a>\u300c\u300d\u3068\u300cNew\u300d\u30ad\u30fc\u30ef\u30fc\u30c9\u3092\u4f7f\u7528\u3057\u3066\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002 Visual Basic\u8a00\u8a9e\u3067\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u53c2\u7167\u3092\u4f5c\u6210\u3057\u305f\u308a\u3001\u65b0\u3057\u3044\u53c2\u7167\u3092\u5272\u308a\u5f53\u3066\u308b\u3068\u304d\u306f\u5fc5\u305a\u300c<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/set-statement\" target=\"_blank\" rel=\"noreferrer noopener\">\u30bb\u30c3\u30c8<\/a>\u201d keyword \u3092\u4f7f\u7528\u3057\u306a\u3051\u308c\u3070\u306a\u3089\u305a\u3001\u5909\u6570\u306b\u5024\u3092\u5272\u308a\u5f53\u3066\u308b\u3068\u304d\u306f \u201cSet\u201d keyword \u306f\u5fc5\u8981\u306a\u3044\u3002\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6271\u3046\u6642\u3068\u5909\u6570\u3092\u6271\u3046\u6642\u3092\u3088\u304f\u533a\u5225\u3057\u306a\u3051\u308c\u3070\u6587\u6cd5\u30a8\u30e9\u30fc\u306f\u767a\u751f\u3057\u306a\u3044\u3002\u3088\u304f\u9593\u9055\u3044\u304c\u3042\u308b\u306e\u3067\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u5ba3\u8a00\u3001\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u4f5c\u6210\u3001\u30a2\u30a4\u30c6\u30e0\u306e\u8ffd\u52a0\u306a\u3069\u306e\u30bf\u30b9\u30af\u56fa\u6709\u306e\u30b3\u30fc\u30c9\u306b\u3064\u3044\u3066\u306f\u3001\u6b21\u306e\u8868\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Task<\/strong><\/td><td><strong>\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9<\/strong><\/td><\/tr><tr><td>\u5ba3\u8a00<\/td><td>Dim oCol As Collection<\/td><\/tr><tr><td>Instance\u306e\u4f5c\u6210<\/td><td>Set oCol = New Collection<\/td><\/tr><tr><td>\u5ba3\u8a00\u3068\u540c\u6642\u306b\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u4f5c\u6210\u3059\u308b<\/td><td>Dim oCol As New Collection<\/td><\/tr><tr><td>\u30a2\u30a4\u30c6\u30e0\u3092\u8ffd\u52a0<\/td><td>oCol.Add \u201cApple\u201d<\/td><\/tr><tr><td>Index\u306b\u3088\u308bItem\u3078\u306e\u30a2\u30af\u30bb\u30b9<\/td><td>oCol(1)<\/td><\/tr><tr><td>\u30a2\u30a4\u30c6\u30e0\u6570<\/td><td>oCol.Count<\/td><\/tr><tr><td>\u30a2\u30a4\u30c6\u30e0\u30eb\u30fc\u30d7\uff08For\uff09<\/td><td>Dim l As Long<br>For l = 1 to oCol.Count<br>&nbsp;&nbsp;&nbsp;&nbsp;Debug.Print oCol(l)<br>Next<\/td><\/tr><tr><td>\u30a2\u30a4\u30c6\u30e0\u30eb\u30fc\u30d7\uff08For Each\uff09<\/td><td>Dim fruit As Variant<br>For Each fruit in oCol<br>&nbsp;&nbsp;&nbsp;&nbsp;Debug.Print fruit<br>Next<\/td><\/tr><tr><td>\u30a2\u30a4\u30c6\u30e0\u306e\u524a\u9664\uff08\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u6307\u5b9a\uff09<\/td><td>oCol.Remove(1)<\/td><\/tr><tr><td>Instance\u306e\u524a\u9664<\/td><td>Set oCol = Nothing<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Collection \u3092\u4f7f\u7528\u3059\u308b\u30b3\u30fc\u30c9\u4f8b\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002\u3061\u306a\u307f\u306b\u3001\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306e\u30a2\u30a4\u30c6\u30e0\u306f1\u304b\u3089\u59cb\u307e\u308a\u307e\u3059\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>Dictionary<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Key-Value\u69cb\u9020\u306e\u53ef\u5909unique Item\u3092\u7ba1\u7406\u3067\u304d\u3001item\u3092\u52d5\u7684\u306bAdd\/Remove\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002<\/p>\n\n\n\n<p>Python\u8a00\u8a9e\u306eDictionary\u3001C++\u306eHashMap\u3001Java\u306eHashMap\u3068\u540c\u69d8\u306e\u30c7\u30fc\u30bf\u69cb\u9020\u3067\u3042\u308b\u3002\u30ad\u30fc\u5024\u306b\u8fd1\u3065\u304f\u3068\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306fO\uff081\uff09\u30ec\u30d9\u30eb\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u8f9e\u66f8\u30af\u30e9\u30b9\u306f\u57fa\u672c\u7684\u306b\u306f\u63d0\u4f9b\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3002 Early binding \u65b9\u5f0f\u3067\u4f7f\u7528\u3059\u308b\u306b\u306f\u3001\u307e\u305a\u300cMicrosoft Scripting Runtime\u300d\u3092\u53c2\u7167\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002 Late binding \u65b9\u5f0f\u3067\u4f7f\u7528\u3059\u308b\u306b\u306f CreateObject \u3092\u901a\u3058\u3066 instance \u3092\u751f\u6210\u3057\u3066\u4f7f\u7528\u3057\u307e\u3059\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>\u8f9e\u66f8\u30af\u30e9\u30b9\u3092\u4f7f\u7528\u3059\u308b\u305f\u3081\u306e\u300cMicrosoft Scripting Runtime\u300d\u53c2\u7167\u3092\u8ffd\u52a0\u3059\u308b<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Dictionary\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u5ba3\u8a00\u3001\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u751f\u6210\u3001Item\u8ffd\u52a0\u306a\u3069\u306e\u30bf\u30b9\u30af\u56fa\u6709\u306e\u30b3\u30fc\u30c9\u306b\u3064\u3044\u3066\u306f\u3001\u6b21\u306e\u8868\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Task<\/strong><\/td><td><strong>\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9<\/strong><\/td><\/tr><tr><td>\u5ba3\u8a00(early binding)<\/td><td>Dim oDic As Dictionary<\/td><\/tr><tr><td>Instance\u306e\u4f5c\u6210(early binding)<\/td><td>Set oDic = New Dictionary<\/td><\/tr><tr><td>\u5ba3\u8a00 (late binding)<\/td><td>Dim oDic As Object<\/td><\/tr><tr><td>Instance \u306e\u751f\u6210 (late binding)<\/td><td>Set oDic = CreateObject(\u201cScripting.Dictionary\u201d)<\/td><\/tr><tr><td>\u30a2\u30a4\u30c6\u30e0\u3092\u8ffd\u52a0<\/td><td>oDic.Add \u201cApples\u201d, 50<\/td><\/tr><tr><td>\u5024\u306e\u5909\u66f4<\/td><td>oDic(\u201cApples\u201d) = 60<\/td><\/tr><tr><td>\u5024\u3092\u53d6\u5f97<\/td><td>appleCount = oDic(\u201cApples\u201d)<\/td><\/tr><tr><td>Key\u304c\u5b58\u5728\u3059\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3059\u308b<\/td><td>oDic.Exists(\u201cApples\u201d)<\/td><\/tr><tr><td>\u30a2\u30a4\u30c6\u30e0\u306e\u524a\u9664<\/td><td>oDic.Remove(\u201cApples\u201d)<\/td><\/tr><tr><td>\u3059\u3079\u3066\u306e\u30a2\u30a4\u30c6\u30e0\u3092\u524a\u9664<\/td><td>oDic.RemoveAll<\/td><\/tr><tr><td>\u30a2\u30a4\u30c6\u30e0\u6570<\/td><td>oDic.Count<\/td><\/tr><tr><td>\u30a2\u30a4\u30c6\u30e0\u30eb\u30fc\u30d7\uff08For Each\uff09<\/td><td>Dim key As Variant<br>For Each key in oDic.Keys<br>&nbsp;&nbsp;&nbsp;&nbsp;Debug.Print key, oDic(key)<br>\u6b21\u306e\u30ad\u30fc<\/td><\/tr><tr><td>Item Loop (For, Early binding only)<\/td><td>Dim l As Long<br>For l = 0 To oDic.Count -1<br>&nbsp;&nbsp;&nbsp;&nbsp;Debug.Print oDic.Keys(l), oDic.Items(l)<br>Next l<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Dictionary\u3092\u4f7f\u7528\u3059\u308b\u4f8b\u306e\u30b3\u30fc\u30c9\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002\u3061\u306a\u307f\u306b\u3001Dictionary\u306eItems\u306f0\u304b\u3089\u59cb\u307e\u308b\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>Dictionary\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092For Loop\u69cb\u6587\u3067\u691c\u7d22\u3059\u308b\u3068\u304d\u306b\u30ad\u30fc\u5024\u3092\u542b\u3080\u5909\u6570\u306f\u3001Variant\u578b\u307e\u305f\u306fObject\u578b\u306e\u307f\u3067\u3059\u3002\u4e0a\u8a18\u306e\u4f8b\u3067\u306f\u300123\u884c\u76ee\u306824\u884c\u76ee\u306e\u30b3\u30fc\u30c9\u3067\u306fVariant\u5f62\u5f0f\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001VBA\u30c7\u30fc\u30bf\u578b\u3068\u30c7\u30fc\u30bf\u69cb\u9020\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3057\u305f\u3002\u7279\u306bCollection\u3068Dictionary\u306f\u3088\u304f\u4f7f\u3046\u53ef\u80fd\u6027\u304c\u975e\u5e38\u306b\u9ad8\u3044\u306e\u3067\u3001\u3088\u304f\u716e\u3066\u304a\u304d\u305f\u3044\u3002\u6b21\u306b\u3001VBA\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u6642\u306b\u77e5\u3063\u3066\u304a\u304f\u3068\u826f\u3044How-To\u306b\u3064\u3044\u3066\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>&lt;&lt;\u95a2\u9023\u8a18\u4e8b\u4e00\u89a7&gt;&gt;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/ja\/excel-vba-lecture-preface\/\">Excel VBA\u30b3\u30fc\u30b9\u3092\u958b\u59cb\u3057\u307e\u3059\u3002 \uff08\u8b1b\u5ea7\u4e88\u544a\u3001feat.Excel VBA\u3092\u63a8\u5968\u3059\u308b\u7406\u7531\uff09<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/ja\/excel-vba-lecture-1-overview\/\">Excel VBA\u30b3\u30fc\u30b9\uff081\uff09\uff1aExcel VBA\u306e\u6982\u8981<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/ja\/excel-vba-lecture-2-basic\/\">Excel VBA\u30b3\u30fc\u30b9\uff082\uff09\uff1aExcel VBA\u306e\u57fa\u790e<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/ja\/excel-vba-lecture-3-object-model\/\">Excel VBA\u30b3\u30fc\u30b9\uff083\uff09\uff1aExcel Object Model<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/ja\/excel-vba-lecture-4-handling-object-model\/\">Excel VBA\u30b3\u30fc\u30b9\uff084\uff09\uff1aExcel Object Model\u3092\u6271\u3046<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/ja\/excel-vba-lecture-5-excel-file-extension-vbe-font\/\">Excel VBA\u30b3\u30fc\u30b9\uff085\uff09\uff1aExcel\u30d5\u30a1\u30a4\u30eb\u62e1\u5f35\u5b50\u3001VBE\u3001\u30d5\u30a9\u30f3\u30c8\u8a2d\u5b9a<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/ja\/excel-vba-lecture-6-variable\/\">Excel VBA\u30b3\u30fc\u30b9\uff086\uff09\uff1aExcel VBA\u8a00\u8a9e\u57fa\u672c - \u5909\u6570<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/ja\/excel-vba-lecture-7-syntax\/\">Excel VBA\u30b3\u30fc\u30b9\uff087\uff09\uff1aExcel VBA\u8a00\u8a9e\u57fa\u672c - \u6587\u6cd5\uff08Syntax\uff09<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/ja\/excel-vba-lecture-8-datatype\/\">Excel VBA\u30b3\u30fc\u30b9\uff088\uff09\uff1aExcel VBA\u8a00\u8a9e\u57fa\u672c - \u30c7\u30fc\u30bf\u578b\uff08Data type\uff09\u3001\u30c7\u30fc\u30bf\u69cb\u9020\uff08Data structure\uff09<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/ja\/excel-vba-lecture-9-how-to\/\">Excel VBA\u30b3\u30fc\u30b9\uff089\uff09\uff1aExcel VBA How-To<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/ja\/excel-vba-lecture-10-self-developed-tools\/\">Excel VBA\u30b3\u30fc\u30b9\uff0810\uff09\uff1aExcel VBA\u3067\u958b\u767a\u3055\u308c\u4f7f\u7528\u3055\u308c\u3066\u3044\u308b\u30c4\u30fc\u30eb<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/ja\/excel-vba-lecture-toc\/\">Excel VBA\u30b3\u30fc\u30b9\u5168\u4f53\u76ee\u6b21<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Excel VBA\u8a00\u8a9e\u306e\u57fa\u672c\u7684\u306a\u30c7\u30fc\u30bf\u578b\uff08Data type\uff09\u3068\u63d0\u4f9b\u3055\u308c\u308b\u30c7\u30fc\u30bf\u69cb\u9020\uff08Data structure\uff09\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002\u524d\u306e\u8a18\u4e8b\u3067\u7d9a\u304f\u5185\u5bb9\u3060\u3002 Excel VBA\u30b3\u30fc\u30b9\uff087\uff09\uff1aExcel VBA\u8a00\u8a9e\u57fa\u672c - \u6587\u6cd5\uff08Syntax\uff093.3\u3002\u30c7\u30fc\u30bf\u578b3.3.1\u3002\u57fa\u672c\u30c7\u30fc\u30bf\u578bVB\uff08\u307e\u305f\u306fVBA\uff09\u304c\u30b5\u30dd\u30fc\u30c8\u3059\u308b\u30c7\u30fc\u30bf\u578b\u3092\u307e\u3068\u3081\u308b\u3068\u3001\u6b21\u306e\u8868\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002\u4ee5\u4e0b\u306e\u30bd\u30fc\u30b9\u306e\u8868\u306e\u5185\u5bb9\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3001...<\/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.4 - 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\/ja\/excel-vba-lecture-8-datatype\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\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\/ja\/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=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\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\":\"ja\",\"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\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-8-datatype\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@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\":\"ja\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@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\\\/ja\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel VBA \u30b3\u30fc\u30b9(8): Excel VBA \u8a00\u8a9e\u57fa\u672c-\u8cc7\u6599\u578b(Data type), \u30c7\u30fc\u30bf\u69cb\u9020(Data structure) - \u751f\u7523\u6027 Skill","description":"Excel VBA\u8a00\u8a9e\u306e\u57fa\u672c\u306e\u3046\u3061\u3001\u30c7\u30fc\u30bf\u578b\uff08Data type\uff09\u3068\u63d0\u4f9b\u3055\u308c\u308b\u30c7\u30fc\u30bf\u69cb\u9020\uff08Data structure\uff09\u306b\u3064\u3044\u3066\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002 Variant\u3001User-defined\u30c7\u30fc\u30bf\u578b\u3068Array\u3001Collection\u3001Dictionary\u306b\u3064\u3044\u3066\u78ba\u8a8d\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\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\/ja\/excel-vba-lecture-8-datatype\/","og_locale":"ja_JP","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\/ja\/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":{"\u57f7\u7b46\u8005":"Zerom","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"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":"ja","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 \u30b3\u30fc\u30b9(8): Excel VBA \u8a00\u8a9e\u57fa\u672c-\u8cc7\u6599\u578b(Data type), \u30c7\u30fc\u30bf\u69cb\u9020(Data structure) - \u751f\u7523\u6027 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":"Excel VBA\u8a00\u8a9e\u306e\u57fa\u672c\u306e\u3046\u3061\u3001\u30c7\u30fc\u30bf\u578b\uff08Data type\uff09\u3068\u63d0\u4f9b\u3055\u308c\u308b\u30c7\u30fc\u30bf\u69cb\u9020\uff08Data structure\uff09\u306b\u3064\u3044\u3066\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002 Variant\u3001User-defined\u30c7\u30fc\u30bf\u578b\u3068Array\u3001Collection\u3001Dictionary\u306b\u3064\u3044\u3066\u78ba\u8a8d\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/"]}]},{"@type":"ImageObject","inLanguage":"ja","@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\u7523\u6027\u30b9\u30ad\u30eb","description":"\u30e1\u30bf\u30b7\u30f3\u30ad\u30f3\u30b0\u3001\u30e1\u30bf\u30ef\u30fc\u30af","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":"ja"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"ja","@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\/ja\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/posts\/11386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/comments?post=11386"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/posts\/11386\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/media\/11388"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/media?parent=11386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/categories?post=11386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/tags?post=11386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}