{"id":2136,"date":"2023-09-29T01:54:15","date_gmt":"2023-09-29T01:54:15","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/zincir-1\/"},"modified":"2023-12-10T05:59:22","modified_gmt":"2023-12-10T05:59:22","slug":"zincir-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/zincir-1\/","title":{"rendered":"Dizeleri birle\u015ftirmek i\u00e7in vba nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2732182028\"><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 kodunu kullanarak iki dizeyi birle\u015ftirmek i\u00e7in ve i\u015faretini kullanman\u0131z gerekir. \u0130ki dize aras\u0131nda bir ve i\u015fareti kullanarak bunlar\u0131 birle\u015ftirebilir ve ard\u0131ndan bu yeni de\u011feri bir h\u00fccreye, de\u011fi\u015fkene veya mesaj kutusuna atayabilirsiniz. Benzer \u015fekilde ikiden fazla de\u011feri de birle\u015ftirebilirsiniz.<\/p><p> Daha sonra bunu anlamak i\u00e7in basit bir \u00f6rnek g\u00f6rece\u011fiz.<\/p><h2 class=\"wp-block-heading\"> Birle\u015ftirmek i\u00e7in VBA&#8217;y\u0131 kullanma ad\u0131mlar\u0131<\/h2><ol type=\"1\"><li> \u0130lk \u00f6nce \u00e7ift t\u0131rnak kullanarak ilk dizeyi girin.<\/li><li> Bundan sonra bir ve i\u015fareti yaz\u0131n.<\/li><li> Daha sonra \u00e7ift t\u0131rnak kullanarak ikinci metni girin.<\/li><li> Sonunda bu de\u011feri bir h\u00fccreye veya de\u011fi\u015fkene atay\u0131n veya g\u00f6rmek i\u00e7in bir mesaj kutusu kullan\u0131n.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_concatenate() Range(\"A1\") = \"Mike\" &amp; \"Ross\" End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> S\u0131n\u0131rlay\u0131c\u0131yla birle\u015ftir<\/h2><p> Ayr\u0131ca, yaln\u0131zca \u00fc\u00e7\u00fcnc\u00fc bir ve i\u015fareti ekleyerek iki dize aras\u0131nda bir s\u0131n\u0131rlay\u0131c\u0131 kullanabilirsiniz. A\u015fa\u011f\u0131daki kodu g\u00f6z \u00f6n\u00fcnde bulundurun.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\") = \"Mike\" &amp; \"-\" &amp; \"Ross\"<\/code><\/pre><p> Yukar\u0131daki kodda, iki dizede bir s\u0131n\u0131rlay\u0131c\u0131 kulland\u0131n\u0131z ve bunlar\u0131 yaln\u0131zca ve i\u015fareti kullanarak birle\u015ftirdiniz. Yani temel olarak, ne zaman bir \u015feyi i\u00e7ine alman\u0131z gerekiyorsa, onun i\u00e7inde ve i\u015fareti kullanman\u0131z gerekir.<\/p><h2 class=\"wp-block-heading\"> De\u011fi\u015fkenleri kullanarak birle\u015ftirme<\/h2><p> Ayr\u0131ca de\u011ferleri de\u011fi\u015fkenlerde saklayabilir ve daha sonra bu iki de\u011fi\u015fkenin de\u011ferlerini birle\u015ftirebilirsiniz. A\u015fa\u011f\u0131daki kodu g\u00f6z \u00f6n\u00fcnde bulundurun.<\/p><p> Yukar\u0131daki kodda de\u011fi\u015fken olarak bildirdi\u011finiz de\u011fi\u015fkenler var ve daha sonra bu de\u011fi\u015fkenlere de\u011ferler atad\u0131n\u0131z. Sonunda, \u00fc\u00e7 de\u011fi\u015fkeni birle\u015ftirmek i\u00e7in ve i\u015fareti kulland\u0131k ve sonucu A1 h\u00fccresine atad\u0131k.<\/p><h2 class=\"wp-block-heading\"> VBA kullanarak bir aral\u0131\u011f\u0131 birle\u015ftirme<\/h2><p> Ayr\u0131ca VBA&#8217;y\u0131 kullanarak bir h\u00fccre aral\u0131\u011f\u0131ndaki de\u011ferleri birle\u015ftirebilirsiniz. A\u015fa\u011f\u0131daki makroyu g\u00f6z \u00f6n\u00fcnde bulundurun.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_concatenate() Dim rng As Range Dim i As String Dim SourceRange As Range Set SourceRange = Range(\"A1:A10\") For Each rng In SourceRange i = i &amp; rng &amp; \" \" Next rng Range(\"B1\").Value = Trim(i) End Sub<\/code><\/pre><p> Yukar\u0131daki kodda, birle\u015ftirmek istedi\u011finiz aral\u0131kta d\u00f6ng\u00fc yapmak i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/\">FOR NEXT&#8217;i (D\u00f6ng\u00fcler \u0130\u00e7in)<\/a> kulland\u0131n\u0131z.<\/p><p> B\u00f6ylece (A1:A10) aral\u0131\u011f\u0131ndaki her h\u00fccreye gider ve bu de\u011feri I de\u011fi\u015fkeninde saklar ve her yinelemede bir de\u011feri birle\u015ftirmek i\u00e7in bir ve i\u015fareti kullan\u0131r. Sonunda, birle\u015ftirilmi\u015f kanal\u0131 B1 aral\u0131\u011f\u0131na ayarlay\u0131n.<\/p><p> Ve a\u015fa\u011f\u0131daki kod se\u00e7ilen aral\u0131\u011f\u0131n de\u011ferlerini birle\u015ftirir. Tek yapman\u0131z gereken bir aral\u0131k se\u00e7ip kodu \u00e7al\u0131\u015ft\u0131rmak.<\/p><pre class=\"wp-block-code\" title=\"\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim rng As Range Dim i As String For Each rng In Selection i = i &amp; rng &amp; \" \" Next rng Range(\"B1\").Value = Trim(i)<\/code><\/pre><h2 class=\"wp-block-heading\"> Bir s\u00fctunun veya sat\u0131r\u0131n tamam\u0131n\u0131 birle\u015ftirme<\/h2><p> Bir s\u00fctunun veya sat\u0131r\u0131n tamam\u0131n\u0131 birle\u015ftirmek istiyorsan\u0131z, bu durumda d\u00f6ng\u00fc y\u00f6ntemini kullanmamak daha iyidir. Bir sat\u0131r\u0131n veya s\u00fctunun tamam\u0131n\u0131 birle\u015ftirebilen &#8220;TextJoin&#8221; \u00e7al\u0131\u015fma sayfas\u0131 i\u015flevini kullanabilirsiniz (a\u015fa\u011f\u0131daki kodu g\u00f6z \u00f6n\u00fcnde bulundurun).<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">'join values from column A. Dim myRange As Range Dim myString As String Range(\"B1\") = WorksheetFunction.TextJoin(\" \", True, Range(\"A:A\")) 'join values from row 1. Dim myRange As Range Dim myString As String Range(\"B1\") = WorksheetFunction.TextJoin(\" \", True, Range(\"1:1\"))<\/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\"> \u0130lgili e\u011fitimler <\/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\/ortalama-2\/\">VBA ile Excel&#8217;deki ortalama de\u011ferler<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bugunun-tarihi-simdiki-saat\/\">VBA&#8217;y\u0131 kullanarak bug\u00fcn\u00fcn tarihini ve ge\u00e7erli saatini al\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-1\/\">VBA kullanarak Excel&#8217;deki de\u011ferleri toplay\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/mac-2\/\">VBA&#8217;da e\u015fle\u015ftirme i\u015flevi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/mod-1\/\">VBA&#8217;da MOD<\/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-2136","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 Dizeleri birle\u015ftirmek i\u00e7in VBA nas\u0131l kullan\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"VBA kodunu kullanarak iki dizeyi birle\u015ftirmek i\u00e7in ve i\u015faretini kullanman\u0131z gerekir. \u0130kisi aras\u0131nda ve i\u015fareti kullanabilirsiniz\" \/>\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\/zincir-1\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Dizeleri birle\u015ftirmek i\u00e7in VBA nas\u0131l kullan\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"VBA kodunu kullanarak iki dizeyi birle\u015ftirmek i\u00e7in ve i\u015faretini kullanman\u0131z gerekir. \u0130kisi aras\u0131nda ve i\u015fareti kullanabilirsiniz\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/zincir-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:59:22+00:00\" \/>\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=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/zincir-1\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/zincir-1\/\",\"name\":\"\u25b7 Dizeleri birle\u015ftirmek i\u00e7in VBA nas\u0131l kullan\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"datePublished\":\"2023-09-29T01:54:15+00:00\",\"dateModified\":\"2023-12-10T05:59:22+00:00\",\"description\":\"VBA kodunu kullanarak iki dizeyi birle\u015ftirmek i\u00e7in ve i\u015faretini kullanman\u0131z gerekir. \u0130kisi aras\u0131nda ve i\u015fareti kullanabilirsiniz\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/zincir-1\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/zincir-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/zincir-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dizeleri birle\u015ftirmek i\u00e7in vba nas\u0131l kullan\u0131l\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 Dizeleri birle\u015ftirmek i\u00e7in VBA nas\u0131l kullan\u0131l\u0131r?","description":"VBA kodunu kullanarak iki dizeyi birle\u015ftirmek i\u00e7in ve i\u015faretini kullanman\u0131z gerekir. \u0130kisi aras\u0131nda ve i\u015fareti kullanabilirsiniz","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\/zincir-1\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Dizeleri birle\u015ftirmek i\u00e7in VBA nas\u0131l kullan\u0131l\u0131r?","og_description":"VBA kodunu kullanarak iki dizeyi birle\u015ftirmek i\u00e7in ve i\u015faretini kullanman\u0131z gerekir. \u0130kisi aras\u0131nda ve i\u015fareti kullanabilirsiniz","og_url":"https:\/\/exceladvisor.org\/tr\/zincir-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:59:22+00:00","twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/zincir-1\/","url":"https:\/\/exceladvisor.org\/tr\/zincir-1\/","name":"\u25b7 Dizeleri birle\u015ftirmek i\u00e7in VBA nas\u0131l kullan\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"datePublished":"2023-09-29T01:54:15+00:00","dateModified":"2023-12-10T05:59:22+00:00","description":"VBA kodunu kullanarak iki dizeyi birle\u015ftirmek i\u00e7in ve i\u015faretini kullanman\u0131z gerekir. \u0130kisi aras\u0131nda ve i\u015fareti kullanabilirsiniz","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/zincir-1\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/zincir-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/zincir-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Dizeleri birle\u015ftirmek i\u00e7in vba nas\u0131l kullan\u0131l\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\/2136","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=2136"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2136\/revisions"}],"predecessor-version":[{"id":2317,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2136\/revisions\/2317"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}