{"id":1526,"date":"2023-11-17T21:05:22","date_gmt":"2023-11-17T21:05:22","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/"},"modified":"2023-12-10T06:04:54","modified_gmt":"2023-12-10T06:04:54","slug":"zincirli-masa","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/","title":{"rendered":"Vba arac\u0131l\u0131\u011f\u0131yla dizeleri olan bir dizi nas\u0131l olu\u015fturulur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3111622058\"><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>VBA&#8217;da, her dizi \u00f6\u011fesinin daha fazla eri\u015febilece\u011finiz veya hatta tek bir dizede birle\u015ftirebilece\u011finiz bir dizeyi saklad\u0131\u011f\u0131 dizelerden olu\u015fan bir dizi olu\u015fturabilirsiniz. Bunun d\u0131\u015f\u0131nda, ana dizeyi birden \u00e7ok alt dizeye b\u00f6lebilir (bir s\u0131n\u0131rlay\u0131c\u0131 kullanarak) ve ard\u0131ndan bunlar\u0131n her birini dizi \u00f6\u011felerinde saklayabilirsiniz.<\/p><p> Yukar\u0131da da s\u00f6yledi\u011fim gibi bir dizide string kullanman\u0131n iki yolu vard\u0131r ve bu e\u011fitimde her ikisi i\u00e7in de kod yazmay\u0131 g\u00f6rece\u011fiz.<\/p><h2 class=\"wp-block-heading\"> Dizelerle VBA dizisi<\/h2><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Option Base 1 Sub vba_string_array() Dim myArray() As Variant myArray = Array(\"One\", \"Two\", \"Three\") Debug.Print myArray(1) Debug.Print myArray(2) Debug.Print myArray(3) End Sub<\/code><\/pre><ol type=\"1\"><li> \u00d6ncelikle, i\u00e7inde saklamak istedi\u011finiz \u00f6\u011fe say\u0131s\u0131 olmadan bir dizi bildirin.<\/li><li> Daha sonra belirtmek istedi\u011finiz de\u011feri ayarlamak i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/dagitmak\/\">VBA&#8217;n\u0131n ARRAY i\u015flevini<\/a> kullanman\u0131z gerekir.<\/li><li> Bundan sonra, fonksiyonda virg\u00fcl kullanarak t\u00fcm dizeleri belirtin.<\/li><li> Sonu\u00e7ta \u00fcr\u00fcn numaras\u0131n\u0131 kullanarak t\u00fcm kanallara eri\u015febilirsiniz. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57132\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-dizeli-dizi-1\" width=\"486\" height=\"561\"><\/figure><\/div><p> Ayn\u0131 \u015fekilde, tabloda depolanacak h\u00fccrelerin bir dizisini de alabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57133\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-stocker-un-tableau-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"788\" height=\"562\"><\/figure><\/div><h2 class=\"wp-block-heading\"> VBA dizeyi b\u00f6lme ve bir dizide saklama<\/h2><p> Birden fazla alt dizeye sahip bir dize istiyorsan\u0131z, onu <a href=\"https:\/\/exceladvisor.org\/tr\/bolmek\/\">VBA&#8217;n\u0131n s\u0131n\u0131rlay\u0131c\u0131 kullanan SPLIT i\u015flevini<\/a> kullanarak b\u00f6lebilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Option Base 1 Sub vba_string_array() Dim myArray() As String myArray = Split(\"Today is a good day\", \" \") For i = LBound(myArray) To UBound(myArray) Debug.Print myArray(i) Next i End Sub<\/code><\/pre><p> Bu kodda be\u015f kelimelik bir ifadeden olu\u015fan bir dizeniz var. Ve split i\u015flevini kulland\u0131\u011f\u0131n\u0131zda, onu be\u015f farkl\u0131 alt dizeye b\u00f6ler ve ard\u0131ndan onu dizi \u00f6\u011felerinde saklars\u0131n\u0131z.<\/p><p> Bundan sonra, saya\u00e7 d\u00f6ng\u00fcs\u00fcn\u00fc olu\u015fturmak ve her dizi \u00f6\u011fesini <a href=\"https:\/\/exceladvisor.org\/tr\/aninda-pencere-hata-ayiklama-baskisi\/\">do\u011frudan<\/a> pencereye yazd\u0131rmak i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/yukariya-dogru\/\">\u00fcst<\/a> ve alt s\u0131n\u0131rlar\u0131 kullanan <a href=\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/\">for d\u00f6ng\u00fcs\u00fcne<\/a> sahip olursunuz.<\/p><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\/tr\/vba\/\">VBA nedir<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> <a href=\"https:\/\/exceladvisor.org\/tr\/resim-sergisi\/\">VBA tablolar\u0131<\/a> hakk\u0131nda daha fazla bilgi edinin <\/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\/tr\/dizi-boyutu\/\">VBA dizisi uzunlu\u011fu (boyut)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tahtayi-sil\/\">VBA Diziyi Temizle<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dinamik-tablo\/\">Dinamik tablo VBA&#8217;s\u0131<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/vba-dongu-dizisi\/\">Bir dizideki VBA d\u00f6ng\u00fcs\u00fc<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/plajin-bir-tablosu-var\/\">Bir diziye VBA aral\u0131\u011f\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/\">VBA \u00e7\u0131kt\u0131 tablosu<\/a><\/li><\/ul><\/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-1526","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>\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla dizelerden olu\u015fan bir dizi nas\u0131l olu\u015fturulur?<\/title>\n<meta name=\"description\" content=\"burada bir dizideki dizeleri \u00f6\u011fe olarak nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz ve ayr\u0131ca bir dizeyi alt \u00f6\u011felere nas\u0131l b\u00f6lece\u011finizi de \u00f6\u011freneceksiniz\" \/>\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\/tr\/zincirli-masa\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla dizelerden olu\u015fan bir dizi nas\u0131l olu\u015fturulur?\" \/>\n<meta property=\"og:description\" content=\"burada bir dizideki dizeleri \u00f6\u011fe olarak nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz ve ayr\u0131ca bir dizeyi alt \u00f6\u011felere nas\u0131l b\u00f6lece\u011finizi de \u00f6\u011freneceksiniz\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:04:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/\",\"name\":\"\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla dizelerden olu\u015fan bir dizi nas\u0131l olu\u015fturulur?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-1.png\",\"datePublished\":\"2023-11-17T21:05:22+00:00\",\"dateModified\":\"2023-12-10T06:04:54+00:00\",\"description\":\"burada bir dizideki dizeleri \u00f6\u011fe olarak nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz ve ayr\u0131ca bir dizeyi alt \u00f6\u011felere nas\u0131l b\u00f6lece\u011finizi de \u00f6\u011freneceksiniz\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba arac\u0131l\u0131\u011f\u0131yla dizeleri olan bir dizi nas\u0131l olu\u015fturulur?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla dizelerden olu\u015fan bir dizi nas\u0131l olu\u015fturulur?","description":"burada bir dizideki dizeleri \u00f6\u011fe olarak nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz ve ayr\u0131ca bir dizeyi alt \u00f6\u011felere nas\u0131l b\u00f6lece\u011finizi de \u00f6\u011freneceksiniz","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\/tr\/zincirli-masa\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla dizelerden olu\u015fan bir dizi nas\u0131l olu\u015fturulur?","og_description":"burada bir dizideki dizeleri \u00f6\u011fe olarak nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz ve ayr\u0131ca bir dizeyi alt \u00f6\u011felere nas\u0131l b\u00f6lece\u011finizi de \u00f6\u011freneceksiniz","og_url":"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:04:54+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/","url":"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/","name":"\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla dizelerden olu\u015fan bir dizi nas\u0131l olu\u015fturulur?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-1.png","datePublished":"2023-11-17T21:05:22+00:00","dateModified":"2023-12-10T06:04:54+00:00","description":"burada bir dizideki dizeleri \u00f6\u011fe olarak nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz ve ayr\u0131ca bir dizeyi alt \u00f6\u011felere nas\u0131l b\u00f6lece\u011finizi de \u00f6\u011freneceksiniz","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/zincirli-masa\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba arac\u0131l\u0131\u011f\u0131yla dizeleri olan bir dizi nas\u0131l olu\u015fturulur?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1526","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1526"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1526\/revisions"}],"predecessor-version":[{"id":2774,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1526\/revisions\/2774"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}