{"id":2048,"date":"2023-10-22T19:48:52","date_gmt":"2023-10-22T19:48:52","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/"},"modified":"2023-12-10T06:06:14","modified_gmt":"2023-12-10T06:06:14","slug":"arama-degerleri-tablosu","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/","title":{"rendered":"Vba kullanarak bir dizideki de\u011fer nas\u0131l bulunur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-226570971\"><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>De\u011ferleri bir dizide saklad\u0131\u011f\u0131n\u0131zda, dizi aramas\u0131 yapman\u0131z gereken zamanlar olabilir. Bu durumda kullanabilece\u011finiz y\u00f6ntemleri bilmeniz gerekir. \u015eimdi bir dizide bir de\u011feri nas\u0131l arayaca\u011f\u0131n\u0131z\u0131 anlaman\u0131za yard\u0131mc\u0131 olabilecek a\u015fa\u011f\u0131daki koda bak\u0131n. <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57290\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir dizide-bir-de\u011fer bulma-1\" width=\"709\" height=\"1456\"><\/figure><\/div><ol type=\"1\"><li> Kodun ilk b\u00f6l\u00fcm\u00fcnde, daha sonra kodda kullanman\u0131z gereken <a href=\"https:\/\/exceladvisor.org\/tr\/degiskenler\/\">de\u011fi\u015fkenler<\/a> bulunur.<\/li><li> Bundan sonra, sonraki k\u0131s\u0131m diziden on de\u011feri almak i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/rnd\/\">RND<\/a> kullanarak <a href=\"https:\/\/exceladvisor.org\/tr\/rastgele-sayi\/\">rastgele say\u0131lar \u00fcretir<\/a> .<\/li><li> Daha sonra, bir giri\u015f kutusu tabloda aramak istedi\u011finiz de\u011feri girmenizi sa\u011flar.<\/li><li> Bundan sonra, giri\u015f kutusuna girdi\u011finiz de\u011ferin say\u0131 olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/eger-2\/\">IF ifadesini<\/a> kullanan bir sat\u0131r\u0131n\u0131z olur.<\/li><li> Bu b\u00f6l\u00fcmde, girdi\u011finiz de\u011ferin bulunamamas\u0131 durumunda <a href=\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/\">mesaj kutusunda<\/a> kullan\u0131lacak dizeye y\u00f6nelik bir kodunuz bulunmaktad\u0131r.<\/li><li> Kodun bu k\u0131sm\u0131 <a href=\"https:\/\/exceladvisor.org\/tr\/dizi-boyutu\/\">, dizideki her \u00f6\u011fe aras\u0131nda d\u00f6ng\u00fc yapmak<\/a> ve girdi\u011finiz de\u011ferin dizide olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/\">For (For Every) d\u00f6ng\u00fcs\u00fcn\u00fc<\/a> kullan\u0131r.<\/li><li> Kodun son k\u0131sm\u0131nda de\u011ferin bulunup bulunmad\u0131\u011f\u0131n\u0131 belirten bir mesaj g\u00f6r\u00fcnt\u00fclenir.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Option Base 1 Sub vba_array_search() 'this section declares an array and variables 'that you need to search within the array. Dim myArray(10) As Integer Dim i As Integer Dim varUserNumber As Variant Dim strMsg As String 'This part of the code adds 10 random numbers to 'the array and shows the result in the 'immediate window as well. For i = 1 To 10 myArray(i) = Int(Rnd * 10) Debug.Print myArray(i) Next i 'it is an input box that asks 'you the number that you want to find Loopback: varUserNumber = InputBox _ (\"Enter a number between 1 and 10 to search for:\", _ \"Linear Search Demonstrator\") 'it's an if statement that checks for the value that you 'have entered in the input box. If varUserNumber = \"\" Then End If Not IsNumeric(varUserNumber) Then GoTo Loopback If varUserNumber &lt; 1 Or varUserNumber &gt; 10 Then GoTo Loopback 'message to show if the value doesn't found. strMsg = \"Your value, \" &amp; varUserNumber &amp; _ \", was not found in the array.\" 'loop through the array and match each value with the 'the value you have entered in the input box. For i = 1 To UBound(myArray) If myArray(i) = varUserNumber Then strMsg = \"Your value, \" &amp; varUserNumber &amp; _ \", was found at position \" &amp; i &amp; \" in the array.\" Exit For End If Next i 'message box in the end MsgBox _ strMsg, vbOKOnly + vbInformation, _ \"Linear Search Result\" 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\/yeni-bir-deger-dizisi-ekle\/\">VBA diziye yeni de\u011fer ekle<\/a><\/li><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-2048","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>VBA kullanarak bir dizideki de\u011fer nas\u0131l bulunur?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde d\u00f6ng\u00fc kullanarak bir dizide nas\u0131l arama yapaca\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\/arama-degerleri-tablosu\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA kullanarak bir dizideki de\u011fer nas\u0131l bulunur?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde d\u00f6ng\u00fc kullanarak bir dizide nas\u0131l arama yapaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:06:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-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\/arama-degerleri-tablosu\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/\",\"name\":\"VBA kullanarak bir dizideki de\u011fer nas\u0131l bulunur?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png\",\"datePublished\":\"2023-10-22T19:48:52+00:00\",\"dateModified\":\"2023-12-10T06:06:14+00:00\",\"description\":\"Bu e\u011fitimde d\u00f6ng\u00fc kullanarak bir dizide nas\u0131l arama yapaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba kullanarak bir dizideki de\u011fer nas\u0131l bulunur?\"}]},{\"@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":"VBA kullanarak bir dizideki de\u011fer nas\u0131l bulunur?","description":"Bu e\u011fitimde d\u00f6ng\u00fc kullanarak bir dizide nas\u0131l arama yapaca\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\/arama-degerleri-tablosu\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA kullanarak bir dizideki de\u011fer nas\u0131l bulunur?","og_description":"Bu e\u011fitimde d\u00f6ng\u00fc kullanarak bir dizide nas\u0131l arama yapaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:06:14+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-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\/arama-degerleri-tablosu\/","url":"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/","name":"VBA kullanarak bir dizideki de\u011fer nas\u0131l bulunur?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png","datePublished":"2023-10-22T19:48:52+00:00","dateModified":"2023-12-10T06:06:14+00:00","description":"Bu e\u011fitimde d\u00f6ng\u00fc kullanarak bir dizide nas\u0131l arama yapaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/arama-degerleri-tablosu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba kullanarak bir dizideki de\u011fer nas\u0131l bulunur?"}]},{"@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\/2048","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=2048"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2048\/revisions"}],"predecessor-version":[{"id":2858,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2048\/revisions\/2858"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2048"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}