{"id":467,"date":"2023-10-27T14:21:24","date_gmt":"2023-10-27T14:21:24","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/ocurre\/"},"modified":"2023-12-25T10:30:04","modified_gmt":"2023-12-25T10:30:04","slug":"ocurre","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/ocurre\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba ccur?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-850372717\"><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 CCUR figura en la categor\u00eda de conversi\u00f3n de tipo de datos de funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong>convierte un n\u00famero en un tipo de datos de moneda<\/strong> . En t\u00e9rminos simples, en el tipo de datos moneda tienes 15 d\u00edgitos a la izquierda del decimal y un m\u00e1ximo de 4 d\u00edgitos a la derecha del decimal (-922 337 203 685 477.5808 y 922 337 203 685 477.5807).<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>CCur(Expresi\u00f3n)<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>Expresi\u00f3n<\/strong> : el valor num\u00e9rico que desea convertir a un tipo de datos de moneda.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA CCUR, 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\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ccur.png\" sizes=\"auto, \" srcset=\"\" alt=\"ejemplo-vba-ccur-funci\u00f3n\" width=\"691\" height=\"524\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_CCUR() Range(\u201cB1\u201d).Value = CCur(Range(\u201cA1\u201d)) End Sub<\/code><\/pre>\n<p> En el ejemplo anterior, usamos el valor de la celda A1 donde tenemos un n\u00famero (8.5694), luego usamos la funci\u00f3n CCUR para convertir este valor al tipo de datos de moneda y devolvi\u00f3 8, $57 en el resultado.<\/p>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> Si el valor especificado es un valor distinto de un n\u00famero o un n\u00famero que no puede reconocerse como un n\u00famero, VBA devolver\u00e1 el error de tiempo de ejecuci\u00f3n 13.<\/li>\n<li> Y si el rango del valor proporcionado est\u00e1 fuera de -922.337.203.685.477,5808 a 922.337.203.685.477.5807, VBA devuelve el error de tiempo de ejecuci\u00f3n 6. <\/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-39\">\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\/fecha-c\/\">CDATE VBA<\/a><\/li>\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<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA CCUR figura en la categor\u00eda de conversi\u00f3n de tipo de datos de funciones VBA. Cuando lo usa en c\u00f3digo VBA, convierte un n\u00famero en un tipo de datos de moneda . En t\u00e9rminos simples, en el tipo de datos moneda tienes 15 d\u00edgitos a la izquierda del decimal y un m\u00e1ximo de [&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-467","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 ccur?<\/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\/ocurre\/\" \/>\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 ccur?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA CCUR figura en la categor\u00eda de conversi\u00f3n de tipo de datos de funciones VBA. Cuando lo usa en c\u00f3digo VBA, convierte un n\u00famero en un tipo de datos de moneda . En t\u00e9rminos simples, en el tipo de datos moneda tienes 15 d\u00edgitos a la izquierda del decimal y un m\u00e1ximo de [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/ocurre\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:30:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ccur.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\/ocurre\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/ocurre\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba ccur?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/ocurre\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/ocurre\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ccur.png\",\"datePublished\":\"2023-10-27T14:21:24+00:00\",\"dateModified\":\"2023-12-25T10:30:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/ocurre\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/ocurre\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/ocurre\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ccur.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ccur.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/ocurre\/#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 ccur?\"}]},{\"@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 ccur?","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\/ocurre\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba ccur?","og_description":"La funci\u00f3n VBA CCUR figura en la categor\u00eda de conversi\u00f3n de tipo de datos de funciones VBA. Cuando lo usa en c\u00f3digo VBA, convierte un n\u00famero en un tipo de datos de moneda . En t\u00e9rminos simples, en el tipo de datos moneda tienes 15 d\u00edgitos a la izquierda del decimal y un m\u00e1ximo de [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/ocurre\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:30:04+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ccur.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\/ocurre\/","url":"https:\/\/exceladvisor.org\/es\/ocurre\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba ccur?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/ocurre\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/ocurre\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ccur.png","datePublished":"2023-10-27T14:21:24+00:00","dateModified":"2023-12-25T10:30:04+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/ocurre\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/ocurre\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/ocurre\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ccur.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ccur.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/ocurre\/#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 ccur?"}]},{"@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\/467","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=467"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/467\/revisions"}],"predecessor-version":[{"id":1221,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/467\/revisions\/1221"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}