{"id":502,"date":"2023-10-26T08:06:31","date_gmt":"2023-10-26T08:06:31","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/instruir\/"},"modified":"2023-12-25T10:30:32","modified_gmt":"2023-12-25T10:30:32","slug":"instruir","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/instruir\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba instr?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-577389374\"><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>La funci\u00f3n VBA INSTR aparece en la categor\u00eda de texto de funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong>devuelve el n\u00famero de posici\u00f3n inicial de una subcadena (especificada por usted) de otra cadena<\/strong> . En t\u00e9rminos simples, funciona como las funciones <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/es\/funciones-de-cadena-de-excel\/\">BUSCAR<\/a> y <a href=\"https:\/\/exceladvisor.org\/es\/funciones-de-cadena-de-excel\/\">BUSCAR<\/a> (funciones de hoja de c\u00e1lculo).<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>InStr([Inicio], Cadena1, Cadena2, [Comparar])<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>[Inicio]<\/strong> : un n\u00famero entero para especificar la posici\u00f3n desde la cual desea comenzar la b\u00fasqueda [Este es un argumento opcional y, si se omite, VBA tiene como valor predeterminado 1].<\/li>\n<li> <strong>String1<\/strong> : La cadena en la que desea buscar.<\/li>\n<li> <strong>String2<\/strong> : la cadena que desea buscar.<\/li>\n<li> <strong>[Comparar]<\/strong> : un valor de cadena para definir la comparaci\u00f3n que se realizar\u00e1 al filtrar la matriz [Este es un argumento opcional y, si se omite, VBA toma vbBinaryCompare de forma predeterminada].\n<ul>\n<li> vbBinaryCompare: para comparaci\u00f3n binaria.<\/li>\n<li> vbTextCompare: para comparaci\u00f3n de texto.<\/li>\n<li> vbDatabaseCompare: para comparar bases de datos.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA INSTR, debe seguir el siguiente ejemplo donde escribimos un c\u00f3digo vba us\u00e1ndola: <\/p>\n<div class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" title=\"ejemplo-vba-instr-funci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-instr-function\" width=\"838\" height=\"482\"><\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_INSTR() Range(\"B1\").Value = InStr(Range(\"A1\"), \" \") End Sub<\/code><\/pre>\n<p> En el c\u00f3digo anterior usamos INSTR para encontrar el espacio en el valor (Mick Griffin) en la celda A1 y devolvi\u00f3 5 como resultado, hay el primer espacio entre &#8216;Mick&#8217; y &#8216;Griffin&#8217; cuya posici\u00f3n es 5.<\/p>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<p> A continuaci\u00f3n se detallan algunos puntos importantes que debe considerar al utilizar la funci\u00f3n INSTR en VBA.<\/p>\n<ul>\n<li> Si no se puede encontrar \u00abcadena1\u00bb en \u00abcadena2\u00bb, el resultado ser\u00e1 0. <\/li>\n<\/ul>\n<div class=\"wp-block-group more-tutorials is-layout-flow\">\n<div class=\"wp-block-group__inner-container\">\n<h2 class=\"wp-block-heading\"> M\u00e1s tutoriales <\/h2>\n<div class=\"wp-block-columns is-layout-flex wp-container-240\">\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/strconv\/\">VBA STRCONV<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cadena-2\/\">CUERDA VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/strreverse\/\">VBA STRE INVERSA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/recortar\/\">AJUSTE DE VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ucase\/\">VBAUCASE<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA INSTR aparece en la categor\u00eda de texto de funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve el n\u00famero de posici\u00f3n inicial de una subcadena (especificada por usted) de otra cadena . En t\u00e9rminos simples, funciona como las funciones BUSCAR y BUSCAR (funciones de hoja de c\u00e1lculo). Sintaxis InStr([Inicio], Cadena1, Cadena2, [Comparar]) [&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-502","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 utilizar la funci\u00f3n vba instr?<\/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\/instruir\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba instr?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA INSTR aparece en la categor\u00eda de texto de funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve el n\u00famero de posici\u00f3n inicial de una subcadena (especificada por usted) de otra cadena . En t\u00e9rminos simples, funciona como las funciones BUSCAR y BUSCAR (funciones de hoja de c\u00e1lculo). Sintaxis InStr([Inicio], Cadena1, Cadena2, [Comparar]) [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/instruir\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:30:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.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=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/instruir\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/instruir\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba instr?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/instruir\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/instruir\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.png\",\"datePublished\":\"2023-10-26T08:06:31+00:00\",\"dateModified\":\"2023-12-25T10:30:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/instruir\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/instruir\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/instruir\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/instruir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba instr?\"}]},{\"@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 utilizar la funci\u00f3n vba instr?","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\/instruir\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba instr?","og_description":"La funci\u00f3n VBA INSTR aparece en la categor\u00eda de texto de funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve el n\u00famero de posici\u00f3n inicial de una subcadena (especificada por usted) de otra cadena . En t\u00e9rminos simples, funciona como las funciones BUSCAR y BUSCAR (funciones de hoja de c\u00e1lculo). Sintaxis InStr([Inicio], Cadena1, Cadena2, [Comparar]) [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/instruir\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:30:32+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/instruir\/","url":"https:\/\/exceladvisor.org\/es\/instruir\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba instr?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/instruir\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/instruir\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.png","datePublished":"2023-10-26T08:06:31+00:00","dateModified":"2023-12-25T10:30:32+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/instruir\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/instruir\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/instruir\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/instruir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba instr?"}]},{"@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\/502","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=502"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/502\/revisions"}],"predecessor-version":[{"id":1278,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/502\/revisions\/1278"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}