{"id":4401,"date":"2023-07-11T09:37:37","date_gmt":"2023-07-11T09:37:37","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-rand-masuk\/"},"modified":"2023-07-11T09:37:37","modified_gmt":"2023-07-11T09:37:37","slug":"vba-rand-masuk","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-rand-masuk\/","title":{"rendered":"Vba: cara menggunakan randbetween untuk menghasilkan angka acak"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode <b>RandBetween<\/b> di VBA untuk menghasilkan bilangan bulat acak antara dua nilai tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut dua cara umum untuk menggunakan metode ini dalam praktik:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Gunakan RandBetween untuk Menghasilkan Integer Acak<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubGenerateRandomInteger<\/span> ()\nRange(\" <span style=\"color: #ff0000;\">A1<\/span> \") = WorksheetFunction.RandBetween(1, 100)\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan menghasilkan bilangan bulat acak antara 1 dan 100 di sel <strong>A1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Gunakan RandBetween untuk Menghasilkan Beberapa Bilangan Bulat Acak<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> GenerateMultipleRandomIntegers()\n\n    <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n    \n    <span style=\"color: #0000ff;\">For<\/span> i = 1 <span style=\"color: #0000ff;\">To<\/span> 10\n        Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i) = WorksheetFunction.RandBetween(1, 100)\n    <span style=\"color: #0000ff;\">Next<\/span> i\n    \n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan menghasilkan bilangan bulat acak antara 1 dan 100 untuk setiap sel dalam rentang <strong>A1:A10<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode ini dalam praktik.<\/span><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Gunakan RandBetween untuk menghasilkan bilangan bulat acak<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin membuat angka acak antara 1 dan 100 dan menempatkan hasilnya di sel <strong>A1<\/strong> pada lembar kita saat ini di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubGenerateRandomInteger<\/span> ()\nRange(\" <span style=\"color: #ff0000;\">A1<\/span> \") = WorksheetFunction.RandBetween(1, 100)\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34517 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rb11.jpg\" alt=\"\" width=\"476\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa sel <b>A1<\/b> berisi nilai <strong>36<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa setiap kali kita menjalankan makro ini, nilai integer yang berbeda antara 1 dan 100 dapat dihasilkan.<\/span><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Gunakan RandBetween untuk menghasilkan beberapa bilangan bulat acak<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin membuat bilangan bulat acak antara 1 dan 100 untuk setiap sel dalam rentang <strong>A1:A10<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> GenerateMultipleRandomIntegers()\n\n    <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n    \n    <span style=\"color: #0000ff;\">For<\/span> i = 1 <span style=\"color: #0000ff;\">To<\/span> 10\n        Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i) = WorksheetFunction.RandBetween(1, 100)\n    <span style=\"color: #0000ff;\">Next<\/span> i\n    \n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34518 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rb12.jpg\" alt=\"\" width=\"487\" height=\"377\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa setiap sel dalam rentang <strong>A1:A10<\/strong> berisi bilangan bulat acak antara 1 dan 100.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk metode <b>RandBetween<\/b> VBA <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.worksheetfunction.randbetween\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/rata-rata-vba-jika\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menulis fungsi AVERAGEIF dan AVERAGEIFS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlah-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menulis fungsi SUMIF dan SUMIFS<\/a><br \/> VBA: Cara menulis fungsi COUNTIF dan COUNTIFS<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode RandBetween di VBA untuk menghasilkan bilangan bulat acak antara dua nilai tertentu. Berikut dua cara umum untuk menggunakan metode ini dalam praktik: Metode 1: Gunakan RandBetween untuk Menghasilkan Integer Acak SubGenerateRandomInteger () Range(&#8221; A1 &#8220;) = WorksheetFunction.RandBetween(1, 100) End Sub Makro khusus ini akan menghasilkan bilangan bulat acak antara 1 dan [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA: Cara menggunakan RandBetween untuk menghasilkan angka acak - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan metode RandBetween di VBA untuk menghasilkan nilai acak antara dua nilai tertentu, beserta contohnya.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/vba-rand-masuk\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menggunakan RandBetween untuk menghasilkan angka acak - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan metode RandBetween di VBA untuk menghasilkan nilai acak antara dua nilai tertentu, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-rand-masuk\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T09:37:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rb11.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/vba-rand-masuk\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-rand-masuk\/\",\"name\":\"VBA: Cara menggunakan RandBetween untuk menghasilkan angka acak - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T09:37:37+00:00\",\"dateModified\":\"2023-07-11T09:37:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan metode RandBetween di VBA untuk menghasilkan nilai acak antara dua nilai tertentu, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-rand-masuk\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-rand-masuk\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-rand-masuk\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menggunakan randbetween untuk menghasilkan angka acak\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA: Cara menggunakan RandBetween untuk menghasilkan angka acak - Statorials","description":"Tutorial ini menjelaskan cara menggunakan metode RandBetween di VBA untuk menghasilkan nilai acak antara dua nilai tertentu, beserta contohnya.","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:\/\/statorials.org\/id\/vba-rand-masuk\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menggunakan RandBetween untuk menghasilkan angka acak - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan metode RandBetween di VBA untuk menghasilkan nilai acak antara dua nilai tertentu, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/vba-rand-masuk\/","og_site_name":"Statorials","article_published_time":"2023-07-11T09:37:37+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rb11.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/vba-rand-masuk\/","url":"https:\/\/statorials.org\/id\/vba-rand-masuk\/","name":"VBA: Cara menggunakan RandBetween untuk menghasilkan angka acak - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T09:37:37+00:00","dateModified":"2023-07-11T09:37:37+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan metode RandBetween di VBA untuk menghasilkan nilai acak antara dua nilai tertentu, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-rand-masuk\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-rand-masuk\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-rand-masuk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menggunakan randbetween untuk menghasilkan angka acak"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4401"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4401"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4401\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}