{"id":477,"date":"2023-10-26T13:07:35","date_gmt":"2023-10-26T13:07:35","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/aferrarse\/"},"modified":"2023-12-25T10:30:10","modified_gmt":"2023-12-25T10:30:10","slug":"aferrarse","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/aferrarse\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba clng?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2646977000\"><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 CLNG figura en la categor\u00eda de conversi\u00f3n de tipo de datos de funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong>convierte una expresi\u00f3n en un tipo de datos largo<\/strong> . En t\u00e9rminos simples, en VBA, el valor del tipo de datos largo puede estar entre -2.147.483.648 y 2.147.483.647 (sin decimales).<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>CLng(Expresi\u00f3n)<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>Expresi\u00f3n<\/strong> : el valor que desea convertir a un tipo de datos largo.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA CLNG, 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-clng-funci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-clng.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-clng-function\" width=\"845\" height=\"487\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_CLNG() Range(\"B1\").Value = CLng(Range(\"A1\")) End Sub<\/code><\/pre>\n<p> En el ejemplo anterior, usamos el valor de la celda A1 (134.567), luego usamos la funci\u00f3n CLNG para convertir este valor a un tipo de datos largo y devolvi\u00f3 135 en el resultado.<\/p>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> CLNG redondear\u00e1 este n\u00famero a 0,5 y redondear\u00e1 hacia abajo si es menor o igual a 0,5.<\/li>\n<li> Si proporciona un n\u00famero que est\u00e1 fuera del rango del tipo de datos largos (- 2.1 E+9 y 2.1 E+9), VBA devolver\u00e1 el error de tiempo de ejecuci\u00f3n 13. <\/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-15\">\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ctr\/\">VBA CSTR<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cvar\/\">CVAR-VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/formato-moneda\/\">FORMATO VBAM<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/formatofechahora\/\">FORMATO VBADATIME<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/numero-de-formato\/\">N\u00daMERO DE FORMATO VBA<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA CLNG figura en la categor\u00eda de conversi\u00f3n de tipo de datos de funciones VBA. Cuando lo usa en c\u00f3digo VBA, convierte una expresi\u00f3n en un tipo de datos largo . En t\u00e9rminos simples, en VBA, el valor del tipo de datos largo puede estar entre -2.147.483.648 y 2.147.483.647 (sin decimales). Sintaxis CLng(Expresi\u00f3n) [&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-477","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 clng?<\/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\/aferrarse\/\" \/>\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 clng?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA CLNG figura en la categor\u00eda de conversi\u00f3n de tipo de datos de funciones VBA. Cuando lo usa en c\u00f3digo VBA, convierte una expresi\u00f3n en un tipo de datos largo . En t\u00e9rminos simples, en VBA, el valor del tipo de datos largo puede estar entre -2.147.483.648 y 2.147.483.647 (sin decimales). Sintaxis CLng(Expresi\u00f3n) [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/aferrarse\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:30:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-clng.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\/aferrarse\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/aferrarse\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba clng?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/aferrarse\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/aferrarse\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-clng.png\",\"datePublished\":\"2023-10-26T13:07:35+00:00\",\"dateModified\":\"2023-12-25T10:30:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/aferrarse\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/aferrarse\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/aferrarse\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-clng.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-clng.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/aferrarse\/#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 clng?\"}]},{\"@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 clng?","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\/aferrarse\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba clng?","og_description":"La funci\u00f3n VBA CLNG figura en la categor\u00eda de conversi\u00f3n de tipo de datos de funciones VBA. Cuando lo usa en c\u00f3digo VBA, convierte una expresi\u00f3n en un tipo de datos largo . En t\u00e9rminos simples, en VBA, el valor del tipo de datos largo puede estar entre -2.147.483.648 y 2.147.483.647 (sin decimales). Sintaxis CLng(Expresi\u00f3n) [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/aferrarse\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:30:10+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-clng.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\/aferrarse\/","url":"https:\/\/exceladvisor.org\/es\/aferrarse\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba clng?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/aferrarse\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/aferrarse\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-clng.png","datePublished":"2023-10-26T13:07:35+00:00","dateModified":"2023-12-25T10:30:10+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/aferrarse\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/aferrarse\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/aferrarse\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-clng.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-clng.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/aferrarse\/#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 clng?"}]},{"@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\/477","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=477"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/477\/revisions"}],"predecessor-version":[{"id":1233,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/477\/revisions\/1233"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}