{"id":4775,"date":"2023-07-08T01:58:55","date_gmt":"2023-07-08T01:58:55","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-mengembalikan-array-dari-fungsi\/"},"modified":"2023-07-08T01:58:55","modified_gmt":"2023-07-08T01:58:55","slug":"vba-mengembalikan-array-dari-fungsi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-mengembalikan-array-dari-fungsi\/","title":{"rendered":"Vba: cara mengembalikan array dari suatu fungsi"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk mengembalikan array dari suatu fungsi di VBA:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Function<\/span> GenerateRandom() <span style=\"color: #0000ff;\">As<\/span> Integer()\n\n    Dim RandValues(2) <span style=\"color: #0000ff;\">As<\/span> Integer\n     \n    <span style=\"color: #008000;\">'generate three random integers and store them in array<\/span> \n    RandValues(0) = Int(Rnd * 100)\n    RandValues(1) = Int(Rnd * 100)\n    RandValues(2) = Int(Rnd * 100)\n    \n    <span style=\"color: #008000;\">'return array as a result of the function<\/span>\n    GenerateRandom = RandValues\n\n<span style=\"color: #0000ff;\">End Function\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menghasilkan tiga bilangan bulat acak, menyimpannya dalam array, dan kemudian mengembalikan array tersebut sebagai hasil dari fungsi yang disebut <strong>GenerateRandom()<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara mengembalikan nilai dari fungsi ini dengan dua cara berbeda:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Kembalikan nilai ke kotak pesan<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kembalikan nilai dalam sel<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Ayo pergi!<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Mengembalikan array dari suatu fungsi dan menampilkan nilainya di kotak pesan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk membuat fungsi bernama <strong>GenerateRandom()<\/strong> yang menghasilkan array tiga bilangan bulat acak, lalu menampilkan bilangan bulat tersebut dalam kotak pesan menggunakan fungsi <strong>MsgBox<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\"><span style=\"color: #008000;\">'define function to generate array of three random integers<\/span>\nFunction<\/span> GenerateRandom() <span style=\"color: #0000ff;\">As<\/span> Integer()\n\n    Dim RandValues(2) <span style=\"color: #0000ff;\">As<\/span> Integer\n     \n    RandValues(0) = Int(Rnd * 100)\n    RandValues(1) = Int(Rnd * 100)\n    RandValues(2) = Int(Rnd * 100)\n    \n    GenerateRandom = RandValues\n\n<span style=\"color: #0000ff;\">End Function\n\n<span style=\"color: #008000;\">'define sub to display values from function in a message box\n<\/span><span style=\"color: #000000;\"><span style=\"color: #0000ff;\">SubDisplayRandom<\/span> ()\n\n     <span style=\"color: #0000ff;\">Dim<\/span> WS <span style=\"color: #0000ff;\">As<\/span> Worksheet\n     <span style=\"color: #0000ff;\">Dim<\/span> RandomValues() <span style=\"color: #0000ff;\">As<\/span> Integer\n     <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n\n     <span style=\"color: #0000ff;\">Set<\/span> WS = Worksheets(\" <span style=\"color: #ff0000;\">Sheet1<\/span> \")\n     RandomValues = GenerateRandom()\n\n     j = \" <span style=\"color: #ff0000;\">Array values:<\/span> \"\n     <span style=\"color: #0000ff;\">For<\/span> i = 0 <span style=\"color: #0000ff;\">To<\/span> 2\n          j = (j &amp; RandomValues(i) &amp; \" \")\n     <span style=\"color: #0000ff;\">Next<\/span> i\n     MsgBox j\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/span><\/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=\"aligncenter wp-image-37283\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableaure1.png\" alt=\"VBA mengembalikan tabel fungsi\" width=\"304\" height=\"274\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa fungsi tersebut mengembalikan bilangan bulat acak <strong>96<\/strong> , <strong>87<\/strong> dan <strong>5<\/strong> dalam kotak pesan.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Mengembalikan array dari suatu fungsi dan menampilkan nilai dalam sel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan sintaks berikut untuk membuat fungsi bernama <strong>GenerateRandom()<\/strong> yang menghasilkan array tiga bilangan bulat acak dan kemudian menampilkan bilangan bulat yang dimulai dari sel <strong>A1<\/strong> di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\"><span style=\"color: #008000;\">'define function to generate array of three random integers<\/span>\nFunction<\/span> GenerateRandom() <span style=\"color: #0000ff;\">As<\/span> Integer()\n\n    Dim RandValues(2) <span style=\"color: #0000ff;\">As<\/span> Integer\n     \n    RandValues(0) = Int(Rnd * 100)\n    RandValues(1) = Int(Rnd * 100)\n    RandValues(2) = Int(Rnd * 100)\n    \n    GenerateRandom = RandValues\n\n<span style=\"color: #0000ff;\">End Function\n\n<span style=\"color: #008000;\">'define sub to display values from function starting in cell A1\n<\/span><span style=\"color: #000000;\"><span style=\"color: #0000ff;\">SubDisplayRandom<\/span> ()\n<span style=\"color: #0000ff;\">\n     Dim<\/span> WS <span style=\"color: #0000ff;\">As<\/span> Worksheet\n     <span style=\"color: #0000ff;\">Dim<\/span> RandomValues() <span style=\"color: #0000ff;\">As<\/span> Integer\n     <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n\n     <span style=\"color: #0000ff;\">Set<\/span> WS = Worksheets(\" <span style=\"color: #ff0000;\">Sheet1<\/span> \")\n     RandomValues = GenerateRandom()\n\n     <span style=\"color: #0000ff;\">For<\/span> i = 0 <span style=\"color: #0000ff;\">To<\/span> 2\n          WS.Range(\" <span style=\"color: #ff0000;\">A1<\/span> \").Offset(i, 0).Value = RandomValues(i)\n     <span style=\"color: #0000ff;\">Next<\/span> i\n<span style=\"color: #0000ff;\">\nEnd Sub\n<\/span><\/span><\/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-37284 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableaure2.png\" alt=\"\" width=\"452\" height=\"387\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa fungsi tersebut mengembalikan bilangan bulat acak <strong>96<\/strong> , <strong>87<\/strong> , dan <strong>5<\/strong> dari sel <strong>A1<\/strong> lembar kerja kita.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Untuk mengembalikan nilai tabel yang dimulai pada sel yang berbeda, cukup ganti <strong>A1<\/strong> dalam kode dengan referensi sel yang berbeda.<\/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> <a href=\"https:\/\/statorials.org\/id\/kembali-dari-fungsi-vba\/\" target=\"_blank\" rel=\"noopener\">Cara mengembalikan nilai dari fungsi VBA<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-sel-dari-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">Cara mendapatkan nilai sel dari sheet lain di VBA<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-adalah-numerik\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan IsNumeric untuk memeriksa apakah sel adalah angka di VBA<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk mengembalikan array dari suatu fungsi di VBA: Function GenerateRandom() As Integer() Dim RandValues(2) As Integer &#8216;generate three random integers and store them in array RandValues(0) = Int(Rnd * 100) RandValues(1) = Int(Rnd * 100) RandValues(2) = Int(Rnd * 100) &#8216;return array as a result of the function GenerateRandom [&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 mengembalikan array dari suatu fungsi - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengembalikan array dari suatu fungsi di VBA, dengan contoh lengkap.\" \/>\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-mengembalikan-array-dari-fungsi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara mengembalikan array dari suatu fungsi - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengembalikan array dari suatu fungsi di VBA, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-mengembalikan-array-dari-fungsi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T01:58:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableaure1.png\" \/>\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-mengembalikan-array-dari-fungsi\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-mengembalikan-array-dari-fungsi\/\",\"name\":\"VBA: Cara mengembalikan array dari suatu fungsi - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T01:58:55+00:00\",\"dateModified\":\"2023-07-08T01:58:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengembalikan array dari suatu fungsi di VBA, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-mengembalikan-array-dari-fungsi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-mengembalikan-array-dari-fungsi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-mengembalikan-array-dari-fungsi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara mengembalikan array dari suatu fungsi\"}]},{\"@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 mengembalikan array dari suatu fungsi - Statorials","description":"Tutorial ini menjelaskan cara mengembalikan array dari suatu fungsi di VBA, dengan contoh lengkap.","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-mengembalikan-array-dari-fungsi\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara mengembalikan array dari suatu fungsi - Statorials","og_description":"Tutorial ini menjelaskan cara mengembalikan array dari suatu fungsi di VBA, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/vba-mengembalikan-array-dari-fungsi\/","og_site_name":"Statorials","article_published_time":"2023-07-08T01:58:55+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableaure1.png"}],"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-mengembalikan-array-dari-fungsi\/","url":"https:\/\/statorials.org\/id\/vba-mengembalikan-array-dari-fungsi\/","name":"VBA: Cara mengembalikan array dari suatu fungsi - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T01:58:55+00:00","dateModified":"2023-07-08T01:58:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengembalikan array dari suatu fungsi di VBA, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-mengembalikan-array-dari-fungsi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-mengembalikan-array-dari-fungsi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-mengembalikan-array-dari-fungsi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara mengembalikan array dari suatu fungsi"}]},{"@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\/4775"}],"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=4775"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4775\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}