{"id":1955,"date":"2023-10-26T11:48:28","date_gmt":"2023-10-26T11:48:28","guid":{"rendered":"https:\/\/exceladvisor.org\/it\/data-2\/"},"modified":"2023-12-10T06:26:54","modified_gmt":"2023-12-10T06:26:54","slug":"data-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/it\/data-2\/","title":{"rendered":"Come utilizzare la funzione data vba?"},"content":{"rendered":"<div class=\"excel-prima-del-contenuto\" id=\"excel-1534757745\"><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 DATA VBA \u00e8 elencata nella categoria data delle funzioni VBA. Quando lo usi nel codice VBA, restituisce la data corrente secondo il sistema. \u00c8 come la <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/it\/funzioni-di-data-excel\/\">funzione OGGI<\/a> che usi nel foglio di calcolo. La data restituita ha il formato mm\/gg\/aaaa o qualunque formato tu definisca.<\/p><h2 class=\"wp-block-heading\"> Sintassi<\/h2><p> <strong>Data()<\/strong><\/p><h2 class=\"wp-block-heading\"> argomenti<\/h2><ul><li> Non ci sono argomenti da definire nella funzione.<\/li><\/ul><h2 class=\"wp-block-heading\"> Esempio<\/h2><p> Per capire praticamente come utilizzare la funzione DATA 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-data-esempio-vba\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-date-function\" width=\"782\" height=\"538\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_DATE() Range(\"A1\").Value = Date End Sub<\/code><\/pre><p> Nell&#8217;esempio sopra, abbiamo utilizzato la funzione DATA per inserire la data corrente nella cella A1.<\/p><p> A differenza della funzione OGGI (che puoi utilizzare nel foglio di calcolo), la data inserita dalla funzione DATA VBA non \u00e8 volatile. Pertanto, se si desidera reinserire la data corrente, \u00e8 necessario eseguire nuovamente il codice. <\/p><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-308\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/it\/dataadd\/\">DATA VBAAGGIUNGI<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/datepart\/\">DATEPARTS VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/dateserial\/\">DATARIE VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/valoredata\/\">VALORE DATA VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/giorno\/\">GIORNATA 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-1955","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 DATA VBA? (Sintassi + Esempio)<\/title>\n<meta name=\"description\" content=\"Scopri come utilizzare la funzione DATA VBA 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\/data-2\/\" \/>\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 DATA VBA? (Sintassi + Esempio)\" \/>\n<meta property=\"og:description\" content=\"Scopri come utilizzare la funzione DATA VBA con sintassi, argomenti ed esempio con codice di esempio.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/it\/data-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:26:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.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\/data-2\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/data-2\/\",\"name\":\"Come utilizzare la funzione DATA VBA? (Sintassi + Esempio)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/data-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/data-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.png\",\"datePublished\":\"2023-10-26T11:48:28+00:00\",\"dateModified\":\"2023-12-10T06:26:54+00:00\",\"description\":\"Scopri come utilizzare la funzione DATA VBA con sintassi, argomenti ed esempio con codice di esempio.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/data-2\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/it\/data-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/data-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/it\/data-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceladvisor.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Come utilizzare la funzione data vba?\"}]},{\"@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 DATA VBA? (Sintassi + Esempio)","description":"Scopri come utilizzare la funzione DATA VBA 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\/data-2\/","og_locale":"it_IT","og_type":"article","og_title":"Come utilizzare la funzione DATA VBA? (Sintassi + Esempio)","og_description":"Scopri come utilizzare la funzione DATA VBA con sintassi, argomenti ed esempio con codice di esempio.","og_url":"https:\/\/exceladvisor.org\/it\/data-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:26:54+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.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\/data-2\/","url":"https:\/\/exceladvisor.org\/it\/data-2\/","name":"Come utilizzare la funzione DATA VBA? (Sintassi + Esempio)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/it\/data-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/data-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.png","datePublished":"2023-10-26T11:48:28+00:00","dateModified":"2023-12-10T06:26:54+00:00","description":"Scopri come utilizzare la funzione DATA VBA con sintassi, argomenti ed esempio con codice di esempio.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/it\/data-2\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/it\/data-2\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/data-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-date-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/it\/data-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceladvisor.org\/it\/"},{"@type":"ListItem","position":2,"name":"Come utilizzare la funzione data vba?"}]},{"@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\/1955","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=1955"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1955\/revisions"}],"predecessor-version":[{"id":2850,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1955\/revisions\/2850"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/media?parent=1955"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}