{"id":577,"date":"2023-10-22T19:48:52","date_gmt":"2023-10-22T19:48:52","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/"},"modified":"2023-12-25T10:25:11","modified_gmt":"2023-12-25T10:25:11","slug":"tabla-de-valores-de-busqueda","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/","title":{"rendered":"\u00bfc\u00f3mo encontrar un valor en una matriz usando vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3430451850\"><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>Cuando almacena valores en una matriz, puede haber ocasiones en las que necesite realizar una b\u00fasqueda en la matriz. En este caso, necesita conocer los m\u00e9todos que puede utilizar. Ahora mire el c\u00f3digo a continuaci\u00f3n que puede ayudarlo a comprender c\u00f3mo buscar un valor en una matriz. <\/p>\n<div class=\"wp-block-image is-style-default\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57290\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"encontrar-un-valor-en-una-matriz-1\" width=\"709\" height=\"1456\"><\/figure>\n<\/div>\n<ol type=\"1\">\n<li> En la primera parte del c\u00f3digo tienes <a href=\"https:\/\/exceladvisor.org\/es\/variables\/\">variables<\/a> que necesitar\u00e1s usar m\u00e1s adelante en el c\u00f3digo.<\/li>\n<li> Despu\u00e9s de eso, la siguiente parte <a href=\"https:\/\/exceladvisor.org\/es\/numero-aleatorio\/\">genera n\u00fameros aleatorios<\/a> usando <a href=\"https:\/\/exceladvisor.org\/es\/rnd\/\">RND<\/a> para obtener los diez valores de la matriz.<\/li>\n<li> A continuaci\u00f3n, un cuadro de entrada le permite ingresar el valor que desea buscar en la tabla.<\/li>\n<li> Despu\u00e9s de eso, tiene una l\u00ednea que usa la <a href=\"https:\/\/exceladvisor.org\/es\/si-2\/\">declaraci\u00f3n IF<\/a> para verificar si el valor que ingres\u00f3 en el cuadro de entrada es un n\u00famero o no.<\/li>\n<li> En esta parte tienes un c\u00f3digo para la cadena que usar\u00e1s en el <a href=\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensajes-vba\/\">cuadro de mensaje<\/a> si no se encuentra el valor que ingresaste.<\/li>\n<li> Esta parte del c\u00f3digo utiliza un <a href=\"https:\/\/exceladvisor.org\/es\/para-el-bucle\/\">bucle For (For Each)<\/a> para <a href=\"https:\/\/exceladvisor.org\/es\/tamano-de-matriz\/\">recorrer cada elemento de la matriz<\/a> y comprobar si el valor que ingres\u00f3 est\u00e1 en la matriz o no.<\/li>\n<li> La \u00faltima parte del c\u00f3digo muestra un mensaje que indica si se encuentra el valor o no.<\/li>\n<\/ol>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Option Base 1 Sub vba_array_search() 'this section declares an array and variables 'that you need to search within the array. Dim myArray(10) As Integer Dim i As Integer Dim varUserNumber As Variant Dim strMsg As String 'This part of the code adds 10 random numbers to 'the array and shows the result in the 'immediate window as well. For i = 1 To 10 myArray(i) = Int(Rnd * 10) Debug.Print myArray(i) Next i 'it is an input box that asks 'you the number that you want to find Loopback: varUserNumber = InputBox _ (\"Enter a number between 1 and 10 to search for:\", _ \"Linear Search Demonstrator\") 'it's an if statement that checks for the value that you 'have entered in the input box. If varUserNumber = \"\" Then End If Not IsNumeric(varUserNumber) Then GoTo Loopback If varUserNumber &lt; 1 Or varUserNumber &gt; 10 Then GoTo Loopback 'message to show if the value doesn't found. strMsg = \"Your value, \" &amp; varUserNumber &amp; _ \", was not found in the array.\" 'loop through the array and match each value with the 'the value you have entered in the input box. For i = 1 To UBound(myArray) If myArray(i) = varUserNumber Then strMsg = \"Your value, \" &amp; varUserNumber &amp; _ \", was found at position \" &amp; i &amp; \" in the array.\" Exit For End If Next i 'message box in the end MsgBox _ strMsg, vbOKOnly + vbInformation, _ \"Linear Search Result\" End Sub<\/code><\/pre>\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\"> Obtenga m\u00e1s informaci\u00f3n sobre <a href=\"https:\/\/exceladvisor.org\/es\/pinturas\/\">las tablas VBA<\/a> <\/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\/agregar-una-nueva-matriz-de-valores\/\">VBA Agregar nuevo valor a la matriz<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/tamano-de-matriz\/\">Longitud de la matriz VBA (tama\u00f1o)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/mesa-con-cadenas\/\">Matriz VBA con cadenas<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/\">Matriz clara de VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/tabla-dinamica\/\">Tabla din\u00e1mica VBA<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Cuando almacena valores en una matriz, puede haber ocasiones en las que necesite realizar una b\u00fasqueda en la matriz. En este caso, necesita conocer los m\u00e9todos que puede utilizar. Ahora mire el c\u00f3digo a continuaci\u00f3n que puede ayudarlo a comprender c\u00f3mo buscar un valor en una matriz. En la primera parte del c\u00f3digo tienes variables [&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-577","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 encontrar un valor en una matriz usando 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\/tabla-de-valores-de-busqueda\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo encontrar un valor en una matriz usando vba?\" \/>\n<meta property=\"og:description\" content=\"Cuando almacena valores en una matriz, puede haber ocasiones en las que necesite realizar una b\u00fasqueda en la matriz. En este caso, necesita conocer los m\u00e9todos que puede utilizar. Ahora mire el c\u00f3digo a continuaci\u00f3n que puede ayudarlo a comprender c\u00f3mo buscar un valor en una matriz. En la primera parte del c\u00f3digo tienes variables [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:25:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.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\/tabla-de-valores-de-busqueda\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/\",\"name\":\"\u00bfc\u00f3mo encontrar un valor en una matriz usando vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png\",\"datePublished\":\"2023-10-22T19:48:52+00:00\",\"dateModified\":\"2023-12-25T10:25:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo encontrar un valor en una matriz usando 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 encontrar un valor en una matriz usando 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\/tabla-de-valores-de-busqueda\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo encontrar un valor en una matriz usando vba?","og_description":"Cuando almacena valores en una matriz, puede haber ocasiones en las que necesite realizar una b\u00fasqueda en la matriz. En este caso, necesita conocer los m\u00e9todos que puede utilizar. Ahora mire el c\u00f3digo a continuaci\u00f3n que puede ayudarlo a comprender c\u00f3mo buscar un valor en una matriz. En la primera parte del c\u00f3digo tienes variables [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:25:11+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.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\/tabla-de-valores-de-busqueda\/","url":"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/","name":"\u00bfc\u00f3mo encontrar un valor en una matriz usando vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png","datePublished":"2023-10-22T19:48:52+00:00","dateModified":"2023-12-25T10:25:11+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/tabla-de-valores-de-busqueda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo encontrar un valor en una matriz usando 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\/577","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=577"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/577\/revisions"}],"predecessor-version":[{"id":1018,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/577\/revisions\/1018"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}