{"id":2130,"date":"2023-09-30T03:47:06","date_gmt":"2023-09-30T03:47:06","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/"},"modified":"2023-12-10T06:07:46","modified_gmt":"2023-12-10T06:07:46","slug":"aksi-takdirde","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/","title":{"rendered":"Vba&#39;da if not nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3724079774\"><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 <a href=\"https:\/\/exceladvisor.org\/tr\/eger-2\/\">IF ifadesini<\/a> kulland\u0131\u011f\u0131n\u0131zda, test etmek i\u00e7in belirtti\u011finiz ko\u015fulun DO\u011eRU olmas\u0131 durumunda bir kod sat\u0131r\u0131 \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r. Ancak NOT operat\u00f6r\u00fcn\u00fc IF ile birlikte kulland\u0131\u011f\u0131n\u0131zda belirtti\u011finiz ko\u015fulun DO\u011eRU olup olmad\u0131\u011f\u0131n\u0131 kontrol eder ve buna g\u00f6re kodu \u00e7al\u0131\u015ft\u0131r\u0131r.<\/p><p> <strong>Bu, DO\u011eRU&#8217;dan YANLI\u015e&#8217;a ve YANLI\u015e&#8217;tan DO\u011eRU&#8217;ya z\u0131t IF ifadesini yapmak gibidir.<\/strong><\/p><p> Diyelim ki A &lt; B olup olmad\u0131\u011f\u0131n\u0131 test etmek istiyorsunuz ve bu ko\u015ful do\u011fruysa IF, TRUE sonucunu d\u00f6nd\u00fcrecektir, de\u011fil mi? Ancak IF NOT A &lt; B kulland\u0131\u011f\u0131n\u0131zda FALSE de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/p><p class=\"qt-tip\"> <strong>Not:<\/strong> NOT mant\u0131ksal bir operat\u00f6rd\u00fcr.<\/p><h2 class=\"wp-block-heading\"> <strong>IF NOT NOT VBA kullanma \u00f6rnekleri<\/strong><\/h2><p> Burada bunu anlamak i\u00e7in basit bir \u00f6rnek g\u00f6rece\u011fiz: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57664\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-if-de\u011filse-kullan\u0131lacak \u00f6rnek\" width=\"698\" height=\"493\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() Dim A As Range, B As Range Set A = Range(\"A1\") Set B = Range(\"B1\") If Not A &lt; B Then MsgBox \"A is not greater than B.\" Else MsgBox \"B is not greater than A.\" End If End Sub<\/code><\/pre><p> Yukar\u0131daki kodda, B&#8217;nin A&#8217;dan b\u00fcy\u00fck olup olmad\u0131\u011f\u0131n\u0131 test etmek i\u00e7in NOT operat\u00f6r\u00fcn\u00fc kulland\u0131n\u0131z.<\/p><p> Ko\u015ful ifadesine bakt\u0131\u011f\u0131n\u0131zda test edilecek as\u0131l ko\u015fulun B&#8217;nin A&#8217;dan b\u00fcy\u00fck olmas\u0131 oldu\u011funu ancak NOT ifadesini kulland\u0131\u011f\u0131m\u0131z gibi ko\u015ful TRUE ise FALSE d\u00f6nd\u00fcrece\u011fini anlayabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57662\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utilise-loperateur-not.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"524\" height=\"285\"><\/figure><\/div><p> \u0130\u015fte bunu anlamak i\u00e7in kullanabilece\u011finiz ba\u015fka bir \u00f6rnek.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() If Not ActiveSheet.Name = Sheets(\"Sheet1\").Name Then Sheets(\"Sheet1\").Activate End If End Sub<\/code><\/pre><p> \u015eimdi bu kodda aktif sayfan\u0131n Sheet1 olup olmad\u0131\u011f\u0131n\u0131 g\u00f6rmek i\u00e7in <strong>NOT ile IF komutunu<\/strong> kulland\u0131n\u0131z, e\u011fer de\u011filse belirtti\u011fimiz kod sat\u0131r\u0131 <a href=\"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/\">Sheet1&#8217;i aktif hale getirecek<\/a> .<\/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\"> \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\/eger-disari-cik\/\">VBA \u00c7\u0131k\u0131\u015f\u0131 IF<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-2\/\">VBA IF (IF o zaman de\u011filse)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-ve\/\">VBA IF ve<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-veya\/\">VBA IF VEYA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yuva-eger\/\">VBA i\u00e7 i\u00e7e IF<\/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-2130","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>Excel&#039;de VBA&#039;da IF NOT nas\u0131l kullan\u0131l\u0131r? (E\u011fitim 2023)<\/title>\n<meta name=\"description\" content=\"Bu, DO\u011eRU&#039;dan YANLI\u015e&#039;a ve YANLI\u015e&#039;tan DO\u011eRU&#039;ya z\u0131t IF ifadesini yapmak gibidir. Diyelim ki A &lt; B olup olmad\u0131\u011f\u0131n\u0131 test etmek istiyorsunuz ve bu ko\u015ful...\" \/>\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\/aksi-takdirde\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de VBA&#039;da IF NOT nas\u0131l kullan\u0131l\u0131r? (E\u011fitim 2023)\" \/>\n<meta property=\"og:description\" content=\"Bu, DO\u011eRU&#039;dan YANLI\u015e&#039;a ve YANLI\u015e&#039;tan DO\u011eRU&#039;ya z\u0131t IF ifadesini yapmak gibidir. Diyelim ki A &lt; B olup olmad\u0131\u011f\u0131n\u0131 test etmek istiyorsunuz ve bu ko\u015ful...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:07:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.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\/aksi-takdirde\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/\",\"name\":\"Excel&#39;de VBA&#39;da IF NOT nas\u0131l kullan\u0131l\u0131r? (E\u011fitim 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png\",\"datePublished\":\"2023-09-30T03:47:06+00:00\",\"dateModified\":\"2023-12-10T06:07:46+00:00\",\"description\":\"Bu, DO\u011eRU&#39;dan YANLI\u015e&#39;a ve YANLI\u015e&#39;tan DO\u011eRU&#39;ya z\u0131t IF ifadesini yapmak gibidir. Diyelim ki A &lt; B olup olmad\u0131\u011f\u0131n\u0131 test etmek istiyorsunuz ve bu ko\u015ful...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba&#39;da if not 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":"Excel&#39;de VBA&#39;da IF NOT nas\u0131l kullan\u0131l\u0131r? (E\u011fitim 2023)","description":"Bu, DO\u011eRU&#39;dan YANLI\u015e&#39;a ve YANLI\u015e&#39;tan DO\u011eRU&#39;ya z\u0131t IF ifadesini yapmak gibidir. Diyelim ki A &lt; B olup olmad\u0131\u011f\u0131n\u0131 test etmek istiyorsunuz ve bu ko\u015ful...","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\/aksi-takdirde\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de VBA&#39;da IF NOT nas\u0131l kullan\u0131l\u0131r? (E\u011fitim 2023)","og_description":"Bu, DO\u011eRU&#39;dan YANLI\u015e&#39;a ve YANLI\u015e&#39;tan DO\u011eRU&#39;ya z\u0131t IF ifadesini yapmak gibidir. Diyelim ki A &lt; B olup olmad\u0131\u011f\u0131n\u0131 test etmek istiyorsunuz ve bu ko\u015ful...","og_url":"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:07:46+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.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\/aksi-takdirde\/","url":"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/","name":"Excel&#39;de VBA&#39;da IF NOT nas\u0131l kullan\u0131l\u0131r? (E\u011fitim 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png","datePublished":"2023-09-30T03:47:06+00:00","dateModified":"2023-12-10T06:07:46+00:00","description":"Bu, DO\u011eRU&#39;dan YANLI\u015e&#39;a ve YANLI\u015e&#39;tan DO\u011eRU&#39;ya z\u0131t IF ifadesini yapmak gibidir. Diyelim ki A &lt; B olup olmad\u0131\u011f\u0131n\u0131 test etmek istiyorsunuz ve bu ko\u015ful...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/aksi-takdirde\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba&#39;da if not 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\/2130","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=2130"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2130\/revisions"}],"predecessor-version":[{"id":2950,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2130\/revisions\/2950"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}