{"id":2149,"date":"2023-09-28T21:57:26","date_gmt":"2023-09-28T21:57:26","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/bidang-masuk\/"},"modified":"2023-12-06T06:18:33","modified_gmt":"2023-12-06T06:18:33","slug":"bidang-masuk","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/bidang-masuk\/","title":{"rendered":"Bagaimana cara menggunakan kotak input di vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-778354806\"><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>Seperti namanya, Kotak Input adalah fungsi yang menampilkan kotak input kepada pengguna dan mengumpulkan respons.<\/p><p> Lihat contoh di bawah ini dimana kita mempunyai kotak input yang menanyakan nama Anda dan ada kotak input untuk memasukkannya. Jika Anda melihat bilah judul yang terlihat seperti bilah pesan, kami memiliki judul yang bertuliskan &#8220;Masukkan nama&#8221; dan pesannya bertuliskan &#8220;Siapa nama Anda?&#8221; &#8220;. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62133\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-champ-de-saisie-en-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"kotak masukan di vba\" width=\"517\" height=\"224\"><\/figure><\/div><p> Berikut ini sintaks kotak input VBA: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62134\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-syntaxe-de-la-zone-de-saisie-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-kotak-input-sintaks\" width=\"684\" height=\"119\"><\/figure><\/div><p> InputBox(Prompt[Judul] [Default] [Kiri] [Atas] [HelpFile, HelpContextID] [Jenis])<\/p><ol type=\"1\"><li> <strong>Prompt<\/strong> : Pada prompt, Anda dapat menentukan pesan yang ingin Anda tampilkan di kotak input. Anda dapat menggunakan maksimal 1024 karakter di sana.<\/li><li> <strong>[Judul]<\/strong> : Sebuah string yang ditampilkan di bilah judul area input. Jika Anda mengabaikan judulnya, nama aplikasi akan ditempatkan di bilah judul.<\/li><li> <strong>[Default]<\/strong> : Ini adalah teks default yang ingin Anda miliki di bilah input default untuk ditampilkan kepada pengguna.<\/li><li> <strong>[XPos]<\/strong> : Angka yang mewakili (posisi sumbu X) jarak prompt dari sisi kiri layar secara horizontal dan jika dibiarkan kosong, area input akan dipusatkan secara horizontal.<\/li><li> <strong>[YPos]<\/strong> : Angka yang mewakili (posisi sumbu Y) jarak prompt dari sisi kiri layar secara horizontal dan jika dibiarkan kosong, area input akan dipusatkan secara horizontal.<\/li><li> <strong>[Helpfile]<\/strong> : Untuk menentukan file bantuan bagi pengguna. Pengguna dapat mengakses file bantuan ini menggunakan tombol bantuan.<\/li><li> <strong>[konteks]<\/strong> : Ekspresi numerik yang mengidentifikasi nomor konteks bantuan yang ditetapkan dan jika konteks disediakan, file bantuan juga harus disediakan.<\/li><\/ol><p> Semua argumen dalam tanda kurung siku bersifat opsional. Jika Anda mengabaikan salah satu argumen tersebut, Anda masih dapat menggunakan fungsi kotak masukan, namun dalam sebagian besar kasus, Anda tidak perlu menggunakan lebih dari tiga argumen pertama.<\/p><h2 class=\"wp-block-heading\"> Cara menggunakan kotak input dalam kode VBA<\/h2><ol type=\"1\"><li> Ketik &#8220;InputBox&#8221; dan masukkan spasi dan Anda akan mendapatkan alat untuk argumen yang perlu Anda atur.<\/li><li> Tentukan pesan \u201cPrompt\u201d yang ingin Anda tampilkan kepada pengguna.<\/li><li> Tetapkan judul untuk kotak masukan, jika tidak maka judul default akan ditampilkan.<\/li><li> Sebutkan teks yang ingin Anda miliki di bilah input default. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12601 size-large\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/utiliser-la-boite-de-saisie-via-vba-1024x490.png\" alt=\"gunakan-kotak-masukan-melalui-vba\" width=\"678\" height=\"324\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/utiliser-la-boite-de-saisie-via-vba-1024x490.png 1024w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/utiliser-la-boite-de-saisie-via-vba-300x144.png 300w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/utiliser-la-boite-de-saisie-via-vba-768x368.png 768w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/utiliser-la-boite-de-saisie-via-vba.png 1260w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\"><\/figure><\/div><p> Dan ketika Anda menjalankan kode ini, ia akan menampilkan kotak input seperti ini: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62136\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Code-de-boite-de-saisie-a-4-executions.png\" sizes=\"auto, \" srcset=\"\" alt=\"jalankan-kode-kotak-masukan\" width=\"504\" height=\"218\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Contoh penggunaan kotak input VBA di Excel<\/h2><p> Anda mungkin bertanya-tanya bagaimana cara menggunakan kotak input di dunia nyata. Dalam contoh berikut, saya telah membagikan contoh sederhana namun kuat.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_input_box() 'variable to store the count of rows. Dim iRow As Long 'get the count cells that are filled iRow = WorksheetFunction.CountA(Range(\"A:A\")) 'get to the next blank cell in column A Cells(iRow + 1, 1).Select 'enter the value from the input box into the active cell ActiveCell = InputBox(\"What is your name?\", \"Enter Name\") End Sub<\/code><\/pre><p> Kode di atas memasukkan nama pada kolom A satu per satu. Ini menghitung sel yang terisi di kolom dan berpindah ke sel kosong berikutnya. Setelah itu, ambil nilai dari kotak input dan masukkan di sini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62137\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-exemple-dutilisation-de-la-zone-de-saisie-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"contoh penggunaan kotak input vba\" width=\"674\" height=\"403\"><\/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\/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\/sorot-nilai-duplikat\/\">Sorot nilai duplikat menggunakan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/ekstrak-hyperlink\/\">Ekstrak alamat hyperlink (URL) VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/file-teks\/\">VBA membuat dan menulis ke file teks<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pembaruan-layar\/\">Pembaruan Layar VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/bilah-status-1\/\">Bilah status VBA (sembunyikan, tampilkan, dan kemajuan)<\/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-2149","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>Bagaimana cara menggunakan kotak input di VBA? - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Seperti namanya, Kotak Input adalah fungsi yang menampilkan kotak input kepada pengguna dan mengumpulkan respons.\" \/>\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\/bidang-masuk\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan kotak input di VBA? - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Seperti namanya, Kotak Input adalah fungsi yang menampilkan kotak input kepada pengguna dan mengumpulkan respons.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/bidang-masuk\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-champ-de-saisie-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\/bidang-masuk\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/bidang-masuk\/\",\"name\":\"Bagaimana cara menggunakan kotak input di VBA? - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bidang-masuk\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bidang-masuk\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-champ-de-saisie-en-vba.png\",\"datePublished\":\"2023-09-28T21:57:26+00:00\",\"dateModified\":\"2023-12-06T06:18:33+00:00\",\"description\":\"Seperti namanya, Kotak Input adalah fungsi yang menampilkan kotak input kepada pengguna dan mengumpulkan respons.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bidang-masuk\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/bidang-masuk\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bidang-masuk\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-champ-de-saisie-en-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-champ-de-saisie-en-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bidang-masuk\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan kotak input di 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":"Bagaimana cara menggunakan kotak input di VBA? - Penasihat Excel","description":"Seperti namanya, Kotak Input adalah fungsi yang menampilkan kotak input kepada pengguna dan mengumpulkan respons.","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\/bidang-masuk\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan kotak input di VBA? - Penasihat Excel","og_description":"Seperti namanya, Kotak Input adalah fungsi yang menampilkan kotak input kepada pengguna dan mengumpulkan respons.","og_url":"https:\/\/exceladvisor.org\/id\/bidang-masuk\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:33+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-champ-de-saisie-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\/bidang-masuk\/","url":"https:\/\/exceladvisor.org\/id\/bidang-masuk\/","name":"Bagaimana cara menggunakan kotak input di VBA? - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/bidang-masuk\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/bidang-masuk\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-champ-de-saisie-en-vba.png","datePublished":"2023-09-28T21:57:26+00:00","dateModified":"2023-12-06T06:18:33+00:00","description":"Seperti namanya, Kotak Input adalah fungsi yang menampilkan kotak input kepada pengguna dan mengumpulkan respons.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/bidang-masuk\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/bidang-masuk\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/bidang-masuk\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-champ-de-saisie-en-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-champ-de-saisie-en-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/bidang-masuk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan kotak input di 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\/2149","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=2149"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2149\/revisions"}],"predecessor-version":[{"id":2739,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2149\/revisions\/2739"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}