{"id":475,"date":"2023-10-26T13:28:29","date_gmt":"2023-10-26T13:28:29","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/chr\/"},"modified":"2023-12-25T10:30:08","modified_gmt":"2023-12-25T10:30:08","slug":"chr","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/chr\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba chr?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3550750751\"><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 CHR figura en la categor\u00eda de conversi\u00f3n de tipo de datos de funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong>devuelve un car\u00e1cter basado en el c\u00f3digo de car\u00e1cter que proporcion\u00f3<\/strong> . En t\u00e9rminos simples, puede proporcionar un c\u00f3digo entre 0 y 255 y devolver\u00e1 un car\u00e1cter para ese c\u00f3digo.<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>Chr(C\u00f3digo de caracteres)<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>C\u00f3digo de car\u00e1cter<\/strong> : el c\u00f3digo de car\u00e1cter para el cual desea obtener el car\u00e1cter.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA CHR, debe seguir el siguiente ejemplo donde escribimos un c\u00f3digo vba us\u00e1ndola: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"ejemplo-vba-chr-funci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-chr.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-chr-function\" width=\"837\" height=\"492\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_CHR() Range(\"B1\").Value = Chr(Range(\"A1\")) End Sub<\/code><\/pre>\n<p> En el ejemplo anterior, usamos el valor de la celda A1 (149), luego usamos la funci\u00f3n CHR para convertir ese valor en un car\u00e1cter y devolvi\u00f3 una <a href=\"https:\/\/exceladvisor.org\/es\/pulgas\/\">vi\u00f1eta<\/a> \u2022 en el resultado.<\/p>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> Devolver\u00eda un error si el valor proporcionado est\u00e1 fuera de rango (CharCode &lt; 0 o CharCode &gt; 255). <\/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-23\">\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cdbl\/\">VBA CDBL<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cdec\/\">CDEC VBA<\/a><\/li>\n<li> VBA CINT<\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/aferrarse\/\">CLNG VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/csng\/\">VBA CSNG<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA CHR figura en la categor\u00eda de conversi\u00f3n de tipo de datos de funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve un car\u00e1cter basado en el c\u00f3digo de car\u00e1cter que proporcion\u00f3 . En t\u00e9rminos simples, puede proporcionar un c\u00f3digo entre 0 y 255 y devolver\u00e1 un car\u00e1cter para ese c\u00f3digo. Sintaxis Chr(C\u00f3digo [&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-475","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 chr?<\/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\/chr\/\" \/>\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 chr?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA CHR figura en la categor\u00eda de conversi\u00f3n de tipo de datos de funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve un car\u00e1cter basado en el c\u00f3digo de car\u00e1cter que proporcion\u00f3 . En t\u00e9rminos simples, puede proporcionar un c\u00f3digo entre 0 y 255 y devolver\u00e1 un car\u00e1cter para ese c\u00f3digo. Sintaxis Chr(C\u00f3digo [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/chr\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:30:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-chr.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\/chr\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/chr\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba chr?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/chr\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/chr\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-chr.png\",\"datePublished\":\"2023-10-26T13:28:29+00:00\",\"dateModified\":\"2023-12-25T10:30:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/chr\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/chr\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/chr\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-chr.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-chr.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/chr\/#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 chr?\"}]},{\"@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 chr?","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\/chr\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba chr?","og_description":"La funci\u00f3n VBA CHR figura en la categor\u00eda de conversi\u00f3n de tipo de datos de funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve un car\u00e1cter basado en el c\u00f3digo de car\u00e1cter que proporcion\u00f3 . En t\u00e9rminos simples, puede proporcionar un c\u00f3digo entre 0 y 255 y devolver\u00e1 un car\u00e1cter para ese c\u00f3digo. Sintaxis Chr(C\u00f3digo [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/chr\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:30:08+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-chr.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\/chr\/","url":"https:\/\/exceladvisor.org\/es\/chr\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba chr?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/chr\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/chr\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-chr.png","datePublished":"2023-10-26T13:28:29+00:00","dateModified":"2023-12-25T10:30:08+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/chr\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/chr\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/chr\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-chr.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-chr.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/chr\/#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 chr?"}]},{"@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\/475","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=475"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/475\/revisions"}],"predecessor-version":[{"id":1229,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/475\/revisions\/1229"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}