{"id":3516,"date":"2023-10-24T01:21:23","date_gmt":"2023-10-24T01:21:23","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/runde\/"},"modified":"2023-12-03T13:04:19","modified_gmt":"2023-12-03T13:04:19","slug":"runde","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/runde\/","title":{"rendered":"Wie verwende ich die vba-rnd-funktion?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-3890503527\"><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-RND-Funktion ist in der mathematischen Kategorie der VBA-Funktionen aufgef\u00fchrt. Wenn Sie es im VBA-Code verwenden, <strong>generiert es eine Zufallszahl<\/strong> gr\u00f6\u00dfer oder gleich Null und kleiner oder gleich 1. Vereinfacht ausgedr\u00fcckt gibt es eine Zufallszahl zwischen 0 und 1 zur\u00fcck. Es funktioniert wie die RAND-Funktion im <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/de\/a\/\">Arbeitsblatt<\/a> .<\/p><h2 class=\"wp-block-heading\"> Syntax<\/h2><p> <strong>Rnd([Anzahl])<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumente<\/h2><ul><li> <strong>[Zahl]<\/strong> : Ein optionales numerisches Argument, in dem Sie Folgendes angeben k\u00f6nnen: [Dies ist ein optionales Argument, und wenn es weggelassen wird, nimmt VBA standardm\u00e4\u00dfig &gt;0 an]:<ol><li> &lt;0, um bei jedem Anruf die gleiche Zufallszahl zu erhalten, wobei [Number] als Startnummer verwendet wird.<\/li><li> =0, um die zuletzt generierte Zufallszahl zu erhalten.<\/li><li> &gt;0, um die n\u00e4chste Zufallszahl in der Sequenz zu erhalten.<\/li><\/ol><\/li><\/ul><h2 class=\"wp-block-heading\"> Beispiel<\/h2><p> Um die Verwendung der VBA-RND-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-rnd-Funktion\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-rnd.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-rnd-function\" width=\"629\" height=\"398\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_RND() Range(\"A1\").Value = Rnd() Range(\"A2\").Value = Rnd() Range(\"A3\").Value = Rnd() End Sub<\/code><\/pre><p> Im obigen Code haben wir RND verwendet, um Zufallszahlen in A1, A2 und A3 zu erhalten. Und wenn wir das noch einmal ausf\u00fchren, werden die unterschiedlichen Zahlen in den drei Zellen zur\u00fcckgegeben. <\/p><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-112\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/runden\/\">VBA-RUNDE<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/sgn\/\">SGN VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/sunde\/\">NAS-VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/qm\/\">VBA SQR<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/braunen\/\">VBA-TAN<\/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-3516","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-RND-Funktion? (Syntax + Beispiel)<\/title>\n<meta name=\"description\" content=\"Erfahren Sie, wie Sie die VBA-RND-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\/runde\/\" \/>\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-RND-Funktion? (Syntax + Beispiel)\" \/>\n<meta property=\"og:description\" content=\"Erfahren Sie, wie Sie die VBA-RND-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/runde\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:04:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-rnd.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\/runde\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/runde\/\",\"name\":\"Wie verwende ich die VBA-RND-Funktion? (Syntax + Beispiel)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/runde\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/runde\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-rnd.png\",\"datePublished\":\"2023-10-24T01:21:23+00:00\",\"dateModified\":\"2023-12-03T13:04:19+00:00\",\"description\":\"Erfahren Sie, wie Sie die VBA-RND-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/runde\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/runde\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/runde\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-rnd.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-rnd.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/runde\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie verwende ich die vba-rnd-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-RND-Funktion? (Syntax + Beispiel)","description":"Erfahren Sie, wie Sie die VBA-RND-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\/runde\/","og_locale":"de_DE","og_type":"article","og_title":"Wie verwende ich die VBA-RND-Funktion? (Syntax + Beispiel)","og_description":"Erfahren Sie, wie Sie die VBA-RND-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.","og_url":"https:\/\/exceladvisor.org\/de\/runde\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:04:19+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-rnd.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\/runde\/","url":"https:\/\/exceladvisor.org\/de\/runde\/","name":"Wie verwende ich die VBA-RND-Funktion? (Syntax + Beispiel)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/runde\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/runde\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-rnd.png","datePublished":"2023-10-24T01:21:23+00:00","dateModified":"2023-12-03T13:04:19+00:00","description":"Erfahren Sie, wie Sie die VBA-RND-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/runde\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/runde\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/runde\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-rnd.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-rnd.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/runde\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie verwende ich die vba-rnd-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\/3516","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=3516"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3516\/revisions"}],"predecessor-version":[{"id":4329,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3516\/revisions\/4329"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}