{"id":665,"date":"2023-09-29T01:41:24","date_gmt":"2023-09-29T01:41:24","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/sair-se\/"},"modified":"2023-12-06T11:43:57","modified_gmt":"2023-12-06T11:43:57","slug":"sair-se","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/sair-se\/","title":{"rendered":"Como usar a instru\u00e7\u00e3o if no vba?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-1026537013\"><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><div class=\"excel-before-content\" id=\"excel-3241088738\"><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>No VBA, ao usar a <a href=\"https:\/\/exceladvisor.org\/pt\/se-2\/\">instru\u00e7\u00e3o IF<\/a> , voc\u00ea pode usar uma instru\u00e7\u00e3o GoTo para sair do IF. Deixe-me esclarecer aqui; n\u00e3o h\u00e1 nenhuma instru\u00e7\u00e3o de sa\u00edda separada que voc\u00ea possa usar com IF para sair. Portanto, seria melhor se voc\u00ea usasse goto para sair do IF antes que a linha da instru\u00e7\u00e3o final chegue.<\/p><p> Vamos dar um exemplo para entender isso. <\/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-sa\u00edda-se\" width=\"620\" height=\"512\"><\/figure><\/div><p> No exemplo acima, como voc\u00ea pode ver, usamos uma instru\u00e7\u00e3o IF para verificar se existe um valor na c\u00e9lula A1 ou n\u00e3o. Quando voc\u00ea <a href=\"https:\/\/exceladvisor.org\/pt\/executar-uma-macro-2\/\">executa este c\u00f3digo<\/a> e n\u00e3o h\u00e1 valor em A1, o VBA muda para \u201cLable1\u201d e executa o c\u00f3digo abaixo. Portanto, ser\u00e1 exibida uma caixa de entrada para inserir o valor na c\u00e9lula 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\"> Haver\u00e1 algumas situa\u00e7\u00f5es em que voc\u00ea precisar\u00e1 sair de uma instru\u00e7\u00e3o IF ao escrever c\u00f3digo VBA. Como voc\u00ea sabe, em uma \u00fanica instru\u00e7\u00e3o IF, s\u00f3 pode haver duas condi\u00e7\u00f5es e, se uma condi\u00e7\u00e3o for verdadeira, o VBA executar\u00e1 o c\u00f3digo que voc\u00ea mencionou para isso e sair\u00e1 da instru\u00e7\u00e3o automaticamente.<\/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\/pt\/vba\/\">O que \u00e9 VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriais relacionados <\/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\/pt\/se-2\/\">VBA SE (SE ent\u00e3o sen\u00e3o)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/se-e\/\">VBA SE E<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/de-outra-forma\/\">VBA SE N\u00c3O<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/se-ou\/\">VBA SE OU<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/aninhar-se\/\">VBA aninhado SE<\/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-665","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>Como usar a instru\u00e7\u00e3o IF no 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\/pt\/sair-se\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como usar a instru\u00e7\u00e3o IF no VBA? (Tutorial 2023)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/sair-se\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:43:57+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 estimado de leitura\" \/>\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\/pt\/sair-se\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/sair-se\/\",\"name\":\"Como usar a instru\u00e7\u00e3o IF no VBA? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/sair-se\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/sair-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-06T11:43:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/sair-se\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/sair-se\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/sair-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\/pt\/sair-se\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como usar a instru\u00e7\u00e3o if no vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como usar a instru\u00e7\u00e3o IF no 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\/pt\/sair-se\/","og_locale":"pt_PT","og_type":"article","og_title":"Como usar a instru\u00e7\u00e3o IF no VBA? (Tutorial 2023)","og_url":"https:\/\/exceladvisor.org\/pt\/sair-se\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:43:57+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 estimado de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/sair-se\/","url":"https:\/\/exceladvisor.org\/pt\/sair-se\/","name":"Como usar a instru\u00e7\u00e3o IF no VBA? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/sair-se\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/sair-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-06T11:43:57+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/sair-se\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/sair-se\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/sair-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\/pt\/sair-se\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como usar a instru\u00e7\u00e3o if no vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/665","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=665"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/665\/revisions"}],"predecessor-version":[{"id":1332,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/665\/revisions\/1332"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}