{"id":3469,"date":"2023-10-25T07:45:56","date_gmt":"2023-10-25T07:45:56","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/int\/"},"modified":"2023-12-03T13:06:12","modified_gmt":"2023-12-03T13:06:12","slug":"int","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/int\/","title":{"rendered":"Wie verwende ich die vba int-funktion?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-1050839700\"><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>Die VBA-INT-Funktion ist in der mathematischen Kategorie der VBA-Funktionen aufgef\u00fchrt. Wenn Sie es im VBA-Code verwenden, <strong>kann es eine Zahl auf eine Ganzzahl runden<\/strong> . Vereinfacht ausgedr\u00fcckt rundet es eine positive Zahl in Richtung Null und eine negative Zahl von Null weg. Es funktioniert einfach wie die INT-Funktion in der <a href=\"https:\/\/exceladvisor.org\/de\/a\/\">Tabellenkalkulation<\/a> .<\/p><h2 class=\"wp-block-heading\"> Syntax<\/h2><p> <strong>Int(Zahl)<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumente<\/h2><ul><li> <strong>Zahl<\/strong> : Der numerische Wert, dessen ganzzahliger Teil Sie m\u00f6chten.<\/li><\/ul><h2 class=\"wp-block-heading\"> Beispiel<\/h2><p> Um die Verwendung der VBA-INT-Funktion praktisch zu verstehen, m\u00fcssen Sie das folgende Beispiel durchgehen, in dem wir damit einen VBA-Code geschrieben haben: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"Beispiel-vba-int-Funktion\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-int.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-int-function\" width=\"666\" height=\"380\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_INT() Range(\"B1\").Value = Int(Range(\"A1\")) End Sub<\/code><\/pre><p> Im obigen Code haben wir INT verwendet, um den ganzzahligen Teil des Werts (13,54) in Zelle A1 abzurufen und das Ergebnis in Zelle B1 zur\u00fcckzugeben. Und wenn wir den Code ausf\u00fchren, gibt er in Zelle B1 13 zur\u00fcck.<\/p><h2 class=\"wp-block-heading\"> Kommentare<\/h2><ul><li> Wenn der angegebene Wert ein anderer Wert als eine Zahl oder eine Zeichenfolge ist, die nicht als Zahl erkannt werden kann, gibt VBA den Laufzeitfehler 13 zur\u00fcck.<\/li><li> Wenn die angegebene Zahl positiv ist, wird sie in Richtung Null gerundet. Wenn die angegebene Zahl negativ ist, wird von Null weggerundet. <\/li><\/ul><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Weitere Tutorials <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-232\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/bauchmuskeln-1\/\">ABS VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/atn\/\">ATN VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/cos\/\">Weil VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/exp\/\">VBA-ERFAHRUNG<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/fix\/\">VBA-FIX<\/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-3469","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>Wie verwende ich die VBA INT-Funktion? (Syntax + Beispiel)<\/title>\n<meta name=\"description\" content=\"Erfahren Sie, wie Sie die VBA-INT-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.\" \/>\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\/de\/int\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie verwende ich die VBA INT-Funktion? (Syntax + Beispiel)\" \/>\n<meta property=\"og:description\" content=\"Erfahren Sie, wie Sie die VBA-INT-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/int\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:06:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-int.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/int\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/int\/\",\"name\":\"Wie verwende ich die VBA INT-Funktion? (Syntax + Beispiel)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/int\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/int\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-int.png\",\"datePublished\":\"2023-10-25T07:45:56+00:00\",\"dateModified\":\"2023-12-03T13:06:12+00:00\",\"description\":\"Erfahren Sie, wie Sie die VBA-INT-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/int\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/int\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/int\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-int.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-int.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/int\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie verwende ich die vba int-funktion?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wie verwende ich die VBA INT-Funktion? (Syntax + Beispiel)","description":"Erfahren Sie, wie Sie die VBA-INT-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.","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\/de\/int\/","og_locale":"de_DE","og_type":"article","og_title":"Wie verwende ich die VBA INT-Funktion? (Syntax + Beispiel)","og_description":"Erfahren Sie, wie Sie die VBA-INT-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.","og_url":"https:\/\/exceladvisor.org\/de\/int\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:06:12+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-int.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/int\/","url":"https:\/\/exceladvisor.org\/de\/int\/","name":"Wie verwende ich die VBA INT-Funktion? (Syntax + Beispiel)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/int\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/int\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-int.png","datePublished":"2023-10-25T07:45:56+00:00","dateModified":"2023-12-03T13:06:12+00:00","description":"Erfahren Sie, wie Sie die VBA-INT-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/int\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/int\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/int\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-int.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-int.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/int\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie verwende ich die vba int-funktion?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3469","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3469"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3469\/revisions"}],"predecessor-version":[{"id":4262,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3469\/revisions\/4262"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}