{"id":1527,"date":"2023-11-17T21:02:46","date_gmt":"2023-11-17T21:02:46","guid":{"rendered":"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/"},"modified":"2023-12-10T06:22:54","modified_gmt":"2023-12-10T06:22:54","slug":"matrice-multidimensionale","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/","title":{"rendered":"Come creare una tabella multidimensionale?"},"content":{"rendered":"<div class=\"excel-prima-del-contenuto\" id=\"excel-3940167077\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Per creare una matrice con pi\u00f9 dimensioni, \u00e8 necessario definire le dimensioni durante la dichiarazione della matrice. Bene, puoi definire tutte le dimensioni che desideri (VBA consente 60 dimensioni), ma probabilmente non avrai bisogno di utilizzare pi\u00f9 di 2 o 3 dimensioni da nessuno degli array. Usare una tabella bidimensionale \u00e8 come avere righe e colonne.<\/p><p> In questo tutorial vedremo come creare un array 2D e 3D.<\/p><h2 class=\"wp-block-heading\"> Crea un array multidimensionale in VBA<\/h2><ol><li> Utilizza l&#8217; <a href=\"https:\/\/exceladvisor.org\/it\/debole\/\">istruzione Dim<\/a> per dichiarare l&#8217;array con il nome che desideri assegnargli. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-array-multidimensionale-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"466\" height=\"212\"><\/li><li> Successivamente, inserisci una parentesi iniziale e imposta il numero di elementi per la prima dimensione. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-set-numero-di-elementi-2\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-definir-le-nombre-delements-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"465\" height=\"218\"><\/li><li> Successivamente, digita un comando e inserisci il numero di elementi che desideri avere nella seconda dimensione, quindi chiudi le parentesi. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-inserisci-il-numero-di-un-articolo\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-entrez-un-nombre-delements.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"465\" height=\"231\"><\/li><li> Alla fine, imposta il <a href=\"https:\/\/exceladvisor.org\/it\/variabili\/\">tipo di dati<\/a> per la tabella come variante o qualsiasi tipo di dati desideri. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-tabella-come-variante-4\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-tableau-en-variante-4.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"512\" height=\"193\"><\/li><\/ol><p> Ecco il codice.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_multi_dimensional_array() Dim myArray(5, 2) As Variant myArray(1, 1) = 1 myArray(2, 1) = 2 myArray(3, 1) = 3 myArray(4, 1) = 4 myArray(5, 1) = 5 myArray(1, 2) = 6 myArray(2, 2) = 7 myArray(3, 2) = 8 myArray(4, 2) = 9 myArray(5, 2) = 10 End Sub<\/code><\/pre><p> Il codice precedente per la tabella crea una tabella con 5 righe e 2 colonne e sar\u00e0 simile a questa. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57145\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-cree-un-tableau-5.png\" sizes=\"auto, \" srcset=\"\" alt=\"creare-una-scheda-5\" width=\"158\" height=\"121\"><\/figure><\/div><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/it\/vba\/\">Cos&#8217;\u00e8 VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Ulteriori informazioni sulle <a href=\"https:\/\/exceladvisor.org\/it\/dipinti\/\">tabelle VBA<\/a> <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/it\/aggiungere-una-nuova-matrice-di-valori\/\">VBA Aggiungi un nuovo valore all&#8217;array<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/dimensione-della-matrice\/\">Lunghezza dell&#8217;array VBA (dimensione)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/tavolo-con-catene\/\">Array VBA con stringhe<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/cancella-la-lavagna\/\">Cancella matrice VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/tabella-dinamica\/\">Tabella dinamica VBA<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1527","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Come creare una tabella multidimensionale utilizzando VBA?<\/title>\n<meta name=\"description\" content=\"Per creare una matrice con pi\u00f9 dimensioni, \u00e8 necessario definire le dimensioni durante la dichiarazione della matrice. Beh, puoi\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Come creare una tabella multidimensionale utilizzando VBA?\" \/>\n<meta property=\"og:description\" content=\"Per creare una matrice con pi\u00f9 dimensioni, \u00e8 necessario definire le dimensioni durante la dichiarazione della matrice. Beh, puoi\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:22:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/\",\"name\":\"Come creare una tabella multidimensionale utilizzando VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png\",\"datePublished\":\"2023-11-17T21:02:46+00:00\",\"dateModified\":\"2023-12-10T06:22:54+00:00\",\"description\":\"Per creare una matrice con pi\u00f9 dimensioni, \u00e8 necessario definire le dimensioni durante la dichiarazione della matrice. Beh, puoi\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceladvisor.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Come creare una tabella multidimensionale?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"name\":\"Excel Advisor\",\"description\":\"Tips, Tricks, and Time-Saving Hacks\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/it\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Come creare una tabella multidimensionale utilizzando VBA?","description":"Per creare una matrice con pi\u00f9 dimensioni, \u00e8 necessario definire le dimensioni durante la dichiarazione della matrice. Beh, puoi","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:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/","og_locale":"it_IT","og_type":"article","og_title":"Come creare una tabella multidimensionale utilizzando VBA?","og_description":"Per creare una matrice con pi\u00f9 dimensioni, \u00e8 necessario definire le dimensioni durante la dichiarazione della matrice. Beh, puoi","og_url":"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:22:54+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo di lettura stimato":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/","url":"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/","name":"Come creare una tabella multidimensionale utilizzando VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png","datePublished":"2023-11-17T21:02:46+00:00","dateModified":"2023-12-10T06:22:54+00:00","description":"Per creare una matrice con pi\u00f9 dimensioni, \u00e8 necessario definire le dimensioni durante la dichiarazione della matrice. Beh, puoi","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/it\/matrice-multidimensionale\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceladvisor.org\/it\/"},{"@type":"ListItem","position":2,"name":"Come creare una tabella multidimensionale?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/it\/#website","url":"https:\/\/exceladvisor.org\/it\/","name":"Excel Advisor","description":"Tips, Tricks, and Time-Saving Hacks","publisher":{"@id":"https:\/\/exceladvisor.org\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/it\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/it\/","logo":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1527","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/comments?post=1527"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1527\/revisions"}],"predecessor-version":[{"id":2455,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1527\/revisions\/2455"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/media?parent=1527"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}