{"id":1946,"date":"2023-10-26T13:46:07","date_gmt":"2023-10-26T13:46:07","guid":{"rendered":"https:\/\/exceladvisor.org\/it\/cdec\/"},"modified":"2023-12-10T06:25:37","modified_gmt":"2023-12-10T06:25:37","slug":"cdec","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/it\/cdec\/","title":{"rendered":"Come utilizzare la funzione vba cdec?"},"content":{"rendered":"<div class=\"excel-prima-del-contenuto\" id=\"excel-1341897742\"><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 funzione VBA CDEC \u00e8 elencata nella categoria di conversione del tipo di dati delle funzioni VBA. Quando lo usi nel codice VBA, <strong>converte un numero in un<\/strong> tipo di dati decimale. In termini semplici, con il tipo di dati decimale, un numero pu\u00f2 avere 28 posizioni decimali in cui il valore pi\u00f9 grande \u00e8 +\/-7,9228162514264337593543950335 e il valore pi\u00f9 piccolo diverso da zero \u00e8 +\/-0,0000000000000000000000000001.<\/p><h2 class=\"wp-block-heading\"> Sintassi<\/h2><p> <strong>CDec(Espressione)<\/strong><\/p><h2 class=\"wp-block-heading\"> argomenti<\/h2><ul><li> <strong>Espressione<\/strong> : il valore che desideri convertire in un tipo di dati decimale.<\/li><\/ul><h2 class=\"wp-block-heading\"> Esempio<\/h2><p> Per capire praticamente come utilizzare la funzione CDEC VBA \u00e8 necessario seguire l&#8217;esempio seguente in cui abbiamo scritto un codice vba utilizzandola: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"funzione-vba-cdec-esempio\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdec.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-cdec-function\" width=\"840\" height=\"467\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_CDEC() Range(\"B1\").Value = CDec(Range(\"A1\") \/ Range(\"A2\")) End Sub<\/code><\/pre><p> Nell&#8217;esempio precedente, abbiamo diviso il valore della cella A1 (10) con il valore della cella A2 (9), quindi abbiamo utilizzato la funzione CDEC per convertire questo valore nel tipo di dati decimale e nel risultato \u00e8 stato restituito 1.11111111111111.<\/p><h2 class=\"wp-block-heading\"> Commenti<\/h2><ul><li> Se il valore specificato \u00e8 un valore diverso da un numero o un numero che non pu\u00f2 essere riconosciuto come numero, VBA restituir\u00e0 l&#8217;errore di runtime 13.<\/li><li> Restituir\u00e0 inoltre un errore se il valore fornito non \u00e8 compreso nell&#8217;intervallo del tipo di dati decimale. <\/li><\/ul><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Altri tutorial <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-27\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/it\/cdbl\/\">VBACDBL<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/chr\/\">VBA CHR<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/cint\/\">VBA CINT<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/aggrapparsi\/\">CLNG VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/csng\/\">CSNG VBA<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","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-1946","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>Come utilizzare la funzione VBA CDEC? (Sintassi + Esempio)<\/title>\n<meta name=\"description\" content=\"Scopri come utilizzare la funzione VBA CDEC con sintassi, argomenti ed esempio con codice di esempio.\" \/>\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\/it\/cdec\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Come utilizzare la funzione VBA CDEC? (Sintassi + Esempio)\" \/>\n<meta property=\"og:description\" content=\"Scopri come utilizzare la funzione VBA CDEC con sintassi, argomenti ed esempio con codice di esempio.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/it\/cdec\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:25:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdec.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo di lettura stimato\" \/>\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\/it\/cdec\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/cdec\/\",\"name\":\"Come utilizzare la funzione VBA CDEC? (Sintassi + Esempio)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/cdec\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/cdec\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdec.png\",\"datePublished\":\"2023-10-26T13:46:07+00:00\",\"dateModified\":\"2023-12-10T06:25:37+00:00\",\"description\":\"Scopri come utilizzare la funzione VBA CDEC con sintassi, argomenti ed esempio con codice di esempio.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/cdec\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/it\/cdec\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/cdec\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdec.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdec.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/it\/cdec\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceladvisor.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Come utilizzare la funzione vba cdec?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"name\":\"Excel Advisor\",\"description\":\"Tips, Tricks, and Time-Saving Hacks\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/it\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Come utilizzare la funzione VBA CDEC? (Sintassi + Esempio)","description":"Scopri come utilizzare la funzione VBA CDEC con sintassi, argomenti ed esempio con codice di esempio.","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\/it\/cdec\/","og_locale":"it_IT","og_type":"article","og_title":"Come utilizzare la funzione VBA CDEC? (Sintassi + Esempio)","og_description":"Scopri come utilizzare la funzione VBA CDEC con sintassi, argomenti ed esempio con codice di esempio.","og_url":"https:\/\/exceladvisor.org\/it\/cdec\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:25:37+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdec.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo di lettura stimato":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/it\/cdec\/","url":"https:\/\/exceladvisor.org\/it\/cdec\/","name":"Come utilizzare la funzione VBA CDEC? (Sintassi + Esempio)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/it\/cdec\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/cdec\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdec.png","datePublished":"2023-10-26T13:46:07+00:00","dateModified":"2023-12-10T06:25:37+00:00","description":"Scopri come utilizzare la funzione VBA CDEC con sintassi, argomenti ed esempio con codice di esempio.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/it\/cdec\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/it\/cdec\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/cdec\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdec.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdec.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/it\/cdec\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceladvisor.org\/it\/"},{"@type":"ListItem","position":2,"name":"Come utilizzare la funzione vba cdec?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/it\/#website","url":"https:\/\/exceladvisor.org\/it\/","name":"Excel Advisor","description":"Tips, Tricks, and Time-Saving Hacks","publisher":{"@id":"https:\/\/exceladvisor.org\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/it\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/it\/","logo":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1946","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/comments?post=1946"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1946\/revisions"}],"predecessor-version":[{"id":2695,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1946\/revisions\/2695"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/media?parent=1946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}