{"id":669,"date":"2023-09-29T00:37:26","date_gmt":"2023-09-29T00:37:26","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/constantes\/"},"modified":"2023-12-25T10:32:14","modified_gmt":"2023-12-25T10:32:14","slug":"constantes","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/constantes\/","title":{"rendered":"\u00bfqu\u00e9 es una constante en vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3539336369\"><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, una constante es un cuadro de almacenamiento que a su vez se almacena en su sistema y puede almacenar un valor all\u00ed por usted, pero el valor que le asigna no se puede cambiar cuando se ejecuta el c\u00f3digo. En VBA, hay dos tipos diferentes de constantes que puedes usar:<\/p>\n<ul>\n<li> Constantes intr\u00ednsecas<\/li>\n<li> Constantes definidas por el usuario<\/li>\n<\/ul>\n<p> <strong>Las constantes intr\u00ednsecas<\/strong> son aquellas que est\u00e1n integradas en el propio lenguaje VBA (por ejemplo, la constante incorporada vbOKCancel que usa en el <a href=\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensajes-vba\/\">cuadro de mensaje<\/a> ) y, por otro lado, <strong>las constantes definidas por el usuario<\/strong> son aquellas que puede crear asignando un valor para ello.<\/p>\n<h2 class=\"wp-block-heading\"> Declarar una constante en VBA<\/h2>\n<ol type=\"1\">\n<li> Utilice la palabra clave \u00abConst\u00bb.<\/li>\n<li> Especifique un nombre para la constante.<\/li>\n<li> Utilice la palabra clave \u00abComo\u00bb despu\u00e9s del nombre.<\/li>\n<li> Especifique el \u00abTipo de datos\u00bb para la constante seg\u00fan el valor que desee asignarle.<\/li>\n<li> Igual al signo \u201c=\u00bb.<\/li>\n<li> En definitiva, el valor que le quieras asignar. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-60175\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"declarar-una-constante-en-vba\" width=\"483\" height=\"267\"><\/figure>\n<\/div>\n<p> Arriba hay una constante que almacena una fecha de nacimiento. Ahora si crees que una fecha de nacimiento es algo que se supone que es fijo y para este tipo de valor puedes usar una constante.<\/p>\n<h2 class=\"wp-block-heading\"> Alcance de una constante<\/h2>\n<p> La constante tiene el mismo alcance que <a href=\"https:\/\/exceladvisor.org\/es\/variables\/\">las variables<\/a> . Cuando declaras una constante, tiene alcance a nivel de procedimiento, lo que significa que puedes usarla en cualquier parte del procedimiento. Pero puedes declarar una constante usando un alcance p\u00fablico o privado.<\/p>\n<p> Una constante privada s\u00f3lo est\u00e1 disponible para el procedimiento en el que se declara como constante. Para declarar una constante privada, debe utilizar las palabras clave \u00abPrivadas\u00bb, como en el siguiente ejemplo.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Private Const iName As String = \u201cPuneet\u201d<\/code><\/pre>\n<p> Y de manera similar, debes usar la palabra clave \u00abP\u00fablico\u00bb cuando necesites declarar una constante como p\u00fablica.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Public Const iPrice As String = \u201c$3.99\u201d<\/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\/cuadro-de-mensaje-variable\/\">Variable en un cuadro de mensaje<\/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>En VBA, una constante es un cuadro de almacenamiento que a su vez se almacena en su sistema y puede almacenar un valor all\u00ed por usted, pero el valor que le asigna no se puede cambiar cuando se ejecuta el c\u00f3digo. En VBA, hay dos tipos diferentes de constantes que puedes usar: Constantes intr\u00ednsecas Constantes [&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-669","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>\u00bfqu\u00e9 es una constante 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\/constantes\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfqu\u00e9 es una constante en vba?\" \/>\n<meta property=\"og:description\" content=\"En VBA, una constante es un cuadro de almacenamiento que a su vez se almacena en su sistema y puede almacenar un valor all\u00ed por usted, pero el valor que le asigna no se puede cambiar cuando se ejecuta el c\u00f3digo. En VBA, hay dos tipos diferentes de constantes que puedes usar: Constantes intr\u00ednsecas Constantes [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/constantes\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:32:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-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=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/constantes\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/constantes\/\",\"name\":\"\u00bfqu\u00e9 es una constante en vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/constantes\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/constantes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-vba.png\",\"datePublished\":\"2023-09-29T00:37:26+00:00\",\"dateModified\":\"2023-12-25T10:32:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/constantes\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/constantes\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/constantes\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/constantes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfqu\u00e9 es una constante 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":"\u00bfqu\u00e9 es una constante 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\/constantes\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfqu\u00e9 es una constante en vba?","og_description":"En VBA, una constante es un cuadro de almacenamiento que a su vez se almacena en su sistema y puede almacenar un valor all\u00ed por usted, pero el valor que le asigna no se puede cambiar cuando se ejecuta el c\u00f3digo. En VBA, hay dos tipos diferentes de constantes que puedes usar: Constantes intr\u00ednsecas Constantes [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/constantes\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:32:14+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-vba.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\/constantes\/","url":"https:\/\/exceladvisor.org\/es\/constantes\/","name":"\u00bfqu\u00e9 es una constante en vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/constantes\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/constantes\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-vba.png","datePublished":"2023-09-29T00:37:26+00:00","dateModified":"2023-12-25T10:32:14+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/constantes\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/constantes\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/constantes\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/constantes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfqu\u00e9 es una constante 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\/669","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=669"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/669\/revisions"}],"predecessor-version":[{"id":1407,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/669\/revisions\/1407"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=669"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}