{"id":689,"date":"2023-09-27T16:13:55","date_gmt":"2023-09-27T16:13:55","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/"},"modified":"2023-12-25T10:31:50","modified_gmt":"2023-12-25T10:31:50","slug":"cuadro-de-mensaje-variable","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/","title":{"rendered":"\u00bfc\u00f3mo utilizar una variable en un cuadro de mensaje?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2377426521\"><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>Tambi\u00e9n puede utilizar una <a href=\"https:\/\/exceladvisor.org\/es\/variables\/\">variable<\/a> en un cuadro de mensaje. Digamos que tiene una variable que almacena un valor espec\u00edfico en esa variable.<\/p>\n<p> Ahora puede usar esta variable en el <a href=\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensajes-vba\/\">cuadro de mensaje<\/a> para mostrar el valor al usuario. En el siguiente ejemplo hemos usado una macro donde hemos usado el bucle for y tenemos una funci\u00f3n para <a href=\"https:\/\/exceladvisor.org\/es\/numero-aleatorio\/\">generar un n\u00famero aleatorio<\/a> . <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-60695\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"cuadro de mensajes-variable-vba\" width=\"760\" height=\"486\"><\/figure>\n<\/div>\n<p> Cuando <a href=\"https:\/\/exceladvisor.org\/es\/ejecutar-una-macro-2\/\">ejecuta este c\u00f3digo<\/a> , se repite 10 veces, luego genera un n\u00famero aleatorio y almacena ese n\u00famero en la variable. En la siguiente l\u00ednea de c\u00f3digo, hemos utilizado la misma variable para mostrar el valor en el cuadro de mensaje. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-60696\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"161\" height=\"191\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub generateRandomNumber() Dim i As Integer, rNumber As Integer i = 10 For i = 1 To i rNumber = WorksheetFunction.RandBetween(1000, 2000) MsgBox rNumber Next i 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\"> 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\/variable-global\/\">Declarar una variable global (p\u00fablica) en VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/rango-variable\/\">Utilice un rango o celda como variable en VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/opcion-explicita-2\/\">Declaraci\u00f3n de opci\u00f3n expl\u00edcita en VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/debil\/\">Instrucci\u00f3n VBA tenue<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/variables\/\">Variables de VBA (declaraci\u00f3n, tipos de datos y alcance)<\/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>Tambi\u00e9n puede utilizar una variable en un cuadro de mensaje. Digamos que tiene una variable que almacena un valor espec\u00edfico en esa variable. Ahora puede usar esta variable en el cuadro de mensaje para mostrar el valor al usuario. En el siguiente ejemplo hemos usado una macro donde hemos usado el bucle for y tenemos [&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-689","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 una variable en un cuadro de mensaje?<\/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\/cuadro-de-mensaje-variable\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo utilizar una variable en un cuadro de mensaje?\" \/>\n<meta property=\"og:description\" content=\"Tambi\u00e9n puede utilizar una variable en un cuadro de mensaje. Digamos que tiene una variable que almacena un valor espec\u00edfico en esa variable. Ahora puede usar esta variable en el cuadro de mensaje para mostrar el valor al usuario. En el siguiente ejemplo hemos usado una macro donde hemos usado el bucle for y tenemos [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:31:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.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\/cuadro-de-mensaje-variable\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/\",\"name\":\"\u00bfc\u00f3mo utilizar una variable en un cuadro de mensaje?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png\",\"datePublished\":\"2023-09-27T16:13:55+00:00\",\"dateModified\":\"2023-12-25T10:31:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar una variable en un cuadro de mensaje?\"}]},{\"@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 una variable en un cuadro de mensaje?","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\/cuadro-de-mensaje-variable\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar una variable en un cuadro de mensaje?","og_description":"Tambi\u00e9n puede utilizar una variable en un cuadro de mensaje. Digamos que tiene una variable que almacena un valor espec\u00edfico en esa variable. Ahora puede usar esta variable en el cuadro de mensaje para mostrar el valor al usuario. En el siguiente ejemplo hemos usado una macro donde hemos usado el bucle for y tenemos [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:31:50+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.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\/cuadro-de-mensaje-variable\/","url":"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/","name":"\u00bfc\u00f3mo utilizar una variable en un cuadro de mensaje?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png","datePublished":"2023-09-27T16:13:55+00:00","dateModified":"2023-12-25T10:31:50+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar una variable en un cuadro de mensaje?"}]},{"@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\/689","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=689"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/689\/revisions"}],"predecessor-version":[{"id":1384,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/689\/revisions\/1384"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}