{"id":2157,"date":"2023-09-28T17:42:56","date_gmt":"2023-09-28T17:42:56","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/"},"modified":"2023-12-06T06:16:43","modified_gmt":"2023-12-06T06:16:43","slug":"fungsi-spreadsheet","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/","title":{"rendered":"Bagaimana cara menggunakan fungsi spreadsheet vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1413440012\"><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 class=\"wp-block-heading\"><strong>Catatan penting<\/strong><\/p><ul><li> Anda bisa menggunakan properti WorksheetFunction untuk mengakses fungsi lembar kerja untuk digunakan dalam makro.<\/li><\/ul><h2 class=\"wp-block-heading\"> Cara menggunakan fungsi lembar kerja di VBA saat menulis makro<\/h2><p> Gunakan langkah-langkah berikut untuk menggunakan fungsi lembar kerja di VBA.<\/p><ul><li> Pertama, tentukan sel yang ingin Anda masukkan nilai yang dikembalikan oleh fungsi tersebut. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-fungsi-lembar kerja-di-vba\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-feuille-de-calcul-en-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"worksheet-function-in-vba\" width=\"184\" height=\"130\"><\/li><li> Setelah itu gunakan tanda sama dengan (=) dan ketik Application.WorksheetFunction (seperti yang sudah bisa Anda lakukan di aplikasi Excel, Anda hanya bisa menggunakan WorksheetFunction). <br><img loading=\"lazy\" decoding=\"async\" title=\"2-gunakan-tanda-sama dengan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-un-signe-egal.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-an-equal-sign\" width=\"356\" height=\"136\"><\/li><li> Selanjutnya, Anda perlu memasukkan titik (.), dan saat Anda melakukannya, Anda akan mendapatkan daftar fungsi yang Anda miliki di spreadsheet. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-Anda-harus-memasukkan-titik\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-vous-devez-entrer-un-point.png\" sizes=\"auto, \" srcset=\"\" alt=\"you-need-to-enter-a-dot\" width=\"402\" height=\"159\"><\/li><li> Dari sini, mari gunakan fungsi TextJoin untuk menggabungkan teks di sel A1 dan B1. Sama seperti itu, Anda menggunakan fungsi di spreadsheet; saat Anda memasukkan tanda kurung awal, ini menunjukkan argumen yang perlu Anda tentukan di sel. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-gunakan-fungsi-textjoin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-utiliser-la-fonction-textjoin.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-the-textjoin-function\" width=\"583\" height=\"132\"><\/li><li> Seperti yang Anda lihat pada tangkapan layar di atas, ini menunjukkan argumen yang perlu Anda tentukan, tetapi bukan nama argumennya. Jadi, Anda perlu mengetahui argumennya sebelum menggunakannya. Berikut adalah argumen yang perlu Anda gunakan di TextJoin. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-argumen-sebelum-menggunakan-testjoin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-argument-avant-dutiliser-testjoin.png\" sizes=\"auto, \" srcset=\"\" alt=\"arguement-before-using-testjoin\" width=\"330\" height=\"70\"><\/li><li> Sekarang mari kita masukkan argumen ke dalam fungsinya. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-masukkan-argumen-ke-fungsi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-entrer-un-argument-dans-la-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-arguement-in-the-function\" width=\"506\" height=\"114\"><ol><li> batasi: \u00bb \u00ab<\/li><li> abaikan_kosong: Benar<\/li><li> teks1: Rentang (\u201cA1\u201d)<\/li><li> teks2: Rentang (\u201cB1\u201d)<\/li><\/ol><\/li><\/ul><p> Berikut kode lengkapnya.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub MyMacro() Range(\"A1\") = _ Application.WorksheetFunction.TextJoin _ (\" \", True, Range(\"A2\"), Range(\"A3\")) End Sub<\/code><\/pre><p> Ada total 387 <a href=\"https:\/\/exceladvisor.org\/id\/fungsi-excel\/\">fungsi lembar kerja<\/a> yang bisa Anda gunakan di VBA. Namun ada beberapa fungsi (Contoh: <a href=\"https:\/\/exceladvisor.org\/id\/fungsi-string-excel\/\">LEFT<\/a> ) yang tidak tersedia.<\/p><p> Alasan? Ada <a href=\"https:\/\/exceladvisor.org\/id\/fungsi\/\">fungsi bawaan di VBA<\/a> yang dapat Anda gunakan saat menulis kode VBA. Mari kita lihat apakah Anda ingin menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/kotak-pesan-vba\/\">kotak pesan<\/a> untuk mendapatkan nilai suatu fungsi. Katakanlah Anda ingin mendapatkan nilai maksimum dari rentang bernama &#8220;myValues&#8221;.<\/p><p> Kodenya adalah:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub MyMacro() MsgBox Prompt:=WorksheetFunction.Max(Range(\"myValues\")) End Sub<\/code><\/pre><p> Dan inilah cara Anda mendapatkan kotak pesan: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51651\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-plages-nommees-myvalues.png\" sizes=\"auto, \" srcset=\"\" alt=\"bernama-rentang-nilai saya\" width=\"345\" height=\"255\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Aplikasi.Fungsi Lembar Kerja vs Aplikasi<\/h2><p> Ada dua cara berbeda untuk merujuk ke fungsi lembar kerja. Di bawah ini adalah dua baris kode berbeda yang melakukan aktivitas yang sama. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51652\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-feuille-de-calcul-dapplication-fonction-vs-application.png\" sizes=\"auto, \" srcset=\"\" alt=\"aplikasi-lembar kerjafungsi-vs-aplikasi\" width=\"536\" height=\"275\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub MyMacro() MsgBox Prompt:= _ Application.WorksheetFunction.Max(Range(\"myValues\")) MsgBox Prompt:= _ Application.Max(Range(\"myValues\")) End Sub<\/code><\/pre><p> Namun ada keuntungan menggunakan cara kedua. Ini mengembalikan kode kesalahan alih-alih menampilkan kesalahan secara langsung.<\/p><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\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/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\/id\/rata-rata-2\/\">Nilai rata-rata di Excel dengan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tanggal-hari-ini-waktu-saat-ini\/\">Dapatkan tanggal hari ini dan waktu saat ini menggunakan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-1\/\">Jumlahkan nilai di Excel menggunakan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pertandingan-2\/\">Fungsi kecocokan di VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/angka-acak\/\">Nomor acak VBA<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-2157","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>\u25b7Bagaimana cara menggunakan fungsi spreadsheet VBA?<\/title>\n<meta name=\"description\" content=\"Tutorial ini menunjukkan kepada Anda cara mengakses fungsi evaluasi dan penggunaan spreadsheet dalam kode VBA.\" \/>\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\/id\/fungsi-spreadsheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7Bagaimana cara menggunakan fungsi spreadsheet VBA?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menunjukkan kepada Anda cara mengakses fungsi evaluasi dan penggunaan spreadsheet dalam kode VBA.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-feuille-de-calcul-en-vba.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/\",\"name\":\"\u25b7Bagaimana cara menggunakan fungsi spreadsheet VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-feuille-de-calcul-en-vba.png\",\"datePublished\":\"2023-09-28T17:42:56+00:00\",\"dateModified\":\"2023-12-06T06:16:43+00:00\",\"description\":\"Tutorial ini menunjukkan kepada Anda cara mengakses fungsi evaluasi dan penggunaan spreadsheet dalam kode VBA.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-feuille-de-calcul-en-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-feuille-de-calcul-en-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan fungsi spreadsheet vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7Bagaimana cara menggunakan fungsi spreadsheet VBA?","description":"Tutorial ini menunjukkan kepada Anda cara mengakses fungsi evaluasi dan penggunaan spreadsheet dalam kode VBA.","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\/id\/fungsi-spreadsheet\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7Bagaimana cara menggunakan fungsi spreadsheet VBA?","og_description":"Tutorial ini menunjukkan kepada Anda cara mengakses fungsi evaluasi dan penggunaan spreadsheet dalam kode VBA.","og_url":"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:43+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-feuille-de-calcul-en-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/","url":"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/","name":"\u25b7Bagaimana cara menggunakan fungsi spreadsheet VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-feuille-de-calcul-en-vba.png","datePublished":"2023-09-28T17:42:56+00:00","dateModified":"2023-12-06T06:16:43+00:00","description":"Tutorial ini menunjukkan kepada Anda cara mengakses fungsi evaluasi dan penggunaan spreadsheet dalam kode VBA.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-feuille-de-calcul-en-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-de-feuille-de-calcul-en-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan fungsi spreadsheet vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2157","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=2157"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2157\/revisions"}],"predecessor-version":[{"id":2553,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2157\/revisions\/2553"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}