{"id":3621,"date":"2023-09-30T04:50:34","date_gmt":"2023-09-30T04:50:34","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/ich-fur\/"},"modified":"2023-12-03T13:05:00","modified_gmt":"2023-12-03T13:05:00","slug":"ich-fur","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/ich-fur\/","title":{"rendered":"Wie verwende ich if mit or in vba?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-2099588155\"><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>Sie k\u00f6nnen den <strong>OR-<\/strong> Operator mit der <a href=\"https:\/\/exceladvisor.org\/de\/wenn-2\/\">VBA-IF-Anweisung<\/a> verwenden, um mehrere Bedingungen zu testen. Wenn Sie es verwenden, k\u00f6nnen Sie zwei oder mehr Bedingungen gleichzeitig testen und <strong>true zur\u00fcckgeben, wenn eine dieser Bedingungen wahr ist<\/strong> . Wenn jedoch alle Bedingungen falsch sind, wird im Ergebnis nur \u201efalsch\u201c zur\u00fcckgegeben.<\/p><h2 class=\"wp-block-heading\"> Verwendung von OR mit IF<\/h2><ol type=\"1\"><li> Beginnen Sie zun\u00e4chst die IF-Anweisung mit dem Schl\u00fcsselwort \u201eIF\u201c.<\/li><li> Geben Sie anschlie\u00dfend die erste Bedingung an, die Sie testen m\u00f6chten.<\/li><li> Verwenden Sie dann das Schl\u00fcsselwort OR, um die zweite Bedingung anzugeben.<\/li><li> Geben Sie am Ende die zweite Bedingung an, die Sie testen m\u00f6chten. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57529\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-wenn-oder-Bedingung\" width=\"728\" height=\"142\"><\/figure><\/div><p> Schauen wir uns zum besseren Verst\u00e4ndnis ein Beispiel an. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() 'two conditions to test using OR If 1 = 1 Or 2 &lt; 1 Then MsgBox \"One of the conditions is true.\" Else MsgBox \"None of the conditions are true.\" End If End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57530\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-specifie-deux-conditions.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"581\" height=\"488\"><\/figure><\/div><p> Wenn Sie sich das obige Beispiel ansehen, haben wir zwei Bedingungen angegeben, eine wenn (1 = 1) und die zweite ist (2 &lt; 1), und hier ist nur die erste Bedingung wahr, und selbst wenn sie die von uns angegebene Codezeile ausgef\u00fchrt hat angegeben, wenn das Ergebnis wahr ist. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57531\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-la-premiere-condition-est-vraie.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"242\" height=\"192\"><\/figure><\/div><p> Nun wollen wir sehen, ob beide Bedingungen falsch sind. Lassen Sie mich hier einen anderen Code verwenden. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() 'two conditions to test using OR If 1 = 2 Or 2 &lt; 1 Then MsgBox \"One of the conditions is true.\" Else MsgBox \"None of the conditions are true.\" End If End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57532\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-les-deux-conditions-sont-fausses.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"546\" height=\"475\"><\/figure><\/div><p> Im obigen Code sind beide Bedingungen falsch, und wenn Sie <a href=\"https:\/\/exceladvisor.org\/de\/ein-makro-ausfuhren-2\/\">diesen Code ausf\u00fchren<\/a> , f\u00fchrt er die von uns angegebene Codezeile aus, wenn das Ergebnis falsch ist. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57533\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-specifie-si-le-resultat-est-faux.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"233\" height=\"172\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Mehrere Bedingungen mit WENN ODER<\/h2><p> Ebenso k\u00f6nnen Sie auch mehr als zwei Bedingungen gleichzeitig testen. Lassen Sie uns das obige Beispiel fortsetzen und die dritte Bedingung hinzuf\u00fcgen. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() 'three conditions to test using OR If 1 = 1 And 2 &gt; 1 And 1 - 1 = 0 Then MsgBox \"one of the conditions is true.\" Else MsgBox \"none of the conditions are true.\" End If End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57534\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-conditions-multiples-avec-if-ou.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"555\" height=\"472\"><\/figure><\/div><p> Wir m\u00fcssen jetzt drei Bedingungen testen und haben das OR nach der zweiten Bedingung verwendet, um die dritte Bedingung anzugeben. Wie Sie oben erfahren haben, muss bei der Verwendung von OR eine der Bedingungen wahr sein, damit sie im Ergebnis wahr wird. Wenn Sie diesen Code ausf\u00fchren, wird die Codezeile ausgef\u00fchrt, die wir f\u00fcr true angegeben haben. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57535\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-specifie-pour-le-vrai-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"225\" height=\"178\"><\/figure><\/div><p> Und wenn alle Bedingungen falsch sind, wie Sie es im folgenden Code getan haben, wird false zur\u00fcckgegeben. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() 'three conditions to test using OR If 1 &lt; 1 And 2 &lt; 1 And 1 + 1 = 0 Then MsgBox \"one of the conditions is true.\" Else MsgBox \"none of the conditions are true.\" End If End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57536\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-toutes-les-conditions-sont-fausses.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"247\" height=\"182\"><\/figure><\/div><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\/de\/vba\/\">Was ist VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Verwandte Tutorials <\/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\/de\/geh-raus-wenn\/\">VBA Exit IF<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/wenn-2\/\">VBA IF (WENN dann sonst)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/wenn-und\/\">VBA IF und<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/ansonsten\/\">VBA WENN NICHT<\/a> ]<\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/nest-wenn\/\">VBA verschachteltes 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-3621","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>Wie verwende ich IF mit OR in VBA Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Mit VBA OR k\u00f6nnen Sie mehrere Bedingungen gleichzeitig testen. Es gibt \u201etrue\u201c zur\u00fcck, wenn eine dieser Bedingungen wahr ist.\" \/>\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\/de\/ich-fur\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie verwende ich IF mit OR in VBA Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Mit VBA OR k\u00f6nnen Sie mehrere Bedingungen gleichzeitig testen. Es gibt \u201etrue\u201c zur\u00fcck, wenn eine dieser Bedingungen wahr ist.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/ich-fur\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:05:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"2\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/ich-fur\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/ich-fur\/\",\"name\":\"Wie verwende ich IF mit OR in VBA Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/ich-fur\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/ich-fur\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png\",\"datePublished\":\"2023-09-30T04:50:34+00:00\",\"dateModified\":\"2023-12-03T13:05:00+00:00\",\"description\":\"Mit VBA OR k\u00f6nnen Sie mehrere Bedingungen gleichzeitig testen. Es gibt \u201etrue\u201c zur\u00fcck, wenn eine dieser Bedingungen wahr ist.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/ich-fur\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/ich-fur\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/ich-fur\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/ich-fur\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie verwende ich if mit or in vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wie verwende ich IF mit OR in VBA Excel? (Tutorial 2023)","description":"Mit VBA OR k\u00f6nnen Sie mehrere Bedingungen gleichzeitig testen. Es gibt \u201etrue\u201c zur\u00fcck, wenn eine dieser Bedingungen wahr ist.","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\/de\/ich-fur\/","og_locale":"de_DE","og_type":"article","og_title":"Wie verwende ich IF mit OR in VBA Excel? (Tutorial 2023)","og_description":"Mit VBA OR k\u00f6nnen Sie mehrere Bedingungen gleichzeitig testen. Es gibt \u201etrue\u201c zur\u00fcck, wenn eine dieser Bedingungen wahr ist.","og_url":"https:\/\/exceladvisor.org\/de\/ich-fur\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:05:00+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"2\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/ich-fur\/","url":"https:\/\/exceladvisor.org\/de\/ich-fur\/","name":"Wie verwende ich IF mit OR in VBA Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/ich-fur\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/ich-fur\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png","datePublished":"2023-09-30T04:50:34+00:00","dateModified":"2023-12-03T13:05:00+00:00","description":"Mit VBA OR k\u00f6nnen Sie mehrere Bedingungen gleichzeitig testen. Es gibt \u201etrue\u201c zur\u00fcck, wenn eine dieser Bedingungen wahr ist.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/ich-fur\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/ich-fur\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/ich-fur\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-si-ou-condition.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/ich-fur\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie verwende ich if mit or in vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3621"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3621\/revisions"}],"predecessor-version":[{"id":4368,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3621\/revisions\/4368"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}