{"id":1685,"date":"2023-11-11T14:31:11","date_gmt":"2023-11-11T14:31:11","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/"},"modified":"2023-12-06T05:52:29","modified_gmt":"2023-12-06T05:52:29","slug":"willekeurig-nummer","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/","title":{"rendered":"Hoe willekeurige getallen genereren in vba?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-2688689161\"><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>In VBA kun je verschillende manieren gebruiken om een willekeurig getal in Excel te genereren, en in dit artikel zullen we ze allemaal \u00e9\u00e9n voor \u00e9\u00e9n bekijken.<\/p><h2 class=\"wp-block-heading\"> RND-functie<\/h2><p> Om een willekeurig getal te genereren, is er in VBA een functie genaamd <a href=\"https:\/\/exceladvisor.org\/nl\/rnd\/\">RND<\/a> . Deze functie betekent willekeurig en wanneer u deze functie in code gebruikt, retourneert deze een willekeurig getal tussen 0 en 1. In RND hoeft u geen enkel argument op te geven.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\") = Rnd()<\/code><\/pre><p> De bovenstaande code gebruikt het om een willekeurig getal in de A1 te krijgen en retourneert 0,705547521. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52247\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-generer-un-nombre-aleatoire-dans-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"genereer een willekeurig getal in vba\" width=\"511\" height=\"260\"><\/figure><\/div><p> Maar als je het voor een heel bereik gebruikt, retourneert het hetzelfde willekeurige getal in het hele bereik en dat maakt het null om meer dan eens willekeurige getallen te genereren. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52248\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-renvoie-le-meme-nombre-aleatoire.png\" sizes=\"auto, \" srcset=\"\" alt=\"retourneert hetzelfde willekeurige getal\" width=\"572\" height=\"368\"><\/figure><\/div><p> Nu, hier heeft het geen zin om het te gebruiken, nietwaar? Maar er is een oplossing die u kunt gebruiken: <a href=\"https:\/\/exceladvisor.org\/nl\/voor-de-lus\/\">FOR NEXT LOOP<\/a> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52249\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-utilisation-pour-la-boucle-suivante.png\" sizes=\"auto, \" srcset=\"\" alt=\"gebruiken voor de volgende lus\" width=\"583\" height=\"407\"><\/figure><\/div><p> In de bovenstaande code heb je een lus die door 10 cellen gaat (\u00e9\u00e9n voor \u00e9\u00e9n), beginnend bij de geselecteerde cel, en een willekeurig getal toevoegt.<\/p><p> Hier is de volledige code:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_random_number() Dim i As Long i = 10 For i = 1 To i ActiveCell.Value = Rnd() ActiveCell.Offset(1, 0).Select Next i End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Willekeurig getal tussen twee getallen<\/h2><p> Als u een willekeurig getal tussen twee gedefinieerde getallen wilt genereren, moet u in dit geval code schrijven met behulp van twee <a href=\"https:\/\/exceladvisor.org\/nl\/functies\/\">VBA-functies<\/a> ( <a href=\"https:\/\/exceladvisor.org\/nl\/rnd\/\">RND<\/a> + <a href=\"https:\/\/exceladvisor.org\/nl\/int\/\">INT<\/a> ). De code voor deze formule zou er als volgt uitzien. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52250\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-nombre-aleatoire-entre-deux-nombres.png\" sizes=\"auto, \" srcset=\"\" alt=\"willekeurig-getal-tussen-twee-getallen\" width=\"548\" height=\"293\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_random_number() Dim myRnd As Integer myRnd = Int(2 + Rnd * (45 - 10 + 1)) Range(\"A1\") = myRnd End Sub<\/code><\/pre><p> Wanneer u <a href=\"https:\/\/exceladvisor.org\/nl\/voer-een-macro-uit-2\/\">deze macro uitvoert<\/a> , gebruikt RND het maximum- en minimumaantal dat u hebt ingesteld om het willekeurige getal te genereren, en verwijdert INT de decimaal. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52251\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-rnd-utiliser-le-nombre-max-et-min.png\" sizes=\"auto, \" srcset=\"\" alt=\"rnd-gebruik-het-max-en-min-nummer\" width=\"421\" height=\"205\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Werkbladfuncties gebruiken in VBA-code om een willekeurig getal te genereren<\/h2><p> In VBA hebt u toegang tot <a href=\"https:\/\/exceladvisor.org\/nl\/spreadsheet-functie\/\">werkbladfuncties<\/a> en kunt u deze gebruiken om een resultaat te krijgen door de argumenten op te geven. Twee <a href=\"https:\/\/exceladvisor.org\/nl\/excel-functies\/\">spreadsheetfuncties<\/a> kunnen u helpen een willekeurig getal in het resultaat te krijgen.<\/p><ul><li> RandTussen<\/li><li> RandTableau<\/li><\/ul><p> Voordat u deze functies gebruikt, moet u ervoor zorgen dat u de argumenten begrijpt die u moet instellen. In de onderstaande code heb je nu RANDBETWEEN, wat een willekeurig getal tussen twee getallen genereert. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52252\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-utiliser-randbetween-genere-un-nombre-aleatoire-entre-deux-nombres.png\" sizes=\"auto, \" srcset=\"\" alt=\"gebruik-randtussen-genereert-een-willekeurig-getal-tussen-twee-getallen\" width=\"601\" height=\"213\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\") = WorksheetFunction.RandBetween(1000, 2000)<\/code><\/pre><p> Hier is het maximale aantal 2000 en het minimumaantal 1000. Op dezelfde manier kunt u de RANDARRAY gebruiken, een dynamische arrayfunctie.<\/p><p> Hier is de code. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:B10\") = WorksheetFunction.RandArray(10, 2, 1000, 2000, True)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52253\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-utilisez-randarray-qui-est-une-fonction-de-tableau-dynamique.png\" sizes=\"auto, \" srcset=\"\" alt=\"gebruik-randarray-wat-een-dynamische-array-functie is\" width=\"743\" height=\"275\"><\/figure><\/div><p> Als je naar de syntaxis van RANDARRAY kijkt, zul je merken dat je willekeurige getallen in een geheel getalbereik kunt invoeren, wat niet mogelijk is met alle methoden die we hierboven hebben besproken. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52254\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-syntaxe-de-randarray.png\" sizes=\"auto, \" srcset=\"\" alt=\"randarray-syntaxis\" width=\"396\" height=\"120\"><\/figure><\/div><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/nl\/vba\/\">Wat is VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Gerelateerde tutorials <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/gemiddeld-2\/\">Gemiddelde waarden in Excel met VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/de-datum-van-vandaag-huidige-tijd\/\">Ontvang de datum van vandaag en de huidige tijd met behulp van VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/som-1\/\">Somwaarden op in Excel met behulp van VBA<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/berekenen\/\">VBA-berekening<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/ketting-1\/\">Voeg VBA samen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/spreadsheet-functie\/\">VBA-spreadsheetfunctie<\/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-1685","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>\u25b7 Hoe willekeurige getallen genereren in VBA?<\/title>\n<meta name=\"description\" content=\"Deze zelfstudie laat u op verschillende manieren zien hoe u willekeurige getallen in Excel kunt genereren met behulp van VBA-code\" \/>\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\/nl\/willekeurig-nummer\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe willekeurige getallen genereren in VBA?\" \/>\n<meta property=\"og:description\" content=\"Deze zelfstudie laat u op verschillende manieren zien hoe u willekeurige getallen in Excel kunt genereren met behulp van VBA-code\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:52:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-generer-un-nombre-aleatoire-dans-vba.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/\",\"name\":\"\u25b7 Hoe willekeurige getallen genereren in VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-generer-un-nombre-aleatoire-dans-vba.png\",\"datePublished\":\"2023-11-11T14:31:11+00:00\",\"dateModified\":\"2023-12-06T05:52:29+00:00\",\"description\":\"Deze zelfstudie laat u op verschillende manieren zien hoe u willekeurige getallen in Excel kunt genereren met behulp van VBA-code\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-generer-un-nombre-aleatoire-dans-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-generer-un-nombre-aleatoire-dans-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe willekeurige getallen genereren in vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Hoe willekeurige getallen genereren in VBA?","description":"Deze zelfstudie laat u op verschillende manieren zien hoe u willekeurige getallen in Excel kunt genereren met behulp van VBA-code","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\/nl\/willekeurig-nummer\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe willekeurige getallen genereren in VBA?","og_description":"Deze zelfstudie laat u op verschillende manieren zien hoe u willekeurige getallen in Excel kunt genereren met behulp van VBA-code","og_url":"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:52:29+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-generer-un-nombre-aleatoire-dans-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/","url":"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/","name":"\u25b7 Hoe willekeurige getallen genereren in VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-generer-un-nombre-aleatoire-dans-vba.png","datePublished":"2023-11-11T14:31:11+00:00","dateModified":"2023-12-06T05:52:29+00:00","description":"Deze zelfstudie laat u op verschillende manieren zien hoe u willekeurige getallen in Excel kunt genereren met behulp van VBA-code","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-generer-un-nombre-aleatoire-dans-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-generer-un-nombre-aleatoire-dans-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe willekeurige getallen genereren in vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1685"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1685\/revisions"}],"predecessor-version":[{"id":2905,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1685\/revisions\/2905"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}