{"id":2062,"date":"2023-10-21T12:28:37","date_gmt":"2023-10-21T12:28:37","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/davayi-sec\/"},"modified":"2023-12-10T06:07:54","modified_gmt":"2023-12-10T06:07:54","slug":"davayi-sec","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/davayi-sec\/","title":{"rendered":"Vba&#39;da select case deyimi nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2483735908\"><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> <h2 class=\"wp-block-heading\">Anahtar noktalar\u0131<\/h2><ul><li> SELECT CASE ile \u00f6zellikle ikiden fazla ko\u015ful \u00fczerinde \u00e7al\u0131\u015f\u0131rken birden \u00e7ok ko\u015fulu test edebilirsiniz.<\/li><li> SELECT CASE ile yazd\u0131\u011f\u0131n\u0131z kod, standart ko\u015fullu koda g\u00f6re \u00e7ok daha yap\u0131land\u0131r\u0131lm\u0131\u015ft\u0131r.<\/li><li> Koddaki de\u011ferlerden bir veya daha fazlas\u0131n\u0131 ayarlaman\u0131z gerekti\u011finde bunu de\u011fi\u015ftirmek daha kolayd\u0131r.<\/li><\/ul><h2 class=\"wp-block-heading\"> VBA Se\u00e7im Durumu Nedir?<\/h2><p> VBA SELECT CASE, birden \u00e7ok ko\u015fulu test etmeye y\u00f6nelik bir ifadedir. Bu ifadede, bir ko\u015fulu belirtebilir, ard\u0131ndan bu ko\u015ful do\u011fruysa y\u00fcr\u00fct\u00fclecek kodu belirtebilir, ard\u0131ndan ikinci bir ko\u015fulu ve bu ko\u015ful do\u011fruysa y\u00fcr\u00fct\u00fclecek kodu belirtebilirsiniz. Bu \u015fekilde birden \u00e7ok ko\u015fulu ve birden \u00e7ok ifadeyi belirtebilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Vakay\u0131 se\u00e7mek i\u00e7in s\u00f6zdizimi<\/h2><p> A\u015fa\u011f\u0131da bir select case ifadesi yazmak i\u00e7in izlemeniz gereken s\u00f6zdizimi verilmi\u015ftir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Select Case Test Expression Case (Condition to Test) Statement1 [Line of Code to Run if CASE 1 is TRUE] Case (Condition to Test) Statement1 [Line of Code to Run if CASE 2 is TRUE] Case Else Statement [Line of Code to Run if no CASE is TRUE] End Select<\/code><\/pre><p> SELECT CASE&#8217;de s\u00f6zdizimi &#8220;Se\u00e7&#8221; anahtar s\u00f6zc\u00fc\u011f\u00fcyle ba\u015flar ve &#8220;Se\u00e7imi Sonland\u0131r&#8221; ile biter. S\u00f6zdizimini anlamak i\u00e7in onu d\u00f6rt b\u00f6l\u00fcme ay\u0131rmam\u0131z gerekir: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49679\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-la-syntaxe-de-la-casse.png\" sizes=\"auto, \" srcset=\"\" alt=\"b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf se\u00e7me s\u00f6zdizimi\" width=\"1139\" height=\"575\"><\/figure><\/div><ul><li> <strong>\u0130LK<\/strong> k\u0131sm\u0131nda t\u00fcm ko\u015fullar\u0131n test edildi\u011fi &#8220;test ifadesini&#8221; belirtmeniz gerekiyor.<\/li><li> Bundan sonra <strong>\u0130K\u0130NC\u0130<\/strong> b\u00f6l\u00fcmde test edilecek durumu (yani test edilecek durumu) belirtmeniz gerekiyor.<\/li><li> \u015eimdi <strong>\u00dc\u00c7\u00dcNC\u00dc<\/strong> b\u00f6l\u00fcmde, ikinci b\u00f6l\u00fcmdeki ko\u015fulun DO\u011eRU olup olmad\u0131\u011f\u0131n\u0131 test etmeniz gereken ba\u015fka bir durum yazmal\u0131s\u0131n\u0131z.<\/li><li> Son olarak <strong>D\u00d6RD\u00dcNC\u00dc<\/strong> B\u00f6l\u00fcmde yukar\u0131daki durumlar\u0131n her ikisinin de DO\u011eRU olmamas\u0131 durumunda ortaya \u00e7\u0131kmas\u0131 gereken sonucu belirtmelisiniz.<\/li><\/ul><h3 class=\"wp-block-heading\"> Select case ifadesini anlamak i\u00e7in basit bir \u00f6rnek<\/h3><p> SELECT CASE&#8217;in s\u00f6zdizimi a\u00e7\u0131klay\u0131c\u0131d\u0131r ve kod yazarken takip edilmesi olduk\u00e7a kolayd\u0131r. Ama bir \u00f6rnek alal\u0131m ve tamamen anlayal\u0131m. A\u015fa\u011f\u0131da A1 h\u00fccresinin de\u011ferini test etmek i\u00e7in basit bir kodunuz var.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub SelectCaseExample1() Select Case Range(\"A1\").Value Case \"Yes\" MsgBox \"It's a Yes.\" Case \"No\" MsgBox \"It's a No\" Case Else MsgBox \"Can't Say\" End Select End Sub<\/code><\/pre><p> \u015eimdi bu kodu her sat\u0131rda anlayal\u0131m: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49686\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-dinstruction-select-case.png\" sizes=\"auto, \" srcset=\"\" alt=\"se\u00e7me-durumu-ifadesi-\u00f6rne\u011fi\" width=\"574\" height=\"431\"><\/figure><\/div><ul><li> <strong>\u0130LK,<\/strong> ko\u015fulu test etmek i\u00e7in bir ifade olarak kullanmak \u00fczere SELECT CASE anahtar s\u00f6zc\u00fc\u011f\u00fcne ve A1 h\u00fccresine sahipsiniz.<\/li><li> <strong>\u0130K\u0130NC\u0130S\u0130<\/strong> , CASE anahtar s\u00f6zc\u00fc\u011f\u00fcne ve A1 h\u00fccresinden kontrol edilecek ko\u015fula (&#8220;EVET&#8221;) ve durum1&#8217;de belirtilen ko\u015fulun do\u011fru olmas\u0131 durumunda &#8220;Evet&#8221; mesaj\u0131n\u0131 i\u00e7eren bir mesaj kutusu g\u00f6r\u00fcnt\u00fcleyecek koda sahipsiniz.<\/li><li> \u00dc\u00c7\u00dcNC\u00dcS\u00fcnde, yine A1 h\u00fccresinden kontrol edilecek durum anahtar kelimesine ve ko\u015fuluna (&#8220;Hay\u0131r&#8221;) ve ikinci durumda belirtilen ko\u015fulun do\u011fru olmas\u0131 durumunda &#8220;Bu bir hay\u0131r&#8221; mesaj\u0131n\u0131 i\u00e7eren bir mesaj kutusu g\u00f6r\u00fcnt\u00fcleyecek koda sahipsiniz.<\/li><li> <strong>D\u00d6RD\u00dcNC\u00dc<\/strong> , CASE ELSE anahtar s\u00f6zc\u00fc\u011f\u00fcne ve her iki durum da do\u011fru de\u011filse &#8220;S\u00f6yleyemiyorum&#8221; mesaj\u0131n\u0131 i\u00e7eren bir mesaj kutusu g\u00f6r\u00fcnt\u00fclemek i\u00e7in bir kod sat\u0131r\u0131na sahipsiniz.<\/li><li> <strong>BE\u015e\u0130NC\u0130<\/strong> , SELECT CASE ifadesini sonland\u0131rmak i\u00e7in END SELECT anahtar s\u00f6zc\u00fc\u011f\u00fcne sahipsiniz.<\/li><\/ul><p> <strong><em>\u0130lgili:<\/em><\/strong> <a href=\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/\"><em><strong>VBA MESAJ KUTUSU<\/strong><\/em><\/a><\/p><h2 class=\"wp-block-heading\"> \u00d6nemli noktalar<\/h2><ul><li> Birden fazla ko\u015fulu test edebilir ve sonuca g\u00f6re bir kod sat\u0131r\u0131 \u00e7al\u0131\u015ft\u0131rabilir.<\/li><li> Is anahtar s\u00f6zc\u00fc\u011f\u00fcn\u00fc kullanarak bir ko\u015fulu test ederken kar\u015f\u0131la\u015ft\u0131rma i\u015fle\u00e7lerini (=, &gt;, &lt;, &lt;&gt;, &gt;=, &lt;=) kullanabilirsiniz.<\/li><li> Ayn\u0131 durumda birden fazla ko\u015fulu test etmek i\u00e7in virg\u00fcl kullanabilirsiniz.<\/li><li> Tek bir durumda bir ko\u015fulu test ederken bir dizi say\u0131 da kullanabilirsiniz.<\/li><li> Bir ko\u015ful kar\u015f\u0131land\u0131\u011f\u0131nda VBA, ifadenin geri kalan durumlar\u0131n\u0131 test etmek i\u00e7in durur.<\/li><li> Ko\u015fullardan hi\u00e7biri kar\u015f\u0131lanmad\u0131\u011f\u0131nda bir kod sat\u0131r\u0131n\u0131 \u00e7al\u0131\u015ft\u0131rmak i\u00e7in sonuna bir case else b\u00f6l\u00fcm\u00fc de ekleyebilirsiniz.<\/li><li> CASE END ifadesini kullanarak atlayabilirsiniz.<\/li><\/ul><h2 class=\"wp-block-heading\"> Kullan\u0131lacak daha fazla \u00f6rnek B\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf se\u00e7<\/h2><p> SELECT CASE&#8217;i farkl\u0131 \u015fekillerde kullanman\u0131n zaman\u0131 geldi; i\u015fte \u00f6\u011frenebilece\u011finiz yararl\u0131 ve temel \u00f6rneklerden baz\u0131lar\u0131.<\/p><p> <strong>100 Excel Makro \u00d6rne\u011fi<\/strong><\/p><h3 class=\"wp-block-heading\"> 1. Say\u0131lar\u0131n oldu\u011fu durumu se\u00e7in<\/h3><p> SELECT CASE ifadesi i\u00e7in VBA kodunu yazarken de\u011ferleri kar\u015f\u0131la\u015ft\u0131rmak i\u00e7in operat\u00f6rleri kullanabilirsiniz. Art\u0131k a\u015fa\u011f\u0131daki kodda ko\u015fullar\u0131 test etmek i\u00e7in &gt;, &lt; ve = operat\u00f6rleri var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50298\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-cas-choisis-avec-des-nombres.png\" sizes=\"auto, \" srcset=\"\" alt=\"say\u0131larla-b\u00fcy\u00fck-k\u00fc\u00e7\u00fck harf se\u00e7\" width=\"451\" height=\"278\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub SelectCaseExample1() Select Case Range(\"A1\").Value Case Is &gt;= 45 MsgBox \"Pass\" Case Is &lt; 45 MsgBox \"Fail\" End Select End Sub<\/code><\/pre><ul><li> Bu ifadenin ilk durumu, A1 h\u00fccresinin de\u011ferinin 45&#8217;ten b\u00fcy\u00fck veya e\u015fit olup olmad\u0131\u011f\u0131n\u0131 kontrol eder ve &#8220;Ge\u00e7ti&#8221; mesaj\u0131n\u0131 i\u00e7eren bir mesaj kutusu d\u00f6nd\u00fcr\u00fcr.<\/li><li> \u0130fadenin ikinci durumu ise A1 h\u00fccresinin de\u011ferinin 45&#8217;ten k\u00fc\u00e7\u00fck olup olmad\u0131\u011f\u0131n\u0131 kontrol eder ve &#8220;Ba\u015far\u0131s\u0131z&#8221; mesaj\u0131n\u0131 i\u00e7eren bir mesaj kutusu d\u00f6nd\u00fcr\u00fcr.<\/li><\/ul><h3 class=\"wp-block-heading\"> 2. Say\u0131 aral\u0131\u011f\u0131 i\u00e7eren durumu se\u00e7in<\/h3><p> Ko\u015fulu test etmek i\u00e7in bir dizi say\u0131 da kullanabilirsiniz. A\u015fa\u011f\u0131daki kodda, her durumda test edilecek bir dizi say\u0131 i\u00e7eren bir ko\u015fulunuz var.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub SelectCaseExample2() Select Case Range(\u201cA1\u201d).Value Case 45 To 100 MsgBox \u201cPass\u201d Case 0 To 44 MsgBox \u201cFail\u201d Case Else MsgBox \u201cOut of Range\u201d End Select End Sub<\/code><\/pre><ul><li> \u0130fadenin ilk durumu, 45 ile 100 aras\u0131ndaki say\u0131 aral\u0131\u011f\u0131n\u0131 kullanarak A1 h\u00fccresindeki say\u0131y\u0131 kontrol eder ve de\u011fer bu aral\u0131\u011f\u0131n alt\u0131na d\u00fc\u015ferse &#8220;Ge\u00e7ti&#8221; sonucunu d\u00f6nd\u00fcr\u00fcr.<\/li><li> \u0130kinci ifade, A1 h\u00fccresindeki de\u011ferle test etmek i\u00e7in 0 ile 44 aras\u0131nda bir aral\u0131\u011fa sahiptir ve de\u011fer bu aral\u0131\u011f\u0131n alt\u0131na d\u00fc\u015ferse &#8220;Ba\u015far\u0131s\u0131z&#8221; sonucunu d\u00f6nd\u00fcr\u00fcr.<\/li><li> \u00dc\u00e7\u00fcnc\u00fc ifade ise, birinci ve ikinci durum yanl\u0131\u015fsa &#8220;Aral\u0131k D\u0131\u015f\u0131&#8221; mesaj\u0131n\u0131 i\u00e7eren bir mesaj kutusu g\u00f6r\u00fcnt\u00fcleyen case else&#8217;dir.<\/li><\/ul><h3 class=\"wp-block-heading\"> 3. \u0130ki nokta \u00fcst \u00fcste operat\u00f6r\u00fcn\u00fc kullanma<\/h3><p> SELECT CASE i\u00e7in kod yazarken, b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfin tamam\u0131n\u0131 tek bir sat\u0131ra yazmak i\u00e7in iki nokta \u00fcst \u00fcste operat\u00f6rlerini kullanabilirsiniz.<\/p><p> A\u015fa\u011f\u0131daki kodda sat\u0131r b\u00fcy\u00fck harfle ba\u015flar, ard\u0131ndan test edilecek ko\u015ful, ard\u0131ndan iki nokta \u00fcst \u00fcste gelir ve bu durumda y\u00fcr\u00fct\u00fclecek ifade do\u011frudur. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50299\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-en-utilisant-loperateur-deux-points.png\" sizes=\"auto, \" srcset=\"\" alt=\"iki nokta \u00fcst \u00fcste operat\u00f6r\u00fcn\u00fc kullanma\" width=\"439\" height=\"288\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub SelectCaseExample3() Select Case Range(\u201cA1\u201d).Value Case 45 To 100: MsgBox \u201cPass\u201d Case 0 To 44: MsgBox \u201cFail\u201d Case Else: MsgBox \u201cOut of Range\u201d End Select End Sub<\/code><\/pre><h3 class=\"wp-block-heading\"> 4. Select Case&#8217;i Birden \u00c7ok Ko\u015fulla Kullan\u0131n<\/h3><p> T\u0131pk\u0131 bir vaka i\u00e7in aral\u0131k ayarlamaya benzer \u015fekilde, durumu test etmek i\u00e7in birden fazla de\u011fer de belirtebilirsiniz. A\u015fa\u011f\u0131daki kodda her durumda test edilecek \u00fc\u00e7 say\u0131 vard\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50300\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-selectionner-le-cas-avec-plusieurs-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00e7oklu-de\u011ferli-b\u00fcy\u00fck-k\u00fc\u00e7\u00fck harf se\u00e7\" width=\"376\" height=\"308\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub SelectCaseExample() Select Case Range(\"A1\").Value Case 1, 3, 5 MsgBox \"Yes\" Case 2, 4, 6 MsgBox \"No\" Case Else MsgBox \"Out of range\" End Select End Sub<\/code><\/pre><ul><li> Bu kodun ilk durumu, h\u00fccre de\u011ferinin 1, 3 veya 5 olup olmad\u0131\u011f\u0131n\u0131 test edecek ve bir mesaj kutusunda &#8220;Evet&#8221; sonucunu verecektir.<\/li><li> Bu kodun ikinci durumu ise A1 h\u00fccresinin de\u011ferinin 2, 4 veya 6 olup olmad\u0131\u011f\u0131n\u0131 test edecektir.<\/li><\/ul><h3 class=\"wp-block-heading\"> 5. \u00d6zel Bir \u0130\u015flevde Select Case&#8217;i Kullanma<\/h3><p> Bir <a href=\"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/\"><strong>VBA i\u015flevi<\/strong><\/a> i\u00e7in kod yazarken SELECT CASE&#8217;i de kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50301\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-selectionner-le-cas-dans-la-fonction-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00f6zel-i\u015flevde-b\u00fcy\u00fck-k\u00fc\u00e7\u00fck harf se\u00e7\" width=\"433\" height=\"405\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Function udfGrade(student_marks As Integer) Dim myGrade As String Select Case student_marks Case Is &lt; 40: myGrade = \u201cBad\u201d Case 41 To 50: myGrade = \u201cAverage\u201d Case 51 To 60: myGrade = \u201cGood\u201d Case 61 To 80: myGrade = \u201cVery Good\u201d Case 81 To 100: myGrade = \u201cExcellent\u201d End Select udfGrade = myGrade End Function<\/code><\/pre><p> Yukar\u0131daki fonksiyonda, bir h\u00fccrede \u00f6\u011frencilerin puanlar\u0131n\u0131 kontrol etmek i\u00e7in be\u015f kutu bulunmaktad\u0131r. 5 durumun tamam\u0131 bir say\u0131 aral\u0131\u011f\u0131 kullan\u0131r ve ifadede tan\u0131mlanan de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> 6. \u0130\u00e7 i\u00e7e ko\u015fullardan Select Case&#8217;i kullanma<\/h3><p> Ayr\u0131ca i\u00e7 i\u00e7e ge\u00e7mi\u015f bir ko\u015ful ifadesi de olu\u015fturabilirsiniz. S\u00f6ylemeye \u00e7al\u0131\u015ft\u0131\u011f\u0131m \u015fey, se\u00e7ilen durumla birden fazla ko\u015fulu test etmek i\u00e7in kod yazabilece\u011finizdir.<\/p><p> \u0130ki farkl\u0131 h\u00fccrenin de\u011ferlerine g\u00f6re ko\u015fullar\u0131 test edebilecek bir kod yazmak istedi\u011finizi hayal edin. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub SelectCaseStatement() Select Case Range(\"A2\") Case \"Boy\" Select Case Range(\"B2\") Case \"Commerce\": MsgBox \"Boy (Commerce)\" Case \"Science\": MsgBox \"Boy (Science)\" End Select Case \"Girl\" Select Case Range(\"B2\") Case \"Commerce\": MsgBox \"Girl (Commerce)\" Case \"Science\": MsgBox \"Girl (Science)\" End Select End Select End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50302\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-selectionner-le-cas-parmi-les-conditions-imbriquees.png\" sizes=\"auto, \" srcset=\"\" alt=\"i\u00e7 i\u00e7e-ko\u015fullardan-se\u00e7im durumu\" width=\"478\" height=\"341\"><\/figure><\/div><p> Yukar\u0131daki kodda \u00fc\u00e7 durum se\u00e7me ifadeniz var. A2 h\u00fccresinin de\u011ferini &#8220;Erkek&#8221; veya &#8220;K\u0131z&#8221; olup olmad\u0131\u011f\u0131n\u0131 kontrol eden bir ana ifade vard\u0131r.<\/p><p> Ve sonra, sonuca g\u00f6re iki talimat daha y\u00fcr\u00fct\u00fcl\u00fcr ve B2 h\u00fccresinin Ticaret mi yoksa Bilim mi oldu\u011fu de\u011feri kontrol edilir.<\/p><h2 class=\"wp-block-heading\"> CHOOSE CASE vs. <a href=\"https:\/\/exceladvisor.org\/tr\/eger-2\/\">IF THE ELSE \u0130fadesi<\/a><\/h2><ul><li> Birden \u00e7ok ko\u015fulu test etmek istedi\u011finizde IF-THEN yerine SELECT CASE kullanarak kod yazmak kolayd\u0131r.<\/li><li> IF-THEN ile kar\u015f\u0131la\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda SELECT CASE deyimini d\u00fczenlemek ve de\u011fi\u015fiklik yapmak bile kolayd\u0131r.<\/li><\/ul><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\/donguler\/\">VBA D\u00f6ng\u00fcleri (Ba\u015flang\u0131\u00e7tan \u0130leri Seviyeye)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/\">Excel VBA Do While D\u00f6ng\u00fcs\u00fc ve (Do Loop While) \u2013 Bir K\u0131lavuz<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dongu-yapraklari\/\">Excel&#8217;de VBA&#8217;y\u0131 kullanarak t\u00fcm sayfalar aras\u0131nda ge\u00e7i\u015f yap\u0131n<\/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\/aralik-boyunca-dongu\/\">VBA (S\u00fctunlar, Sat\u0131r ve Kullan\u0131lm\u0131\u015fRange) kullanarak bir aral\u0131kta d\u00f6ng\u00fc yap\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/\">VBA FOR LOOP (Sonraki \u0130\u00e7in, Her Biri \u0130\u00e7in)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/1e-git\/\">GoTo VBA bildirimi<\/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-2062","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&#039;da SELECT CASE deyimi nas\u0131l kullan\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"SELECT CASE&#039;de bir ko\u015ful belirtebilir, ard\u0131ndan bu ko\u015fulun do\u011fru olmas\u0131 durumunda y\u00fcr\u00fct\u00fclecek bir kod belirtebilir ve ard\u0131ndan bir...\" \/>\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\/davayi-sec\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA&#039;da SELECT CASE deyimi nas\u0131l kullan\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"SELECT CASE&#039;de bir ko\u015ful belirtebilir, ard\u0131ndan bu ko\u015fulun do\u011fru olmas\u0131 durumunda y\u00fcr\u00fct\u00fclecek bir kod belirtebilir ve ard\u0131ndan bir...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/davayi-sec\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:07:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-la-syntaxe-de-la-casse.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=\"8 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/davayi-sec\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/davayi-sec\/\",\"name\":\"VBA&#39;da SELECT CASE deyimi nas\u0131l kullan\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/davayi-sec\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/davayi-sec\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-la-syntaxe-de-la-casse.png\",\"datePublished\":\"2023-10-21T12:28:37+00:00\",\"dateModified\":\"2023-12-10T06:07:54+00:00\",\"description\":\"SELECT CASE&#39;de bir ko\u015ful belirtebilir, ard\u0131ndan bu ko\u015fulun do\u011fru olmas\u0131 durumunda y\u00fcr\u00fct\u00fclecek bir kod belirtebilir ve ard\u0131ndan bir...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/davayi-sec\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/davayi-sec\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/davayi-sec\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-la-syntaxe-de-la-casse.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-la-syntaxe-de-la-casse.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/davayi-sec\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba&#39;da select case deyimi 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":"VBA&#39;da SELECT CASE deyimi nas\u0131l kullan\u0131l\u0131r?","description":"SELECT CASE&#39;de bir ko\u015ful belirtebilir, ard\u0131ndan bu ko\u015fulun do\u011fru olmas\u0131 durumunda y\u00fcr\u00fct\u00fclecek bir kod belirtebilir ve ard\u0131ndan bir...","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\/davayi-sec\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA&#39;da SELECT CASE deyimi nas\u0131l kullan\u0131l\u0131r?","og_description":"SELECT CASE&#39;de bir ko\u015ful belirtebilir, ard\u0131ndan bu ko\u015fulun do\u011fru olmas\u0131 durumunda y\u00fcr\u00fct\u00fclecek bir kod belirtebilir ve ard\u0131ndan bir...","og_url":"https:\/\/exceladvisor.org\/tr\/davayi-sec\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:07:54+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-la-syntaxe-de-la-casse.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"8 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/davayi-sec\/","url":"https:\/\/exceladvisor.org\/tr\/davayi-sec\/","name":"VBA&#39;da SELECT CASE deyimi nas\u0131l kullan\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/davayi-sec\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/davayi-sec\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-la-syntaxe-de-la-casse.png","datePublished":"2023-10-21T12:28:37+00:00","dateModified":"2023-12-10T06:07:54+00:00","description":"SELECT CASE&#39;de bir ko\u015ful belirtebilir, ard\u0131ndan bu ko\u015fulun do\u011fru olmas\u0131 durumunda y\u00fcr\u00fct\u00fclecek bir kod belirtebilir ve ard\u0131ndan bir...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/davayi-sec\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/davayi-sec\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/davayi-sec\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-la-syntaxe-de-la-casse.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-la-syntaxe-de-la-casse.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/davayi-sec\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba&#39;da select case deyimi 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\/2062","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=2062"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2062\/revisions"}],"predecessor-version":[{"id":2958,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2062\/revisions\/2958"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}