{"id":2138,"date":"2023-09-29T01:41:24","date_gmt":"2023-09-29T01:41:24","guid":{"rendered":"https:\/\/exceladvisor.org\/it\/esci-se\/"},"modified":"2023-12-10T06:26:36","modified_gmt":"2023-12-10T06:26:36","slug":"esci-se","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/it\/esci-se\/","title":{"rendered":"Come utilizzare l&#39;istruzione if in vba?"},"content":{"rendered":"<div class=\"excel-prima-del-contenuto\" id=\"excel-1287944324\"><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>In VBA, quando si utilizza l&#8217; <a href=\"https:\/\/exceladvisor.org\/it\/se-2\/\">istruzione IF<\/a> , \u00e8 possibile utilizzare un&#8217;istruzione GoTo per uscire dall&#8217;IF. Vorrei chiarire qui; non esiste un&#8217;istruzione di uscita separata che puoi utilizzare con IF per uscire. Quindi sarebbe meglio se usassi goto per uscire da IF prima che arrivi la riga dell&#8217;istruzione end.<\/p><p> Facciamo un esempio per capirlo. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57658\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-esci-se\" width=\"620\" height=\"512\"><\/figure><\/div><p> Nell&#8217;esempio sopra, come puoi vedere, abbiamo utilizzato un&#8217;istruzione IF per verificare se \u00e8 presente o meno un valore nella cella A1. Quando <a href=\"https:\/\/exceladvisor.org\/it\/eseguire-una-macro-2\/\">esegui questo codice<\/a> e non \u00e8 presente alcun valore in A1, VBA passa a &#8220;Lable1&#8221; ed esegue il codice seguente. Quindi verr\u00e0 visualizzata una casella di input per inserire il valore nella cella A1.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() If Range(\"A1\") = \"\" Then GoTo Lable1 Else MsgBox \"there's a value in the cell.\" End If Lable1: Range(\"A1\").Value = _ InputBox(\"Enter Value\") End Sub<\/code><\/pre><p class=\"grey-note\"> Ci saranno alcune situazioni in cui sar\u00e0 necessario uscire da un&#8217;istruzione IF durante la scrittura del codice VBA. Come sai nella singola istruzione IF, possono esserci solo due condizioni e, se una condizione \u00e8 vera, VBA eseguir\u00e0 il codice che hai menzionato per quello e quindi uscir\u00e0 automaticamente dall&#8217;istruzione.<\/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\/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\/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 NO<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/io-per\/\">VBA SE O<\/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-2138","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 l&#039;istruzione IF in VBA? (Tutorial 2023)<\/title>\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\/esci-se\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Come utilizzare l&#039;istruzione IF in VBA? (Tutorial 2023)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/it\/esci-se\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:26:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.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=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/it\/esci-se\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/esci-se\/\",\"name\":\"Come utilizzare l&#39;istruzione IF in VBA? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/esci-se\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/esci-se\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.png\",\"datePublished\":\"2023-09-29T01:41:24+00:00\",\"dateModified\":\"2023-12-10T06:26:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/esci-se\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/it\/esci-se\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/esci-se\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/it\/esci-se\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceladvisor.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Come utilizzare l&#39;istruzione if 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 l&#39;istruzione IF in VBA? (Tutorial 2023)","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\/esci-se\/","og_locale":"it_IT","og_type":"article","og_title":"Come utilizzare l&#39;istruzione IF in VBA? (Tutorial 2023)","og_url":"https:\/\/exceladvisor.org\/it\/esci-se\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:26:36+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo di lettura stimato":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/it\/esci-se\/","url":"https:\/\/exceladvisor.org\/it\/esci-se\/","name":"Come utilizzare l&#39;istruzione IF in VBA? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/it\/esci-se\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/esci-se\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.png","datePublished":"2023-09-29T01:41:24+00:00","dateModified":"2023-12-10T06:26:36+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/it\/esci-se\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/it\/esci-se\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/esci-se\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/it\/esci-se\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceladvisor.org\/it\/"},{"@type":"ListItem","position":2,"name":"Come utilizzare l&#39;istruzione if 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\/2138","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=2138"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2138\/revisions"}],"predecessor-version":[{"id":2812,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2138\/revisions\/2812"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/media?parent=2138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}