{"id":659,"date":"2023-09-30T03:47:06","date_gmt":"2023-09-30T03:47:06","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/"},"modified":"2023-12-25T10:27:50","modified_gmt":"2023-12-25T10:27:50","slug":"de-lo-contrario","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/","title":{"rendered":"\u00bfc\u00f3mo usar si no en vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3725647125\"><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>En VBA, cuando usa la <a href=\"https:\/\/exceladvisor.org\/es\/si-2\/\">declaraci\u00f3n IF<\/a> , ejecuta una l\u00ednea de c\u00f3digo si la condici\u00f3n que especific\u00f3 para probar es VERDADERA. Pero cuando usa el operador NOT con IF, verifica si la condici\u00f3n que especific\u00f3 no es VERDADERA y ejecuta el c\u00f3digo basado en eso.<\/p>\n<p> <strong>Es como hacer la declaraci\u00f3n IF opuesta, de VERDADERO a FALSO y de FALSO a VERDADERO.<\/strong><\/p>\n<p> Digamos que desea probar si A &lt; B, y si esta condici\u00f3n es verdadera, SI devolver\u00e1 VERDADERO, \u00bfverdad? Pero cuando usas IF NOT A &lt; B, devolver\u00e1 FALSO.<\/p>\n<p class=\"qt-tip\"> <strong>Nota:<\/strong> NOT es un operador l\u00f3gico.<\/p>\n<h2 class=\"wp-block-heading\"> <strong>Ejemplos de uso de VBA SI NO<\/strong><\/h2>\n<p> Aqu\u00ed veremos un ejemplo sencillo para entenderlo: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57664\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png\" sizes=\"auto, \" srcset=\"\" alt=\"ejemplo-para-usar-vba-si-no\" width=\"698\" height=\"493\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() Dim A As Range, B As Range Set A = Range(\"A1\") Set B = Range(\"B1\") If Not A &lt; B Then MsgBox \"A is not greater than B.\" Else MsgBox \"B is not greater than A.\" End If End Sub<\/code><\/pre>\n<p> En el c\u00f3digo anterior, utiliz\u00f3 el operador NOT para probar si B no es mayor que A.<\/p>\n<p> Si observa la declaraci\u00f3n de condici\u00f3n, puede comprender que la condici\u00f3n real que se va a probar es si B es mayor que A, pero como usamos la declaraci\u00f3n NOT, devolver\u00e1 FALSO si la condici\u00f3n es VERDADERA. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57662\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utilise-loperateur-not.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"524\" height=\"285\"><\/figure>\n<\/div>\n<p> Aqu\u00ed tienes otro ejemplo que puedes utilizar para entenderlo.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() If Not ActiveSheet.Name = Sheets(\"Sheet1\").Name Then Sheets(\"Sheet1\").Activate End If End Sub<\/code><\/pre>\n<p> Ahora, en este c\u00f3digo, usaste <strong>NOT con IF<\/strong> para ver si la hoja activa es Sheet1 o no, y si no lo es, la l\u00ednea de c\u00f3digo que especificamos <a href=\"https:\/\/exceladvisor.org\/es\/activar-hoja\/\">activar\u00e1 Sheet1<\/a> .<\/p>\n<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\/es\/vba\/\">\u00bfQu\u00e9 es VBA?<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/salir-si\/\">VBA Salir SI<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/si-2\/\">VBA SI (SI entonces si no)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/si-y\/\">VBA SI y<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/yo-para\/\">VBA SI O<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/nido-si\/\">VBA anidado SI<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-50067b57\">\n<div class=\"gb-container gb-container-50067b57\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En VBA, cuando usa la declaraci\u00f3n IF , ejecuta una l\u00ednea de c\u00f3digo si la condici\u00f3n que especific\u00f3 para probar es VERDADERA. Pero cuando usa el operador NOT con IF, verifica si la condici\u00f3n que especific\u00f3 no es VERDADERA y ejecuta el c\u00f3digo basado en eso. Es como hacer la declaraci\u00f3n IF opuesta, de VERDADERO [&hellip;]<\/p>\n","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-659","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>\u00bfc\u00f3mo usar si no en vba?<\/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\/es\/de-lo-contrario\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo usar si no en vba?\" \/>\n<meta property=\"og:description\" content=\"En VBA, cuando usa la declaraci\u00f3n IF , ejecuta una l\u00ednea de c\u00f3digo si la condici\u00f3n que especific\u00f3 para probar es VERDADERA. Pero cuando usa el operador NOT con IF, verifica si la condici\u00f3n que especific\u00f3 no es VERDADERA y ejecuta el c\u00f3digo basado en eso. Es como hacer la declaraci\u00f3n IF opuesta, de VERDADERO [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:27:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\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\/es\/de-lo-contrario\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/\",\"name\":\"\u00bfc\u00f3mo usar si no en vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png\",\"datePublished\":\"2023-09-30T03:47:06+00:00\",\"dateModified\":\"2023-12-25T10:27:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo usar si no en vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo usar si no en vba?","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\/es\/de-lo-contrario\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo usar si no en vba?","og_description":"En VBA, cuando usa la declaraci\u00f3n IF , ejecuta una l\u00ednea de c\u00f3digo si la condici\u00f3n que especific\u00f3 para probar es VERDADERA. Pero cuando usa el operador NOT con IF, verifica si la condici\u00f3n que especific\u00f3 no es VERDADERA y ejecuta el c\u00f3digo basado en eso. Es como hacer la declaraci\u00f3n IF opuesta, de VERDADERO [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:27:50+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/","url":"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/","name":"\u00bfc\u00f3mo usar si no en vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png","datePublished":"2023-09-30T03:47:06+00:00","dateModified":"2023-12-25T10:27:50+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/de-lo-contrario\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/de-lo-contrario\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo usar si no en vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/659","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=659"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/659\/revisions"}],"predecessor-version":[{"id":1236,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/659\/revisions\/1236"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}