{"id":666,"date":"2023-09-29T01:34:04","date_gmt":"2023-09-29T01:34:04","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/aninhar-se\/"},"modified":"2023-12-06T11:42:38","modified_gmt":"2023-12-06T11:42:38","slug":"aninhar-se","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/aninhar-se\/","title":{"rendered":"Como usar a fun\u00e7\u00e3o if aninhada do vba?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-1066868231\"><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-3122597015\"><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, voc\u00ea pode usar uma <a href=\"https:\/\/exceladvisor.org\/pt\/se-2\/\">instru\u00e7\u00e3o IF<\/a> dentro de outra instru\u00e7\u00e3o IF para criar IFs aninhados. Em palavras simples, voc\u00ea pode executar uma instru\u00e7\u00e3o de teste usando IF com base no resultado de outra instru\u00e7\u00e3o IF. Neste tipo de declara\u00e7\u00e3o condicional, voc\u00ea precisa testar condi\u00e7\u00f5es complexas. Vejamos um exemplo: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57650\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-aninhado-se\" width=\"388\" height=\"438\"><\/figure><\/div><p> No exemplo acima, estamos testando duas condi\u00e7\u00f5es, condi\u00e7\u00e3o1 (1 + 1 = 2) e condi\u00e7\u00e3o2 (2 + 2 = 4).<\/p><p> Mas como somos a instru\u00e7\u00e3o IF dentro da instru\u00e7\u00e3o IF, o VBA testar\u00e1 primeiro a primeira condi\u00e7\u00e3o e depois passar\u00e1 para o pr\u00f3ximo IF.<\/p><p> No segundo IF temos uma <a href=\"https:\/\/exceladvisor.org\/pt\/caixa-de-mensagens-vba\/\">caixa de mensagem<\/a> para mostrar se a condi\u00e7\u00e3o \u00e9 VERDADEIRA.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro1() 'first if statement If 1 + 1 = 2 Then 'second if statement If 2 + 2 = 4 Then MsgBox True End If Else MsgBox False End If End Sub<\/code><\/pre><p> Aqui est\u00e1 um exemplo de uso de v\u00e1rios IFs em um IF. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57651\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-exemple-pour-utiliser-plusieurs-ifs-dans-un-if.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"562\" height=\"613\"><\/figure><\/div><p> H\u00e1 uma diferen\u00e7a entre o exemplo que usamos anteriormente e o exemplo acima: Neste c\u00f3digo, usamos uma condi\u00e7\u00e3o aninhada para \u201cElse\u201d.<\/p><p> Se a primeira condi\u00e7\u00e3o n\u00e3o for verdadeira, o VBA ir\u00e1 pular para \u201cElse\u201d e testar a condi\u00e7\u00e3o, e se essa condi\u00e7\u00e3o n\u00e3o for verdadeira, passar\u00e1 para a pr\u00f3xima.<\/p><p> Dessa forma, temos um total de quatro condi\u00e7\u00f5es para testar.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro2() Dim myScore As Single: myScore = Range(\"A1\").Value If myScore &gt;= 80 Then MsgBox \"Excellent\" Else If myScore &gt;= 60 And myScore &lt; 80 Then MsgBox \"Good\" Else If myScore &gt;= 40 And myScore &lt; 60 Then MsgBox \"Average\" Else If myScore &lt; 40 Then MsgBox \"Poor\" End If End If End If End If End Sub<\/code><\/pre><p> Esta instru\u00e7\u00e3o IF aninhada testar\u00e1 a pontua\u00e7\u00e3o da c\u00e9lula A1 e exibir\u00e1 uma caixa de mensagem de acordo.<\/p><h2 class=\"wp-block-heading\"> IF aninhado VBA com m\u00faltiplas linhas (IF)<\/h2><p> Voc\u00ea tamb\u00e9m pode usar dois IFs diferentes para executar ambos os resultados (Verdadeiro e Falso). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57652\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-vba-imbrique-si-avec-plusieurs-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"638\" height=\"473\"><\/figure><\/div><p> No exemplo acima, como voc\u00ea pode ver, primeiro temos uma condi\u00e7\u00e3o para testar, e se essa condi\u00e7\u00e3o for VERDADEIRA, ent\u00e3o voc\u00ea ter\u00e1 outra condi\u00e7\u00e3o para testar, e se essa segunda condi\u00e7\u00e3o for VERDADEIRA, voc\u00ea receber\u00e1 uma caixa de mensagem.<\/p><p> E se a condi\u00e7\u00e3o principal for falsa, voc\u00ea ter\u00e1 outra condi\u00e7\u00e3o para testar e receber\u00e1 uma caixa de mensagem se essa condi\u00e7\u00e3o for verdadeira.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro3() If 1 + 1 = 2 Then If 2 - 1 = 1 Then MsgBox \"Condition1 is TRUE.\" End If Else If 3 - 2 = 1 Then MsgBox \"Condition2 is TRUE.\" End If End If End Sub<\/code><\/pre><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\/sair-se\/\">Sa\u00edda do VBA SE<\/a><\/li><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><\/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-666","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>\u25b7 Como usar a fun\u00e7\u00e3o IF aninhada do VBA?<\/title>\n<meta name=\"description\" content=\"voc\u00ea pode usar uma instru\u00e7\u00e3o IF dentro de outra instru\u00e7\u00e3o IF para criar IFs aninhados, ou seja, m\u00faltiplas instru\u00e7\u00f5es IF\" \/>\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\/aninhar-se\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Como usar a fun\u00e7\u00e3o IF aninhada do VBA?\" \/>\n<meta property=\"og:description\" content=\"voc\u00ea pode usar uma instru\u00e7\u00e3o IF dentro de outra instru\u00e7\u00e3o IF para criar IFs aninhados, ou seja, m\u00faltiplas instru\u00e7\u00f5es IF\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/aninhar-se\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:42:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-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=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/aninhar-se\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/aninhar-se\/\",\"name\":\"\u25b7 Como usar a fun\u00e7\u00e3o IF aninhada do VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/aninhar-se\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/aninhar-se\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png\",\"datePublished\":\"2023-09-29T01:34:04+00:00\",\"dateModified\":\"2023-12-06T11:42:38+00:00\",\"description\":\"voc\u00ea pode usar uma instru\u00e7\u00e3o IF dentro de outra instru\u00e7\u00e3o IF para criar IFs aninhados, ou seja, m\u00faltiplas instru\u00e7\u00f5es IF\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/aninhar-se\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/aninhar-se\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/aninhar-se\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/aninhar-se\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como usar a fun\u00e7\u00e3o if aninhada do 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":"\u25b7 Como usar a fun\u00e7\u00e3o IF aninhada do VBA?","description":"voc\u00ea pode usar uma instru\u00e7\u00e3o IF dentro de outra instru\u00e7\u00e3o IF para criar IFs aninhados, ou seja, m\u00faltiplas instru\u00e7\u00f5es IF","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\/aninhar-se\/","og_locale":"pt_PT","og_type":"article","og_title":"\u25b7 Como usar a fun\u00e7\u00e3o IF aninhada do VBA?","og_description":"voc\u00ea pode usar uma instru\u00e7\u00e3o IF dentro de outra instru\u00e7\u00e3o IF para criar IFs aninhados, ou seja, m\u00faltiplas instru\u00e7\u00f5es IF","og_url":"https:\/\/exceladvisor.org\/pt\/aninhar-se\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:42:38+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/aninhar-se\/","url":"https:\/\/exceladvisor.org\/pt\/aninhar-se\/","name":"\u25b7 Como usar a fun\u00e7\u00e3o IF aninhada do VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/aninhar-se\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/aninhar-se\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png","datePublished":"2023-09-29T01:34:04+00:00","dateModified":"2023-12-06T11:42:38+00:00","description":"voc\u00ea pode usar uma instru\u00e7\u00e3o IF dentro de outra instru\u00e7\u00e3o IF para criar IFs aninhados, ou seja, m\u00faltiplas instru\u00e7\u00f5es IF","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/aninhar-se\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/aninhar-se\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/aninhar-se\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-imbrique-si.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/aninhar-se\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como usar a fun\u00e7\u00e3o if aninhada do 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\/666","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=666"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/666\/revisions"}],"predecessor-version":[{"id":1226,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/666\/revisions\/1226"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}