{"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\/de\/excel-vba-lecture-8-datatype\/","title":{"rendered":"Excel VBA-Kurs (8): Grundlagen der Excel VBA-Sprache \u2013 Datentypen, Datenstrukturen"},"content":{"rendered":"<p>In diesem Artikel betrachten wir den Datentyp und die bereitgestellte Datenstruktur unter den Grundlagen der Excel-VBA-Sprache.<\/p>\n\n\n\n<p>Dies ist eine Fortsetzung des vorherigen Artikels.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-7-syntax\/\">Excel VBA-Kurs (7): Grundlagen der Excel VBA-Sprache \u2013 Syntax<\/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;Inhaltsverzeichnis&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=\"Inhaltsverzeichnis umschalten\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Umschalten<\/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\/de\/excel-vba-lecture-8-datatype\/#33_%EC%9E%90%EB%A3%8C%ED%98%95\" >3.3. Datentyp<\/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\/de\/excel-vba-lecture-8-datatype\/#331_%EA%B8%B0%EB%B3%B8_%EC%9E%90%EB%A3%8C%ED%98%95\" >3.3.1. grundlegender Datentyp<\/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\/de\/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\" >Liste der grundlegenden Datentypen<\/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\/de\/excel-vba-lecture-8-datatype\/#Variant_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%98%95%EC%8B%9D\" >Variant-Datentyp<\/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\/de\/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\" >Benutzerdefinierter Datentyp<\/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\/de\/excel-vba-lecture-8-datatype\/#332_%EC%9E%90%EB%A3%8C%EA%B5%AC%EC%A1%B0\" >3.3.2. Datenstruktur<\/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\/de\/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\/de\/excel-vba-lecture-8-datatype\/#Collection\" >Sammlung<\/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\/de\/excel-vba-lecture-8-datatype\/#Dictionary\" >W\u00f6rterbuch<\/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. Datentyp<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. grundlegender Datentyp<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Die folgende Tabelle fasst die von VB (oder VBA) unterst\u00fctzten Datentypen zusammen. Unter den Tabelleninhalten der Quelle unten werden Collection und Dictionary separat in \u201eDatenstruktur\u201c erkl\u00e4rt.<\/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>Liste der grundlegenden Datentypen<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Quelle:&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>Datei Format<\/strong><\/td><td><strong>Speicherkapazit\u00e4t<\/strong><\/td><td><strong>Reichweite<\/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\">Boolesch<\/a><\/strong><\/td><td>2 Byte<\/td><td><strong>WAHR<\/strong>&nbsp;oder&nbsp;<strong>FALSCH<\/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>Sammlung<\/strong><\/td><td>Unbekannt<\/td><td>Unbekannt<\/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\">W\u00e4hrung<\/a><\/strong>&nbsp;(skalierte Ganzzahl)<\/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\">Datum<\/a><\/strong><\/td><td>8 Bytes<\/td><td>1. Januar 100 bis 31. Dezember 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\">Dezimal<\/a><\/strong><\/td><td>14 Byte<\/td><td>+\/-79.228.162.514.264.337.593.543.950.335 ohne Dezimalkomma<br><br>+\/-7,9228162514264337593543950335 mit 28 Nachkommastellen<br><br>Die kleinste Zahl ungleich Null ist +\/- 0,000000000000000000000000001<\/td><\/tr><tr><td><strong>W\u00f6rterbuch<\/strong><\/td><td>Unbekannt<\/td><td>Unbekannt<\/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\">Doppelt<\/a><\/strong>&nbsp;(Gleitkommazahl mit doppelter Genauigkeit)<\/td><td>8 Bytes<\/td><td>-1,79769313486231E308 bis -4,94065645841247E-324 f\u00fcr negative Werte<br><br>4,94065645841247E-324 bis 1,79769313486232E308 f\u00fcr positive Werte<\/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\">Ganze Zahl<\/a><\/strong><\/td><td>2 Byte<\/td><td>-32.768 bis 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\">Lang<\/a><\/strong>&nbsp;(Lange ganze Zahl)<\/td><td>4 Bytes<\/td><td>-2.147.483.648 bis 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\">Lang Lang<\/a><\/strong>&nbsp;(LongLong-Ganzzahl)<\/td><td>8 Bytes<\/td><td>-9.223.372.036.854.775.808 bis 9.223.372.036.854.775.807<br><br>Nur auf 64-Bit-Plattformen g\u00fcltig.<\/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\">LangPtr<\/a><\/strong>&nbsp;(Long Integer auf 32-Bit-Systemen, LongLong Integer auf 64-Bit-Systemen)<\/td><td>4 Bytes auf 32-Bit-Systemen<br><br>8 Bytes auf 64-Bit-Systemen<\/td><td>-2.147.483.648 bis 2.147.483.647 auf 32-Bit-Systemen<br><br>-9.223.372.036.854.775.808 bis 9.223.372.036.854.775.807 auf 64-Bit-Systemen<\/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\">Objekt<\/a><\/strong><\/td><td>4 Bytes<\/td><td>Beliebig&nbsp;<strong>Objekt<\/strong>&nbsp;Hinweis<\/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\">Einzel<\/a><\/strong>&nbsp;(Gleitkommazahl mit einfacher Genauigkeit)<\/td><td>4 Bytes<\/td><td>-3,402823E38 bis -1,401298E-45 f\u00fcr negative Werte<br><br>1.401298E-45 bis 3.402823E38 f\u00fcr positive Werte<\/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\">Schnur<\/a><\/strong>&nbsp;(variable L\u00e4nge)<\/td><td>10 Byte + Stringl\u00e4nge<\/td><td>0 bis ungef\u00e4hr 2 Milliarden<\/td><\/tr><tr><td><strong>Schnur<\/strong>&nbsp;(feste L\u00e4nge)<\/td><td>L\u00e4nge der Schnur<\/td><td>1 bis etwa 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\">Variante<\/a><\/strong>&nbsp;(mit Zahlen)<\/td><td>16 Byte<\/td><td>Jeder numerische Wert bis zum Bereich von a&nbsp;<strong>Doppelt<\/strong><\/td><\/tr><tr><td><strong>Variante<\/strong>&nbsp;(mit Zeichen)<\/td><td>22 Bytes + Stringl\u00e4nge (24 Bytes auf 64-Bit-Systemen)<\/td><td>Gleicher Bereich wie f\u00fcr variable L\u00e4nge&nbsp;<strong>Schnur<\/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\">Benutzerdefinierten<\/a><\/strong>&nbsp;(unter Verwendung&nbsp;<strong>Art<\/strong>)<\/td><td>Von Elementen ben\u00f6tigte Anzahl<\/td><td>Der Bereich jedes Elements ist derselbe wie der Bereich seines Datentyps.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Unter ihnen sind die am h\u00e4ufigsten verwendeten Datentypen Int, Long, String und Boolean.<\/p>\n\n\n\n<p>Varianten- und benutzerdefinierte Datentypen werden weiter unten n\u00e4her erl\u00e4utert.<\/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-Datentyp<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Der Variant-Datentyp ist ein spezieller Datentyp, der mehrere Datentypen speichern und verarbeiten kann. Wenn der Datentyp bei der Deklaration einer Variablen weggelassen wird, wird sie als Variant-Datentyp angegeben. Weitere Informationen zum Variant-Datenformat finden Sie unter der folgenden URL.<\/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>Verwenden Sie die VarType-Funktion, um zu \u00fcberpr\u00fcfen, welche Art von Daten eine Variant-Variable w\u00e4hrend der Ausf\u00fchrung speichert.<\/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>Konstruktion<\/strong><\/p>\n\n\n\n<p><strong>VarType(<\/strong><em>Varname<\/em><strong>)<\/strong><\/p>\n\n\n\n<p>wesentlich&nbsp;<em>Varname<\/em>&nbsp;Das Argument ist eine Variante, die Variablen enth\u00e4lt, ausgenommen Variablen benutzerdefinierter Typen.<\/p>\n\n\n\n<p><strong>R\u00fcckkehr<\/strong><strong>bilden<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>eine Konstante<\/strong><\/td><td><strong>Wert<\/strong><\/td><td><strong>Erl\u00e4uterung<\/strong><\/td><\/tr><tr><td><strong>vbLeer<\/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\">Leer<\/a>(nicht initialisiert)<\/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\">Null<\/a>(Keine Daten verf\u00fcgbar)<\/td><\/tr><tr><td><strong>vbInteger<\/strong><\/td><td>2<\/td><td>Wesen<\/td><\/tr><tr><td><strong>vbLang<\/strong><\/td><td>3<\/td><td>lange Ganzzahl<\/td><\/tr><tr><td><strong>vbSingle<\/strong><\/td><td>4<\/td><td>Gleitkommazahl mit einfacher Genauigkeit<\/td><\/tr><tr><td><strong>vbDouble<\/strong><\/td><td>5<\/td><td>Gleitkommazahl mit doppelter Genauigkeit<\/td><\/tr><tr><td><strong>vbW\u00e4hrung<\/strong><\/td><td>6<\/td><td>Wert der W\u00e4hrung<\/td><\/tr><tr><td><strong>vbDatum<\/strong><\/td><td>7<\/td><td>Datumswert<\/td><\/tr><tr><td><strong>vbString<\/strong><\/td><td>8<\/td><td>Schnur<\/td><\/tr><tr><td><strong>vbObjekt<\/strong><\/td><td>9<\/td><td>Individuell<\/td><\/tr><tr><td><strong>vbFehler<\/strong><\/td><td>10<\/td><td>Fehlerwert<\/td><\/tr><tr><td><strong>vbBoolesch<\/strong><\/td><td>11<\/td><td>Boolescher Wert<\/td><\/tr><tr><td><strong>vbVariante<\/strong><\/td><td>12<\/td><td><strong>Variante<\/strong>(Variante&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/glossary\/vbe-glossary#array\" target=\"_blank\" rel=\"noreferrer noopener\">Anordnung<\/a>nur gebraucht)<\/td><\/tr><tr><td><strong>vbDatenobjekt<\/strong><\/td><td>13<\/td><td>Datenzugriffsobjekt<\/td><\/tr><tr><td><strong>vbDezimal<\/strong><\/td><td>14<\/td><td>Dezimalwert<\/td><\/tr><tr><td><strong>vbByte<\/strong><\/td><td>17<\/td><td>Byte-Wert<\/td><\/tr><tr><td><strong>vbArray<\/strong><\/td><td>8192<\/td><td>Anordnung<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Pers\u00f6nlich verwende ich das Variant-Datenformat nicht gut, und ich verwende es haupts\u00e4chlich zum gleichzeitigen Lesen und Schreiben von Blattdaten. Informationen zum Lesen und Schreiben einer gro\u00dfen Menge Blattdaten mithilfe von Variantenarrays finden Sie im folgenden Artikel.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/de\/excel-vba-coding-pattern-range-loop-read\/\">VBA-Codierungsmuster: Bereichsschleife - Lesen<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/de\/excel-vba-coding-pattern-range-loop-write\/\">VBA-Codierungsmuster: Bereichsschleife - Schreiben<\/a><\/p>\n\n\n\n<p>Dies ist ein Beispielcode, der den Variant-Datentyp verwendet. Es zeigt, dass es mit Integer-, String-, Realzahl- und Datumsdatentypen umgehen kann.<\/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>Benutzerdefinierter Datentyp<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Sie k\u00f6nnen benutzerdefinierte Datentypen deklarieren und verwenden. Deklarieren Sie benutzerdefinierte Datentypen mit dem Schl\u00fcsselwort \u201eType\u201c, \u00e4hnlich wie \u201estruct\u201c in der Sprache C. Benutzerdefinierte Datentypen sind keine Objekte, daher wird bei der Deklaration eine Instanz erstellt, Speicher zugewiesen und Werte k\u00f6nnen eingegeben werden.<\/p>\n\n\n\n<p>Weitere Informationen zum benutzerdefinierten Datenformat finden Sie unter der folgenden URL.<\/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>Beispielcodes f\u00fcr benutzerdefinierte Datentypen sind wie folgt.<\/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. Datenstruktur<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Zu den h\u00e4ufig verwendeten Datenstrukturen geh\u00f6ren Array, Collection und Dictionary. Werfen wir einen Blick auf jeden.<\/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>Es hat eine feste Anzahl von Artikeln. Da es sich nicht um ein Objekt handelt, wird durch seine Deklaration eine Instanz erstellt. Beim Deklarieren k\u00f6nnen die Anzahl der Dimensionen und die Unter- und Obergrenze jeder Dimension angegeben werden, oder die Dimensionen und der Bereich eines Arrays k\u00f6nnen w\u00e4hrend der Ausf\u00fchrung dynamisch ge\u00e4ndert werden. Wenn Sie nur die Anzahl der Elemente angeben, ohne die Unter- und Obergrenze jeder Dimension anzugeben, ist die Untergrenze standardm\u00e4\u00dfig 0. Wenn Option Base 1 verwendet wird, ist die Standarduntergrenze 1.<\/p>\n\n\n\n<p>Deklarationsbeispielcode<\/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>Deklarieren Sie untere\/obere Grenzen f\u00fcr jede Dimension, \u00fcberpr\u00fcfen Sie: use LBound, UBound<\/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>\u00c4nderung der Dimensionsgr\u00f6\u00dfe: \u00c4ndern Sie die Dimensionsgr\u00f6\u00dfe eines dynamischen Arrays mit der Redim-Anweisung.<\/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>Gegenstandsschleife (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>Initialisierung: Initialisieren Sie Array-Variablen mit der Erase-Anweisung.<\/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>Sammlung<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Die Collection-Klasse \u00e4hnelt einem dynamischen Array. Eine variable Anzahl einzigartiger Gegenst\u00e4nde kann hinzugef\u00fcgt und entfernt werden. Weil es ein Objekt ist<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/set-statement\" target=\"_blank\" rel=\"noreferrer noopener\">Satz<\/a>\u201c und \u201eNeu\u201c, um eine Instanz zu erstellen. Wenn Sie in Visual Basic eine Referenz auf ein Objekt erstellen oder eine neue Referenz zuweisen, m\u00fcssen Sie \u201e<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/set-statement\" target=\"_blank\" rel=\"noreferrer noopener\">Satz<\/a>Das Schl\u00fcsselwort \u201eSet\u201c muss verwendet werden, und das Schl\u00fcsselwort \u201eSet\u201c wird nicht ben\u00f6tigt, wenn einer Variablen ein Wert zugewiesen wird. Sie m\u00fcssen zwischen der Behandlung von Objekten und Variablen unterscheiden, um Grammatikfehler zu vermeiden. Du kannst oft Fehler machen, sei also vorsichtig.<\/p>\n\n\n\n<p>In der folgenden Tabelle finden Sie Codes f\u00fcr jede Aufgabe, z. B. Sammlungsobjektdeklaration, Instanzerstellung und Elementhinzuf\u00fcgung.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Aufgabe<\/strong><\/td><td><strong>Beispielcode<\/strong><\/td><\/tr><tr><td>Erkl\u00e4rung<\/td><td>Dim o Col als Sammlung<\/td><\/tr><tr><td>Instanzerstellung<\/td><td>Setzen Sie oCol = Neue Sammlung<\/td><\/tr><tr><td>Instanzerstellung gleichzeitig mit Deklaration<\/td><td>Dim o Col als neue Kollektion<\/td><\/tr><tr><td>Artikel hinzuf\u00fcgen<\/td><td>oCol. \u201eApple\u201c hinzuf\u00fcgen<\/td><\/tr><tr><td>Greifen Sie \u00fcber den Index auf das Element zu<\/td><td>oCol(1)<\/td><\/tr><tr><td>Anzahl der Teile<\/td><td>oCol.Count<\/td><\/tr><tr><td>Gegenstandsschleife (f\u00fcr)<\/td><td>Dim l So lange<br>F\u00fcr l = 1 bis oCol.Count<br>&nbsp;&nbsp;&nbsp;&nbsp;Debug.Print oCol(l)<br>N\u00e4chste<\/td><\/tr><tr><td>Gegenstandsschleife (f\u00fcr jeden)<\/td><td>Dim Frucht als Variante<br>F\u00fcr jede Frucht in oCol<br>&nbsp;&nbsp;&nbsp;&nbsp;Debug.Frucht drucken<br>N\u00e4chste<\/td><\/tr><tr><td>Element entfernen (Index festlegen)<\/td><td>oFarbe Entfernen(1)<\/td><\/tr><tr><td>Instanz entfernen<\/td><td>Setzen Sie oCol = Nichts<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Beispielcode mit Collection lautet wie folgt. Als Referenz, Artikel in Sammlung beginnen mit 1.<\/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>W\u00f6rterbuch<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Es ist m\u00f6glich, variable eindeutige Elemente der Schl\u00fcsselwertstruktur zu verwalten und Elemente dynamisch hinzuzuf\u00fcgen\/zu entfernen.<\/p>\n\n\n\n<p>Es ist eine Datenstruktur \u00e4hnlich wie Dictionary in Python, HashMap in C++ und HashMap in Java. Beim Zugriff nach Schl\u00fcsselwert ist die Leistung O(1).<\/p>\n\n\n\n<p>Die Dictionary-Klasse wird standardm\u00e4\u00dfig nicht bereitgestellt. Um es in der fr\u00fchen Bindungsmethode zu verwenden, m\u00fcssen Sie zuerst auf \u201eMicrosoft Scripting Runtime\u201c verweisen. Erstellen Sie zur Verwendung in der sp\u00e4ten Bindungsmethode eine Instanz \u00fcber CreateObject und verwenden Sie sie.<\/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>\u201eMicrosoft Scripting Runtime\u201c-Referenz f\u00fcr die Verwendung der Dictionary-Klasse hinzugef\u00fcgt<\/figcaption><\/figure>\n<\/div>\n\n\n<p>In der folgenden Tabelle finden Sie den Code f\u00fcr jede Aufgabe, z. B. W\u00f6rterbuchobjektdeklaration, Instanzerstellung und Elementhinzuf\u00fcgung.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Aufgabe<\/strong><\/td><td><strong>Beispielcode<\/strong><\/td><\/tr><tr><td>Deklaration (fr\u00fchverbindlich)<\/td><td>Dim oDic als W\u00f6rterbuch<\/td><\/tr><tr><td>Instanzerstellung (fr\u00fche Bindung)<\/td><td>Setzen Sie oDic = Neues W\u00f6rterbuch<\/td><\/tr><tr><td>Deklaration (Late Binding)<\/td><td>Dim oDic als Objekt<\/td><\/tr><tr><td>Instanzerstellung (sp\u00e4tes Binden)<\/td><td>Set oDic = CreateObject (&quot;Scripting.Dictionary&quot;)<\/td><\/tr><tr><td>Artikel hinzuf\u00fcgen<\/td><td>oDic. \u201e\u00c4pfel\u201c hinzuf\u00fcgen, 50<\/td><\/tr><tr><td>Wert \u00e4ndern<\/td><td>oDic (\u201e\u00c4pfel\u201c) = 60<\/td><\/tr><tr><td>Wert erhalten<\/td><td>appleCount = oDic(&quot;\u00c4pfel&quot;)<\/td><\/tr><tr><td>\u00dcberpr\u00fcfen Sie, ob der Schl\u00fcssel vorhanden ist<\/td><td>oDic.Exists(\u201e\u00c4pfel\u201c)<\/td><\/tr><tr><td>Item l\u00f6schen<\/td><td>oDic.Remove(&quot;\u00c4pfel&quot;)<\/td><\/tr><tr><td>Alle Artikel l\u00f6schen<\/td><td>oDic.RemoveAll<\/td><\/tr><tr><td>Anzahl der Teile<\/td><td>odic. Graf<\/td><\/tr><tr><td>Gegenstandsschleife (f\u00fcr jeden)<\/td><td>Dim-Taste als Variante<br>F\u00fcr jede Taste in odic. Keys<br>&nbsp;&nbsp;&nbsp;&nbsp;Debug.Taste drucken, oDic(key)<br>N\u00e4chster Schl\u00fcssel<\/td><\/tr><tr><td>Gegenstandsschleife (nur f\u00fcr fr\u00fche Bindung)<\/td><td>Dim l So lange<br>F\u00fcr l = 0 bis oDic.Count -1<br>&nbsp;&nbsp;&nbsp;&nbsp;Debug.Print oDic.Keys(l), oDic.Items(l)<br>N\u00e4chste l<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Beispielcode, der Dictionary verwendet, lautet wie folgt. Als Referenz beginnen Elemente im W\u00f6rterbuch bei 0.<\/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>Beim Durchsuchen eines Dictionary-Objekts mit der For-Schleife-Anweisung kann die Variable, die den Schl\u00fcsselwert enthalten soll, nur vom Typ Variant oder Object sein. Im obigen Beispiel verwendete der Code in den Zeilen 23 und 24 das Variant-Format.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>In diesem Artikel haben wir uns VBA-Datentypen und Datenstrukturen angesehen. Insbesondere Sammlung und W\u00f6rterbuch werden sehr wahrscheinlich h\u00e4ufig verwendet, machen Sie sich also bitte damit vertraut. Als N\u00e4chstes sehen wir uns hilfreiche Anleitungen zum Programmieren von VBA an.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>&lt;&lt;Verwandte Artikelliste &gt;&gt;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-preface\/\">Starten Sie den Excel-VBA-Kurs. (Vorlesungsank\u00fcndigung, feat. Warum wir Excel VBA empfehlen)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-1-overview\/\">Excel VBA-Kurs(1): \u00dcberblick \u00fcber Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-2-basic\/\">Excel VBA-Kurs (2): Excel VBA-Grundlagen<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-3-object-model\/\">Excel VBA-Kurs (3): Excel-Objektmodell<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-4-handling-object-model\/\">Excel VBA-Kurs (4): Arbeiten mit dem Excel-Objektmodell<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-5-excel-file-extension-vbe-font\/\">Excel VBA-Kurs (5): Excel-Dateierweiterung, VBE, Schrifteinstellungen<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-6-variable\/\">Excel VBA-Kurs (6): Grundlagen der Excel VBA-Sprache \u2013 Variablen<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-7-syntax\/\">Excel VBA-Kurs (7): Grundlagen der Excel VBA-Sprache \u2013 Syntax<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-8-datatype\/\">Excel VBA-Kurs (8): Grundlagen der Excel VBA-Sprache \u2013 Datentypen, Datenstrukturen<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-9-how-to\/\">Excel VBA-Kurse (9): Excel VBA How-To<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-10-self-developed-tools\/\">Excel VBA-Kurs (10): Tools, die mit Excel VBA entwickelt und verwendet werden<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-toc\/\">Vollst\u00e4ndiges Inhaltsverzeichnis f\u00fcr Excel VBA-Kurse<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>In diesem Artikel betrachten wir die Datentypen und Datenstrukturen, die in der grundlegenden Excel-VBA-Sprache bereitgestellt werden. Dies ist eine Fortsetzung des vorherigen Artikels. Excel VBA-Kurs (7): Grundlagen der Excel VBA-Sprache \u2013 Syntax 3.3. Datentyp 3.3.1. Die folgende Tabelle fasst die grundlegenden Datentypen zusammen, die von VB (oder VBA) unterst\u00fctzt werden. Sammlung,...<\/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.3 - 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\/de\/excel-vba-lecture-8-datatype\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\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\/de\/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=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"9\u00a0Minuten\" \/>\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\":\"de\",\"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\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-8-datatype\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@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\":\"de\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@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\\\/de\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel VBA-Kurs (8): Grundlagen der Excel VBA-Sprache \u2013 Datentypen, Datenstrukturen \u2013 Produktivit\u00e4tsf\u00e4higkeiten","description":"Dieser Artikel untersucht die Grundlagen von Excel VBA, einschlie\u00dflich Datentypen und bereitgestellten Datenstrukturen. Sie erfahren mehr \u00fcber Varianten, benutzerdefinierte Datentypen, Arrays, Sammlungen und W\u00f6rterb\u00fccher.","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\/de\/excel-vba-lecture-8-datatype\/","og_locale":"de_DE","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\/de\/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":{"Verfasst von":"Zerom","Gesch\u00e4tzte Lesezeit":"9\u00a0Minuten"},"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":"de","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-Kurs (8): Grundlagen der Excel VBA-Sprache \u2013 Datentypen, Datenstrukturen \u2013 Produktivit\u00e4tsf\u00e4higkeiten","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":"Dieser Artikel untersucht die Grundlagen von Excel VBA, einschlie\u00dflich Datentypen und bereitgestellten Datenstrukturen. Sie erfahren mehr \u00fcber Varianten, benutzerdefinierte Datentypen, Arrays, Sammlungen und W\u00f6rterb\u00fccher.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/"]}]},{"@type":"ImageObject","inLanguage":"de","@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":"Produktivit\u00e4tsf\u00e4higkeiten","description":"Meta-Denken, Meta-Arbeiten","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":"de"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Nullm","image":{"@type":"ImageObject","inLanguage":"de","@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\/de\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts\/11386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/comments?post=11386"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts\/11386\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/media\/11388"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/media?parent=11386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/categories?post=11386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/tags?post=11386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}