{"id":2128,"date":"2023-09-30T04:50:34","date_gmt":"2023-09-30T04:50:34","guid":{"rendered":"https:\/\/exceladvisor.org\/it\/io-per\/"},"modified":"2023-12-10T06:26:26","modified_gmt":"2023-12-10T06:26:26","slug":"io-per","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/it\/io-per\/","title":{"rendered":"Come utilizzare if con or in vba?"},"content":{"rendered":"<div class=\"excel-prima-del-contenuto\" id=\"excel-2862813728\"><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>\u00c8 possibile utilizzare l&#8217;operatore <strong>OR<\/strong> con l&#8217; <a href=\"https:\/\/exceladvisor.org\/it\/se-2\/\">istruzione IF VBA<\/a> per testare pi\u00f9 condizioni. Quando lo usi, ti consente di testare due o pi\u00f9 condizioni contemporaneamente e <strong>restituisce true se una qualsiasi di queste condizioni \u00e8 vera<\/strong> . Ma se tutte le condizioni sono false, solo il risultato restituisce false.<\/p><h2 class=\"wp-block-heading\"> Utilizzando OR con IF<\/h2><ol type=\"1\"><li> Innanzitutto, inizia l&#8217;istruzione IF con la parola chiave &#8220;IF&#8221;.<\/li><li> Successivamente, specifica la prima condizione che desideri testare.<\/li><li> Quindi utilizzare la parola chiave OR per specificare la seconda condizione.<\/li><li> Alla fine, specifica la seconda condizione che desideri testare. <\/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-se-o-condizione\" width=\"728\" height=\"142\"><\/figure><\/div><p> Per capire meglio, vediamo un esempio. <\/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> Se guardi l&#8217;esempio sopra, abbiamo specificato due condizioni una se (1 = 1) e la seconda \u00e8 (2 &lt; 1), e qui solo la prima condizione \u00e8 vera, e anche se ha eseguito la riga di codice che abbiamo specificato se il risultato \u00e8 vero. <\/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> Ora vediamo se entrambe le condizioni sono false, lasciami usare un codice diverso qui. <\/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> Nel codice precedente, entrambe le condizioni sono false e quando <a href=\"https:\/\/exceladvisor.org\/it\/eseguire-una-macro-2\/\">esegui questo codice<\/a> , viene eseguita la riga di codice specificata se il risultato \u00e8 falso. <\/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\"> Condizioni multiple con IF OR<\/h2><p> Allo stesso modo, puoi anche testare pi\u00f9 di due condizioni contemporaneamente. Continuiamo l&#8217;esempio sopra e aggiungiamo la terza condizione. <\/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> Ora abbiamo tre condizioni da testare e abbiamo utilizzato l&#8217;OR dopo la seconda condizione per specificare la terza condizione. Come hai imparato in precedenza, quando usi OR, una delle condizioni deve essere vera affinch\u00e9 diventi vera nel risultato. Quando esegui questo codice, viene eseguita la riga di codice che abbiamo specificato per true. <\/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> E se tutte le condizioni sono false, come nel codice seguente, restituisce false. <\/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\/it\/vba\/\">Cos&#8217;\u00e8 VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial correlati <\/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\/it\/esci-se\/\">VBA Esci SE<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/se-2\/\">VBA IF (SE poi altrimenti)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/se-e\/\">VBA SE e<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/altrimenti\/\">VBA SE NON<\/a> ]<\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/nido-se\/\">VBA nidificato 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-2128","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>Come utilizzare SE con OR in VBA Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Con VBA OR puoi testare pi\u00f9 condizioni contemporaneamente. Restituisce vero se una qualsiasi di queste condizioni \u00e8 vera.\" \/>\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\/it\/io-per\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Come utilizzare SE con OR in VBA Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Con VBA OR puoi testare pi\u00f9 condizioni contemporaneamente. Restituisce vero se una qualsiasi di queste condizioni \u00e8 vera.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/it\/io-per\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:26:26+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=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuti\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/it\/io-per\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/io-per\/\",\"name\":\"Come utilizzare SE con OR in VBA Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/io-per\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/io-per\/#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-10T06:26:26+00:00\",\"description\":\"Con VBA OR puoi testare pi\u00f9 condizioni contemporaneamente. Restituisce vero se una qualsiasi di queste condizioni \u00e8 vera.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/io-per\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/it\/io-per\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/io-per\/#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\/it\/io-per\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceladvisor.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Come utilizzare if con or in vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"name\":\"Excel Advisor\",\"description\":\"Tips, Tricks, and Time-Saving Hacks\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/it\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Come utilizzare SE con OR in VBA Excel? (Tutorial 2023)","description":"Con VBA OR puoi testare pi\u00f9 condizioni contemporaneamente. Restituisce vero se una qualsiasi di queste condizioni \u00e8 vera.","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\/it\/io-per\/","og_locale":"it_IT","og_type":"article","og_title":"Come utilizzare SE con OR in VBA Excel? (Tutorial 2023)","og_description":"Con VBA OR puoi testare pi\u00f9 condizioni contemporaneamente. Restituisce vero se una qualsiasi di queste condizioni \u00e8 vera.","og_url":"https:\/\/exceladvisor.org\/it\/io-per\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:26:26+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":{"Tempo di lettura stimato":"2 minuti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/it\/io-per\/","url":"https:\/\/exceladvisor.org\/it\/io-per\/","name":"Come utilizzare SE con OR in VBA Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/it\/io-per\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/io-per\/#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-10T06:26:26+00:00","description":"Con VBA OR puoi testare pi\u00f9 condizioni contemporaneamente. Restituisce vero se una qualsiasi di queste condizioni \u00e8 vera.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/it\/io-per\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/it\/io-per\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/io-per\/#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\/it\/io-per\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceladvisor.org\/it\/"},{"@type":"ListItem","position":2,"name":"Come utilizzare if con or in vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/it\/#website","url":"https:\/\/exceladvisor.org\/it\/","name":"Excel Advisor","description":"Tips, Tricks, and Time-Saving Hacks","publisher":{"@id":"https:\/\/exceladvisor.org\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/it\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/it\/","logo":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/comments?post=2128"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2128\/revisions"}],"predecessor-version":[{"id":2793,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2128\/revisions\/2793"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/media?parent=2128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}