{"id":2047,"date":"2023-10-22T20:08:02","date_gmt":"2023-10-22T20:08:02","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/"},"modified":"2023-12-10T06:07:30","modified_gmt":"2023-12-10T06:07:30","slug":"siralama-tablosu","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/","title":{"rendered":"Vba&#39;da bir dizi nas\u0131l s\u0131ralan\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3333375815\"><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 bir diziyi s\u0131ralamak i\u00e7in, dizinin ilk \u00f6\u011fesini bir sonrakiyle e\u015fle\u015ftirebilece\u011finiz ve ilk \u00f6\u011fenin \u00f6nce gelmesi gerekiyorsa bunlar\u0131 de\u011fi\u015ftirebilece\u011finiz bir kod yazman\u0131z gerekir. Bunun i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/\">FOR (Sonraki \u0130\u00e7in) d\u00f6ng\u00fcs\u00fcne<\/a> ve <a href=\"https:\/\/exceladvisor.org\/tr\/ucase\/\">UCASE i\u015flevine<\/a> ihtiyac\u0131n\u0131z var.<\/p><p> Bu derste bir dizinin elemanlar\u0131n\u0131 s\u0131ralaman\u0131n iki yolunu (AZ ve ZA) g\u00f6rece\u011fiz.<\/p><h2 class=\"wp-block-heading\"> Bir diziyi s\u0131ralama (AZ)<\/h2><p> A\u015fa\u011f\u0131daki kodda be\u015f elemanl\u0131 bir diziniz var ve bu elemanlar\u0131n E&#8217;den A&#8217;ya kadar de\u011fi\u015fen de\u011ferleri var ve \u015fimdi A&#8217;dan Z&#8217;ye s\u0131ralamam\u0131z gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57136\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"dizi-s\u0131ralama-1\" width=\"415\" height=\"411\"><\/figure><\/div><p> <strong>Bir diziyi s\u0131ralama ad\u0131mlar\u0131<\/strong><\/p><ol type=\"1\"><li> \u00d6ncelikle dizinin \u00fcst ve alt s\u0131n\u0131rlar\u0131n\u0131 kullanarak For Next ile i\u00e7 i\u00e7e bir d\u00f6ng\u00fc yazman\u0131z gerekiyor.<\/li><li> Bundan sonra bu d\u00f6ng\u00fcde iki \u00f6\u011feyi kar\u015f\u0131la\u015ft\u0131rmak i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/eger-2\/\">VBA IF ifadesini<\/a> kullanman\u0131z gerekir.<\/li><li> Buradan, e\u011fer ilk eleman\u0131n bir sonraki elemandan \u00f6nce gelmesi gerekiyorsa, de\u011ferlerini de\u011fi\u015fkenlere kaydederek bunlar\u0131 de\u011fi\u015ftirmeniz gerekir.<\/li><li> Sonunda d\u00f6ng\u00fcy\u00fc tamamlamak i\u00e7in \u201cSonraki\u201d anahtar kelimesini kullan\u0131n. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57137\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-boucles-imbriquees-avec-pour-les-2-suivantes.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"626\" height=\"324\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Option Base 1 Sub vba_sort_array_a_to_z() Dim myArray() As Variant ReDim myArray(5) Dim i As Integer Dim j As Integer Dim Temp As String myArray(1) = \"E\" myArray(2) = \"D\" myArray(3) = \"C\" myArray(4) = \"B\" myArray(5) = \"A\" 'sorting array from A to Z For i = LBound(myArray) To UBound(myArray) For j = i + 1 To UBound(myArray) If UCase(myArray(i)) &gt; UCase(myArray(j)) Then Temp = myArray(j) myArray(j) = myArray(i) myArray(i) = Temp End If Next j Next i Debug.Print myArray(1) Debug.Print myArray(2) Debug.Print myArray(3) Debug.Print myArray(4) Debug.Print myArray(5) End Sub<\/code><\/pre><p> Sonu\u00e7lar\u0131 orada g\u00f6rmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/aninda-pencere-hata-ayiklama-baskisi\/\">Hemen penceresini<\/a> etkinle\u015ftirdi\u011finizden emin olun.<\/p><h2 class=\"wp-block-heading\"> Bir diziyi s\u0131ralama (ZA)<\/h2><p> Ayn\u0131 \u015fekilde ZA&#8217;ya g\u00f6re de s\u0131ralama yapabilirsiniz. \u00d6nceki y\u00f6ntemde, dizideki ilk \u00f6\u011feyi sonraki \u00f6\u011feyle kar\u015f\u0131la\u015ft\u0131rd\u0131k ancak bu kodda tam tersini yapman\u0131z gerekiyor. Yani e\u011fer ikinci eleman (s\u0131rayla bir sonraki) birinciden b\u00fcy\u00fckse, kod onlar\u0131 de\u011fi\u015ftirecektir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Option Base 1 Sub vba_sort_array_z_to_a() Dim myArray() As Variant ReDim myArray(5) Dim i As Integer Dim j As Integer Dim Temp As String myArray(1) = \"A\" myArray(2) = \"B\" myArray(3) = \"C\" myArray(4) = \"D\" myArray(5) = \"E\" 'sorting array from A to Z For i = LBound(myArray) To UBound(myArray) For j = i + 1 To UBound(myArray) If UCase(myArray(i)) &lt; UCase(myArray(j)) Then Temp = myArray(j) myArray(j) = myArray(i) myArray(i) = Temp End If Next j Next i Debug.Print myArray(1) Debug.Print myArray(2) Debug.Print myArray(3) Debug.Print myArray(4) Debug.Print myArray(5) End Sub<\/code><\/pre><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\/zincirli-masa\/\">Dizelerle VBA dizisi<\/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><\/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-2047","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&#039;da bir dizi nas\u0131l s\u0131ralan\u0131r? (E\u011fitim 2023)<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, dizinin ilk \u00f6\u011fesini sonraki ve sonraki \u00f6\u011feyle e\u015fle\u015ftirerek VBA&#039;da bir diziyi nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z\u0131 \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\/siralama-tablosu\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 VBA&#039;da bir dizi nas\u0131l s\u0131ralan\u0131r? (E\u011fitim 2023)\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, dizinin ilk \u00f6\u011fesini sonraki ve sonraki \u00f6\u011feyle e\u015fle\u015ftirerek VBA&#039;da bir diziyi nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:07:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-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\/siralama-tablosu\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/\",\"name\":\"\u25b7 VBA&#39;da bir dizi nas\u0131l s\u0131ralan\u0131r? (E\u011fitim 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png\",\"datePublished\":\"2023-10-22T20:08:02+00:00\",\"dateModified\":\"2023-12-10T06:07:30+00:00\",\"description\":\"Bu e\u011fitimde, dizinin ilk \u00f6\u011fesini sonraki ve sonraki \u00f6\u011feyle e\u015fle\u015ftirerek VBA&#39;da bir diziyi nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba&#39;da bir dizi nas\u0131l s\u0131ralan\u0131r?\"}]},{\"@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&#39;da bir dizi nas\u0131l s\u0131ralan\u0131r? (E\u011fitim 2023)","description":"Bu e\u011fitimde, dizinin ilk \u00f6\u011fesini sonraki ve sonraki \u00f6\u011feyle e\u015fle\u015ftirerek VBA&#39;da bir diziyi nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z\u0131 \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\/siralama-tablosu\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 VBA&#39;da bir dizi nas\u0131l s\u0131ralan\u0131r? (E\u011fitim 2023)","og_description":"Bu e\u011fitimde, dizinin ilk \u00f6\u011fesini sonraki ve sonraki \u00f6\u011feyle e\u015fle\u015ftirerek VBA&#39;da bir diziyi nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:07:30+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-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\/siralama-tablosu\/","url":"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/","name":"\u25b7 VBA&#39;da bir dizi nas\u0131l s\u0131ralan\u0131r? (E\u011fitim 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png","datePublished":"2023-10-22T20:08:02+00:00","dateModified":"2023-12-10T06:07:30+00:00","description":"Bu e\u011fitimde, dizinin ilk \u00f6\u011fesini sonraki ve sonraki \u00f6\u011feyle e\u015fle\u015ftirerek VBA&#39;da bir diziyi nas\u0131l s\u0131ralayaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba&#39;da bir dizi nas\u0131l s\u0131ralan\u0131r?"}]},{"@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\/2047","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=2047"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2047\/revisions"}],"predecessor-version":[{"id":2934,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2047\/revisions\/2934"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2047"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}