{"id":560,"date":"2023-10-23T20:13:35","date_gmt":"2023-10-23T20:13:35","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/vale\/"},"modified":"2023-12-25T10:31:23","modified_gmt":"2023-12-25T10:31:23","slug":"vale","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/vale\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba val?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2642871174\"><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 VAL aparece en la categor\u00eda de conversi\u00f3n de tipo de datos de funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong>convierte una cadena en un n\u00famero.<\/strong> En t\u00e9rminos simples, toma un n\u00famero almacenado como una cadena y lo devuelve como un n\u00famero.<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>Val(cadena)<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>Cadena<\/strong> : una cadena que desea convertir en un n\u00famero.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA VAL, 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-val-funci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-val.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-val-function\" width=\"836\" height=\"481\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_VAL() Range(\"B1\").Value = Val(Range(\"A1\")) Range(\"B2\").Value = Val(Range(\"A2\")) End Sub<\/code><\/pre>\n<p> En el c\u00f3digo anterior, usamos VAL para obtener el valor num\u00e9rico de las celdas A1 y A2:<\/p>\n<ol>\n<li> En la celda A1 tenemos el valor que comienza con un n\u00famero y extrajo ese valor en la celda B1.<\/li>\n<li> Pero en la celda A2, el valor comienza con un car\u00e1cter que no puede reconocerse como un n\u00famero, por lo que ignora todos los caracteres posteriores.<\/li>\n<\/ol>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> Deja de leer la cadena en el primer car\u00e1cter que no puede reconocer como un n\u00famero.<\/li>\n<li> Reconoce un punto (.) como separador decimal v\u00e1lido.<\/li>\n<li> Reconoce s\u00edmbolos y caracteres como parte de valores num\u00e9ricos. <\/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-24\">\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/booleano\/\">VBA CBOOL<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cbyte\/\">Bytes VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ocurre\/\">VBA CCUR<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fecha-c\/\">CDATE VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cdbl\/\">VBA CDBL<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA VAL aparece en la categor\u00eda de conversi\u00f3n de tipo de datos de funciones VBA. Cuando lo usa en c\u00f3digo VBA, convierte una cadena en un n\u00famero. En t\u00e9rminos simples, toma un n\u00famero almacenado como una cadena y lo devuelve como un n\u00famero. Sintaxis Val(cadena) Argumentos Cadena : una cadena que desea convertir [&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-560","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 val?<\/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\/vale\/\" \/>\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 val?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA VAL aparece en la categor\u00eda de conversi\u00f3n de tipo de datos de funciones VBA. Cuando lo usa en c\u00f3digo VBA, convierte una cadena en un n\u00famero. En t\u00e9rminos simples, toma un n\u00famero almacenado como una cadena y lo devuelve como un n\u00famero. Sintaxis Val(cadena) Argumentos Cadena : una cadena que desea convertir [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/vale\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:31:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-val.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\/vale\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/vale\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba val?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/vale\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/vale\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-val.png\",\"datePublished\":\"2023-10-23T20:13:35+00:00\",\"dateModified\":\"2023-12-25T10:31:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/vale\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/vale\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/vale\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-val.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-val.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/vale\/#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 val?\"}]},{\"@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 val?","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\/vale\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba val?","og_description":"La funci\u00f3n VBA VAL aparece en la categor\u00eda de conversi\u00f3n de tipo de datos de funciones VBA. Cuando lo usa en c\u00f3digo VBA, convierte una cadena en un n\u00famero. En t\u00e9rminos simples, toma un n\u00famero almacenado como una cadena y lo devuelve como un n\u00famero. Sintaxis Val(cadena) Argumentos Cadena : una cadena que desea convertir [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/vale\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:31:23+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-val.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\/vale\/","url":"https:\/\/exceladvisor.org\/es\/vale\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba val?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/vale\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/vale\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-val.png","datePublished":"2023-10-23T20:13:35+00:00","dateModified":"2023-12-25T10:31:23+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/vale\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/vale\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/vale\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-val.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-val.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/vale\/#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 val?"}]},{"@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\/560","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=560"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/560\/revisions"}],"predecessor-version":[{"id":1357,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/560\/revisions\/1357"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}